Home > mailing lists

Thread: Automate Postgres Backup In windows

Automate Postgres Backup In windows

From

Shaun Clements

Date:

02 June 2005, 13:54:37

I am trying to automate a postgres database data and schema dump through windows.

Does anyone have any suggestions on best way to do so.

Thanks

A {FONT-FAMILY: verdana; TEXT-DECORATION: none } A:active {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:link {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:visited {COLOR: #003366; FONT-FAMILY: verdana; TEXT-DECORATION: none } A:hover {COLOR: #ff0000; FONT-FAMILY: verdana; TEXT-DECORATION: underline } .small_text {FONT-SIZE: 9px; COLOR: #003366; FONT-FAMILY: verdana } Kind Regards,
Shaun Clements

Re: Automate Postgres Backup In windows

From

Richard Huxton

Date:

03 June 2005, 07:20:35

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