Re: File system level backup

pg_dump is fine, in fact better. For a file system backup, you have to
stop the postmaster, backup, then restart it.

---------------------------------------------------------------------------

Ganesan Kanavathy wrote:
> Please help me with question. So far no replies.
>
> Regards,
> ganesh
>
> -----Original Message-----
> From: pgsql-admin-owner(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Ganesan Kanavathy
> Sent: Friday, October 17, 2003 5:14 PM
> To: pgsql-admin(at)postgresql(dot)org
> Subject: [ADMIN] File system level backup
>
> Dear all,
>
> 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.
>
> After reading it, I am quite unsure whether File system level backup is
> better than pg_dump.
>
> Furthermore, do we really need to do File system level backup or pg_dump
> is good enough?
>
> Any suggestion is much appreciated.
>
> Regards,
> ganesh

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073