You can do snapshots in FreeBSD 5.x with UFS2 as well but that (Ahh... isn't that what fsync is for?
nor XFS snapshots ) will let you backup with the database server
running. Just because you will get the file exactly as it was at
a particular instant does not mean that the postmaster did not
still have some some data that was not flushed to disk yet.
-- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - [EMAIL PROTECTED] - http://www.commandprompt.com Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org