Re: pg_restore out of memory - Mailing list pgsql-general

From Francisco Reyes
Subject Re: pg_restore out of memory
Date
Msg-id cone.1181921150.10404.53974.5001@35st.simplicato.com
Whole thread Raw
In response to pg_restore out of memory  (Francisco Reyes <lists@stringsutils.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: DeadLocks..., DeadLocks...
Next
From: MC Moisei
Date:
Subject: Re: Postmaster processes taking all the CPU