Automate Postgres Backup In windows

Started by Shaun Clementsalmost 21 years ago2 messagesgeneral
Jump to latest
#1Shaun Clements
ShaunC@relyant.co.za

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

Kind Regards,
Shaun Clements

#2Richard Huxton
dev@archonet.com
In reply to: Shaun Clements (#1)
Re: 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