Re: pg_restore out of memory

Поиск
Список
Период
Сортировка
От Francisco Reyes
Тема Re: pg_restore out of memory
Дата
Msg-id cone.1181921150.10404.53974.5001@35st.simplicato.com
обсуждение исходный текст
Ответ на pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
Список pgsql-general
Alvaro Herrera writes:

> This is pg_restore's stderr.  What Tom wants to see is postmaster's.  It
> is probably redirected (hopefully to a file, but regretfully it is
> common to see it go to /dev/null) on the init script that starts the

pg_ctl -l <file> didn't work.

Trying now with changes to postgreql.conf:
redirect_stderr = on
log_directory = '/data/logs'
log_filename = 'postgresql-%Y-%m-%d.log
log_error_verbosity = verbose

And increased all error levels to debug1

That looks promissing already.. see errors going to the file.
Trying again. will be a few hours before it gets to the line where it runs
out of memory.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: DeadLocks..., DeadLocks...
Следующее
От: MC Moisei
Дата:
Сообщение: Re: Postmaster processes taking all the CPU