>You can do snapshots in FreeBSD 5.x with UFS2 as well but that (
>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.
>
>
Ahh... isn't that what fsync is for?
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL