On 01/23/2004-10:18AM, Joshua D. Drake wrote: > > XFS also has the interesting ability (although I have yet to test it) > that will allow you > to take a snapshot of the filesystem. Thus you can have filesystem level > backups > of the PGDATA directory that are consistent even though the database is > running.
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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
