From: | Chris Campbell <ccampbell(at)cascadeds(dot)com> |
---|---|
To: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Automated pg_Dump issue |
Date: | 2011-08-31 21:13:07 |
Message-ID: | 453A24085F801842AEA8D0B6B269065D011E41FD8412@HDMC.cds.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)CascadeDS(dot)com
(800) 280-2090
From | Date | Subject | |
---|---|---|---|
Next Message | damien clochard | 2011-08-31 21:24:49 | Re: Postgres 9.0.4 / Installation problem - Ubuntu 11.04 - 64bits |
Previous Message | Daniel Cintra | 2011-08-31 20:40:41 | Postgres 9.0.4 / Installation problem - Ubuntu 11.04 - 64bits |