Re: backups

Excellent point Bruno, thanks. I must admit that I did think of that and
have already copied all my .conf files to the backup directory. I should
have noted that earlier.

Thanks,
Tim

-----Original Message-----
From: Bruno Wolff III [mailto:bruno(at)wolff(dot)to]
Sent: Wednesday, May 10, 2006 3:12 PM
To: mcelroy, tim
Cc: 'Scott Marlowe'; 'pgsql-admin(at)postgresql(dot)org'
Subject: Re: backups

On Wed, May 10, 2006 at 11:56:20 -0400,
"mcelroy, tim" <tim(dot)mcelroy(at)bostonstock(dot)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.