Hello, (using Windows 7 Professional & a local install of PostgreSQL 9.0.4)
I'm trying to write a call to perform an automated backup using pg_Dump where there is no password prompt.
The error I keep getting is that it failed because I didn't supply a password.
The database name I'm trying to backup is called: dd3_000
The call string is:
"c:\program files (x86)\PostgreSQL\9.0\bin\PG_dump.exe" --create --no-password --format="c" --superuser="postgres" --username="postgres" --file="c:\temp\pg.backup" "dd3_000"
I read in an earlier post where there were two ways to do this. One way discussed was to use the pgpass.conf file, which I've created and looks like this:
localhost:5432:dd3_000:postgres:postgres (These are the out-of-the-box user name and password)
The contents of my pg_hba.conf are:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
I've rebooted after every little config change but still no luck on getting this to work.
Any suggestions would be greatly appreciated...
Cascade Data Solutions, Inc.
pgsql-novice by date
|Next:||From: damien clochard||Date: 2011-08-31 21:24:49|
|Subject: Re: Postgres 9.0.4 / Installation problem - Ubuntu 11.04
|Previous:||From: Daniel Cintra||Date: 2011-08-31 20:40:41|
|Subject: Postgres 9.0.4 / Installation problem - Ubuntu 11.04 - 64bits|