psql4 * No PostgreSQL clusters exist; see "man pg_createcluster" * No PostgreSQL clusters exist; see "man pg_createcluster" locale 확인 sudo dpkg-reconfigure locales Afterpg_createcluster 9.X main --start 2016. 7. 25. psql: FATAL: Peer authentication failed for user taiga@ubuntu:~$ psql -U testUser -W testDB -h localhost psql: FATAL: Peer authentication failed for user 옵션에 -h localhost를 붙여준다. 2016. 6. 27. create database in postgresql #DB 생성create database testDB with encoding 'unicode' LC_COLLATE 'C' LC_CTYPE 'C' template template0; #DB Owner 변경alter database testDB owner to testUser; 2016. 6. 27. postgresql user list taiga=# \du List of roles Role name | Attributes | Member of-----------+------------------------------------------------+----------- postgres | Superuser, Create role, Create DB, Replication | {} taiga | Superuser, Create role, Create DB | {} 2016. 6. 27. 이전 1 다음