Re: Pg_dump uses up RAM and swap space

Поиск
Список
Период
Сортировка
От Justin Clift
Тема Re: Pg_dump uses up RAM and swap space
Дата
Msg-id 3DE6A8E4.8667A39B@postgresql.org
обсуждение исходный текст
Ответ на Pg_dump uses up RAM and swap space  (Szabó Roland <szroland@mithrandir.hu>)
Список pgsql-bugs
Hi Roland,

Szabó Roland wrote:
>
> Hi!
>
> Reading the archives I understand this is a problem of postgres version
> prior 7.1, and I'm experiencing the very same error as Steve Riley
> reported last month. I saw that the suggestion was to use 7.2, but I'm
> not sure you meant dump 7.1 database from 7.1 backend using 7.2 pg_dump.
> We have approx. 1.5 Gb of data in a 7.1 database, and would not like to
> loose it, but cannot dump it with 7.1.

Well, just to make sure you're safe, before testing anything you should
at least make a backup of the entire PostgreSQL $PGDATA directory (*with
PostgreSQL not running!*).

That way, if anything does go wrong, you can always copy this backup
into place and um.. try again (but differently of course).

:-)

Regards and best wishes,

Justin Clift


> If this is the way to go, please
> confirm that.
> Thank you for your time.
>
> Roland Szabo
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
   - Indira Gandhi

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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Pg_dump uses up RAM and swap space
Следующее
От: elein
Дата:
Сообщение: Fwd: [GENERAL] returning CHAR from C function