Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

Next:From: damien clochardDate: 2011-08-31 21:24:49
Subject: Re: Postgres 9.0.4 / Installation problem - Ubuntu 11.04 - 64bits
Previous:From: Daniel CintraDate: 2011-08-31 20:40:41
Subject: Postgres 9.0.4 / Installation problem - Ubuntu 11.04 - 64bits

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group