Re: File system level backup - Mailing list pgsql-admin

From Jamie Lawrence
Subject Re: File system level backup
Date
Msg-id 20031022022503.GA28374@clueinc.net
Whole thread Raw
In response to Re: File system level backup  ("Ganesan Kanavathy" <ganesh@magnusquest.com>)
List pgsql-admin
> 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@jal.org
Helpful Hint: Unbreakable toys can be used to break other toys.



pgsql-admin by date:

Previous
From: Jeff
Date:
Subject: Re: Need PGSQL ODBC Driver for Solaris
Next
From: Fred Vos
Date:
Subject: Visibility of objects in other schema's