Re: OT (slightly): recommended procedure for backing up Postrgesql 7.0.3

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" <steve.brett@e-mis.com> wrote in message news:20010824132641.52125.qmail@pb1.pair.com... > 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" <brad@congosystems.com> wrote in message > news:01082421315200.01845@localhost.localdomain... > > Well, the subject really says it all. What procedures are people using to > > back up their Postgres databases? > > > > TIA, > > Brad > >