qhrtnddk Site Dev

sudo vim /etc/default/oidentd -mf --address 127.0.0.1 sudo vim /etc/postgresql/9.3/main/pg_ident peer map=pg ident map=pg sudo vim /etc/postgresql/9.3/main/pg_hba pg vagrant postgres sudo su - postgres # How the change the locale of a PostgreSQL cluster # http://makandracards.com/makandra/18643-how-the-change-the-locale-of-a-postgresql-cluster psql CREATE ROLE user WITH LOGIN PASSWORD 'password'; \du git config --global user.emal "al8bright@gmail.com" git config --global user.name "al8bright" /bin/bash^M: bad interpreter set fileformat=unix set fileformat=dos mkdir /srv/perl5 sudo chown -R vagrant:vagrant /srv/perl5 eval $(perl -Mlocal::lib=/srv/perl5)

postgresql 설치후에 table 생성이 안될때.... FATAL:  role 'username'  does not exist 이런 에러가 나온다. 잘못된거 아니고 계정만 만들면 된다. 1. 계정 생성  sudo -u postgres createuser 'username'  2. table 생성 *createdb -U postgres -O 'username' -E utf-8 'tablename' 평범한 생성.가 *createdb -U postgres -O 'username' -E utf-8 --lc-collate=ko_KR.UTF-8 --lc-ctype=ko_KR.UTF-8 'tablename' 로케일 타입 지정. *createdb -U postgres -O 'username' -E utf-8 --lc-collate=ko_KR.UTF-8 --lc-ctype=ko_KR.UTF-8 -T 'copytable' 'tablename' 카피할 db 추가