.pgpass not working
От | Rebecca Clarke |
---|---|
Тема | .pgpass not working |
Дата | |
Msg-id | CAMChtdd-cc3shOc7Xdq=ee=O65mW3Dw51cCqvVvQJmcveB3b=A@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: .pgpass not working
Re: .pgpass not working |
Список | pgsql-general |
Hi
Apologies in advance if this is the wrong place to ask.
I have Postres 8.4 and I am setting up replication with Slony.
I'm having password issues with slony.
I have roamed the net for a solution and the way to fix it is to use the .pgpass file or change pg_hba.conf to accept trusted connections.
I do not want to touch the pg_hba.conf so I have generated the .pgpass file.
The permissions is set to 600, and I have correctly inputted the details into .pgpass, there are no leading spaces.
myhostname:myport:*:postgres:mypassword
However I am still prompted for a password.
I have tested pg_dump as well and it prompts also.
Does anyone have any suggestions on what may be the culprit. Is there somewhere I need to specify to tell the system to look into the .pgpass file?
many thanks
rebecca
В списке pgsql-general по дате отправления: