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

Reply via email to