From: | Rebecca Clarke <r(dot)clarke83(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | .pgpass not working |
Date: | 2012-05-04 16:30:31 |
Message-ID: | CAMChtdd-cc3shOc7Xdq=ee=O65mW3Dw51cCqvVvQJmcveB3b=A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-05-04 16:54:17 | Re: .pgpass not working |
Previous Message | Michael Nolan | 2012-05-04 16:27:40 | Re: Streaming replication: sequences on slave seemingly ahead of sequences on master |