티스토리 뷰

오류


FATAL: Peer authentication failed for user "postgres"


The problem is still your pg_hba.conf file (/etc/postgresql/9.1/main/pg_hba.conf). This line:


local   all             postgres                                peer



를 





local   all             postgres                                md5


이렇게 변경



trust - anyone who can connect to the server is authorized to access the database

peer - use client's operating system user name as database user name to access it.

md5 - password-base authentication

'PostgreSQL' 카테고리의 다른 글

[PostgreSQL] isnull() 대신하는 coalesce()  (0) 2016.08.10
댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
Today
Yesterday
링크
«   2024/05   »
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31
글 보관함