Re: 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.

You have to look at your needs.

> Furthermore, do we really need to do File system level backup or pg_dump
> is good enough?

File system level backup is typically complicated to design, and is
specific to your needs.

pg_dump is nearly universally usable, but might not meet your needs, if
you are a 24x7 shop. Online backup is almost always specific to your
site, usually a big deal to set up, and rarely impossible.

> Any suggestion is much appreciated.

Without more information about what you're doing, I can't say anything
more. But most likely, pg_dump will work for you. It covers most cases.

-j

--
Jamie Lawrence jal(at)jal(dot)org
Helpful Hint: Unbreakable toys can be used to break other toys.