Re: backups - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: backups
Date
Msg-id 20060510191138.GA4099@wolff.to
Whole thread Raw
In response to Re: backups  ("mcelroy, tim" <tim.mcelroy@bostonstock.com>)
List pgsql-admin
On Wed, May 10, 2006 at 11:56:20 -0400,
  "mcelroy, tim" <tim.mcelroy@bostonstock.com> wrote:
> Thanks for the quick answer Scott.  I thought so but wanted to double-check.
> I was asked by the person who performs our system backups if just backing up
> the directory where I put the nightly backups (created with pg_dump) was
> enough.  I also have them backing up /var/lib/pgsql and everything under
> that and they're complaining that it's taking too long.  I would think we
> would also want to back up the pg_xlog directory though.  Or is that
> overkill?  Is there a standard in the PG community I should follow?  Is just
> performing the pg_dump and saving that to tape enough?  I just don't want to
> get bit in the butt if I tell him to not back something up that should be
> backed up.

You might want to make sure you have the configuration files backed up as well.

pgsql-admin by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Logging long queries: not all get logged
Next
From: "mcelroy, tim"
Date:
Subject: Re: backups