Thread: Automate Postgres Backup In windows

Automate Postgres Backup In windows

From
Shaun Clements
Date:
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:
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