Re: backups

Поиск
Список
Период
Сортировка
От mcelroy, tim
Тема Re: backups
Дата
Msg-id 0C4841B42F87D51195BD00B0D020F5CB044B264B@MORPHEUS
обсуждение исходный текст
Ответ на backups  ("mcelroy, tim" <tim.mcelroy@bostonstock.com>)
Ответы Re: backups  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-admin

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@wolff.to]
Sent:   Wednesday, May 10, 2006 3:12 PM
To:     mcelroy, tim
Cc:     'Scott Marlowe'; 'pgsql-admin@postgresql.org'
Subject:        Re: backups

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 по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: backups
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: backups