Re: pg_restore out of memory

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
> service.

How would I run it manually?
When I do pg_ctl start, no output ever goes to the screen.
I also looked at the freebsd startup script. It also uses pg_ctl.

Do I just need to send "-l <filename>" to pg_ctl?
According to the man page the default is to send output to /dev/null.

It does seem like -l will redirect to file so going to try that.

man pg_ctl
...
In start mode, a new server is launched. The server is started in the
background, and standard input is attached to /dev/null. The standard
output and standard error are either appended to a log file (if the -l
option is used), or redirected to pg_ctl's standard output (not
stan-dard error).
...