Thanks Richard.
For anyone interested
The link Richard was referring to can be found below.
http://www.postgresql.org/docs/8.0/interactive/libpq-pgpass.Html
Kind Regards,
Shaun Clements
-----Original Message-----
From: Richard Huxton [mailto:dev@archonet.com]
Sent: 03 June 2005 09:20 AM
To: Shaun Clements
Cc: List
Subject: Re: [GENERAL] Automate Postgres Backup In windows
Shaun Clements wrote:
> Problem there is the pg_dump requires a password.
Ah - you'll be wanting the ".pgpass" password file - there's a section in the manuals under Client Interfaces/libpq
Not the place you'd first look, I'll admit.
Oh - might be worth googling for .pgpass and windows in case there are any differences from *nix.
--
Richard Huxton
Archonet Ltd