On-line backup - Mailing list pgsql-admin

Hi Tom,

Is this 2003 advice still relevant with postgresql 8.1.0?   Our b-tree
indexes corrupt pretty often on our production server running 8.1.0 and we
are grasping for a solution.  We perform online backups like this:  In
addition, we archive the transactions and replay them for PITR.

/usr/local/pgsql.v810/bin/psql -p 5442 -d postgres -c "SELECT
pg_start_backup('share.sqldumps.Linux.pgsql.serf.base.backup');"
sleep 20
/bin/tar -zcvf /sprj/sqldumps_Linux.pgsql_serf5442/base.backup.serf.`date
'+d%m%d%Y'`.tar.gz /anothershare/Linux.pgsql/serf5442/*
sleep 30
/usr/local/pgsql.v810/bin/psql -p 5442 -d postgres -c "SELECT
pg_stop_backup();"

http://archives.postgresql.org/pgsql-general/2003-04/msg00655.php

Thanks,
~DjK