On Wed, 22 Oct 2003 09:12:40 +0800 "Ganesan Kanavathy" <[EMAIL PROTECTED]> wrote:
> All the while I was doing pg_dump as backup method for my pgsql db. > Today I came across File system level backup on Postgresql > Documentation. > If you do a filesystem level backup the only "safe" way to do this is to either stop postgres and then backup, or if you are using a logical volume manager take a snapshot. You cannot just "tar" a "live" pgdata directory as the contents will change as tar goes through each file and you'll be left with a corrupt database. -- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/ ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
