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…
Regards,
Chris Campbell
Cascade Data Solutions, Inc.
ccampbell@CascadeDS.com
(800) 280-2090