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@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Ganesan Kanavathy
> Sent: Friday, October 17, 2003 5:14 PM
> To: pgsql-admin@postgresql.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073