Обсуждение: Core dump when connecting to database

**** Post for FREE via your newsreader at post.usenet.com ****

Pgsql Users,

I get the following message when trying to connect to database using psql or
the ODBC driver.

Connection to database 'warehouse' failed.
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.

and also a core dump in the 'warehouse' database directory. I can connect to
other databases normally.

I think the problem started when an admin user was creating a new view & had
trouble.

Can anyone help me with the syntax to get the postmaster to log more
information on the error to a file?

Is there any other way to get in & try to identify & fix the problems?

Thanks for any help you can give me,

Steve Shaffer
--





-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
 *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
                      http://www.usenet.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

Where are your postmaster logs going?  (where is your startup redirecting
stdout and stderr).  Those may have additional information.
Also, can you get a backtrace from the core file with gdb?

On Mon, 30 Oct 2000, S Shaffer wrote:

> **** Post for FREE via your newsreader at post.usenet.com ****
>
> Pgsql Users,
>
> I get the following message when trying to connect to database using psql or
> the ODBC driver.
>
> Connection to database 'warehouse' failed.
> pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backend terminated abnormally
>         before or while processing the request.
>
> and also a core dump in the 'warehouse' database directory. I can connect to
> other databases normally.
>
> I think the problem started when an admin user was creating a new view & had
> trouble.
>
> Can anyone help me with the syntax to get the postmaster to log more
> information on the error to a file?
>
> Is there any other way to get in & try to identify & fix the problems?
>
> Thanks for any help you can give me,