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 | gzip > /backup/edb-backup_$backdate
cp /backup/edb-backup_$backdate /var/autofs/misc/ecalnet/
are the contents of the file dumpit.
this creates a gzipped dump of the database with a name of
edb-backup_200108240730 for example, then copies it to another directory.
HTH
Steve
"Steve Brett" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> 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 people using
to
> > back up their Postgres databases?
> >
> > TIA,
> > Brad
>
>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
