Title: RE: [GENERAL] Automate Postgres Backup In windows -> resolved
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 Mess
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 cas
Shaun Clements wrote:
Apologies if this post is a repeat.
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
Call pg_dump via a batch-file and run it from the Windows scheduler? Or
am I missing some
