Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly

Lee Joramo <lee.list@joramo.com> writes:
> I have looked for a proper log file, and can find own. On inspecting the
> startup script it looks like postmaster is being involved with the
> following command:
>
>    su -l postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'

-S suppresses all log output, so first you need to get rid of that.
A more useful startup script would go like


  su -l postgres -c \
  '/usr/bin/postmaster -i -D/var/lib/pgsql >/path/to/logfile 2>&1 &'

Note the trailing & to get it to run in background --- you need that
when you don't use -S.

            regards, tom lane