On Mon, 2 Aug 1999, Dmitry Morozovsky wrote:
> How can I organize automated database dumping for passord protected
> database?
If you're implying something like "How do I get around entering a
password?", that won't be solvable so easily. Possibly you want to use
ident authentication for that particular user and host or hardcode the
password in your (preferably read-protected) script. (If anyone has better
ideas here, let us know.)
Other than that a simple cron job calling pg_dump with appropriate
parameters should do.
A different solution would be to backup the $PGDATA/base directory using
regular file backup methods. That wouldn't be a dump, so it depends on
your particular needs.
--
Peter Eisentraut
PathWay Computing, Inc.
