Thread: Autogenerated backup of a password protected database

Autogenerated backup of a password protected database

From
Jamie Deppeler
Date:
Hi,

Since pg_dump doesnt support password is there a way that password can
be supplied -w option. Currently writting a application to do backups in
java as i need a solution that is cross platform. Any help would be
greatfully recieved.


Re: Autogenerated backup of a password protected database

From
Richard Huxton
Date:
Jamie Deppeler wrote:
> Since pg_dump doesnt support password is there a way that password can
> be supplied -w option. Currently writting a application to do backups in
> java as i need a solution that is cross platform. Any help would be
> greatfully recieved.

You can use a .pgpass or pgpass.conf file - see the section of the
manuals on libpq

--
   Richard Huxton
   Archonet Ltd