Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump still requires password - Mailing list pgsql-admin

From A.Bhuvaneswaran
Subject Re: pg_dump still requires password
Date
Msg-id 1068698575.1707.2.camel@Bhuvan.bksys.co.in
Whole thread Raw
In response to pg_dump still requires password  ("Ganesan Kanavathy" <ganesh@magnusquest.com>)
List pgsql-admin
Tree view 
> I have tried with pgpass but still it do
> es not work. I created the pgpass as per below:
>

Version? ~/.pgpass is supported since 7.3. Two more solutions are:
1) Set PGPASSWORD variable to avoid pg_dump asking for password
2) Set connection as trust in pg_hba.conf

regards,
bhuvaneswaran
regards, bhuvaneswaran
Attachment

pgsql-admin by date:

Previous
From: exciteworks hosting
Date:
Subject: easy way to copy all DBs and users on a server
Next
From: "A.Bhuvaneswaran"
Date:
Subject: Re: easy way to copy all DBs and users on a server