you can set up a job using cron that pg_dumps the date anywhere you need.
we use an automounted dir that links to a windoze server ...
Steve
Brad Hubbard [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Well, the subject really says it all. What procedures are
yup,
the postmaster should be running all the time in any case.
30 7-19/4,23 * * * /backup/dumpit
is the line i have in cron ( 30 mins past the hour between 7am and 7pm every
4 hours and again at 11pm )
and
#!/bin/sh
backdate=$(date +%Y%m%d%H%M.gz)
/usr/local/pgsql/bin/pg_dump edb |