Automated pg_Dump issue

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