| From: | Jeff <threshar(at)torgo(dot)978(dot)org> |
|---|---|
| To: | "Ganesan Kanavathy" <ganesh(at)magnusquest(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: File system level backup |
| Date: | 2003-10-22 12:38:00 |
| Message-ID: | 20031022083800.53139e66.threshar@torgo.978.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Wed, 22 Oct 2003 09:12:40 +0800
"Ganesan Kanavathy" <ganesh(at)magnusquest(dot)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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-10-22 13:39:53 | Re: Problems while starting DB |
| Previous Message | Sathish Somanathan | 2003-10-22 06:58:32 | Problems while starting DB |