469,090 Members | 1,182 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,090 developers. It's quick & easy.

database failure..


Hi,

I have a database, which just happens to be the main database on a
RAQ4..(cobalt)
that even when recreated it still dies, even before readding any
tables..

Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

cobalt=# \d
The connection to the server was lost. Attempting reset: Succeeded.

I can't dump either..

getTables(): SELECT failed. Explanation from backend: 'pqReadData() --
backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
'.

Any idea what might be causing this?

Regards

Jason Frisch

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
2 2583
On Sun, 14 Dec 2003, Ausrack Webmaster wrote:

Hi,

I have a database, which just happens to be the main database on a
RAQ4..(cobalt)
that even when recreated it still dies, even before readding any
tables..

Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

cobalt=# \d
The connection to the server was lost. Attempting reset: Succeeded.

I can't dump either..

getTables(): SELECT failed. Explanation from backend: 'pqReadData() --
backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
'.

Any idea what might be causing this?


anything in the logs? hardware failure maybe? what version of database?

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ: 7615664

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 12 '05 #2


[root /tmp]# psql -V
psql (PostgreSQL) 7.0.2
contains readline, history, multibyte support
Portions Copyright (c) 1996-2000, PostgreSQL, Inc
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.

Nothing at all in the logs...How do I change the debugging/log level to
show more?

NB. a few of the DBs on the server dont have any problems at all...

Jason

-----Original Message-----
From: Marc G. Fournier [mailto:sc*****@postgresql.org]
Sent: Sunday, December 14, 2003 8:00 PM
To: Ausrack Webmaster
Cc: pg***********@postgresql.org
Subject: Re: [GENERAL] database failure..
On Sun, 14 Dec 2003, Ausrack Webmaster wrote:

Hi,

I have a database, which just happens to be the main database on a
RAQ4..(cobalt)
that even when recreated it still dies, even before readding any
tables..

Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

cobalt=# \d
The connection to the server was lost. Attempting reset: Succeeded.

I can't dump either..

getTables(): SELECT failed. Explanation from backend: 'pqReadData()
-- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
'.

Any idea what might be causing this?


anything in the logs? hardware failure maybe? what version of
database?

----
Marc G. Fournier Hub.Org Networking Services
(http://www.hub.org)
Email: sc*****@hub.org Yahoo!: yscrappy ICQ:
7615664

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by pginfo | last post: by
2 posts views Thread by Ausrack Webmaster | last post: by
5 posts views Thread by Campano, Troy | last post: by
18 posts views Thread by Asif | last post: by
7 posts views Thread by dubdave | last post: by
7 posts views Thread by erikcw | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.