Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly
Date
Msg-id 1767.979063771@sss.pgh.pa.us
Whole thread Raw
In response to Re: COPY error: pqReadData() -- backend closed the channel unexpectedly  (Lee Joramo <lee.list@joramo.com>)
Responses Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly
Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly
List pgsql-general
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

pgsql-general by date:

Previous
From: T F
Date:
Subject: Does Postgresql deadlock?
Next
From: Bruce Momjian
Date:
Subject: Re: Does Postgresql deadlock?