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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lee Joramo <lee(dot)list(at)joramo(dot)com>
Cc: rob <rob(at)cabrion(dot)com>, postgre general list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly
Date: 2001-01-09 18:09:31
Message-ID: 1767.979063771@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Lee Joramo <lee(dot)list(at)joramo(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-01-09 18:09:40 Re: Does Postgresql deadlock?
Previous Message Luis Quintano 2001-01-09 18:03:37 Inheritance and Defaults