On 10/06/11 8:26 AM, Carlos Mennens wrote:
Yes I agree but I didn't know enough about PostgreSQL to make that
determination. Seems very logical however. Does anyone know of a
PostgreSQL backup script floating around the Internet for Linux
systems? I found a great one for MySQL but sadly that doesn't do me
any good.
/path/to/pg_dumpall | gzip > /path/to/pgbackup-$(date -I).sql.gz
put this in a script accessible by the postgres user, and in the
postgres user's crontab, invoke it something like..
30 1 * * * /path/to/backupscript
to run it every night at 1:30am. If you only want to run it once a week...
30 1 * * 6 /path/to/backupscript
which will run it on Saturday morning at 1:30am (day 6)
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
