Re: pg_dump in a production environment

Поиск
Список
Период
Сортировка
От Chris Kratz
Тема Re: pg_dump in a production environment
Дата
Msg-id 200505240941.35338.chris.kratz@vistashare.com
обсуждение исходный текст
Ответ на Re: pg_dump in a production environment  (Scott Marlowe <smarlowe@g2switchworks.com>)
Список pgsql-general
On Monday 23 May 2005 06:09 pm, Scott Marlowe wrote:
> On Mon, 2005-05-23 at 16:54, Chris Kratz wrote:
> Are you folks running 8.0 with its improved caching algorithms?  Just
> wondering if that helps or not.

I should have noted that we are still using 7.4 on our production servers.  We
are planning an upgrade to 8.x later this year, so it is very plausible that
the new caching algorithms would help immensely.  We are planning on moving
to a backup off of a slony slave at that point as well, so the issue will
probably be moot for us though it would still be nice to be able to do a
backup off of a running production machine.

> Actually, there's a special dump program somewhere in the slony source
> tree, one of the perl scripts.  That should fix the issues with the
> backups.  I ran into it a while back and have to start using the same
> file.

Interesting, I didn't know that, thanks for the pointer.  We will look into
it.

-Chris
--
Chris Kratz

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Need input on postgres used for phpBB
Следующее
От: typing80wpm@aol.com
Дата:
Сообщение: how to unsubscribe