On Wed, 22 Oct 2003 09:12:40 +0800
"Ganesan Kanavathy" <ganesh@magnusquest.com> 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 <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/