Thread: 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,