Automated pg_Dump issue

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

Responses

Browse pgsql-novice by date

  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