select failure - Mailing list pgsql-sql

From Ian Cass
Subject select failure
Date
Msg-id 083e01c20e29$7c99fdf0$6602a8c0@salamander
Whole thread Raw
Responses Re: select failure  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Ideas where I should look for the answer to this problem & how I should fix
it?

observer=# select host, current_route, count(current_route)
observer-# from messages_200205
observer-# group by host, current_route;
FATAL 2:  open of /var/lib/postgres/data/pg_clog/0534 failed: No such file
or directory
server closed the connection unexpectedly       This probably means the server terminated abnormally       before or
whileprocessing the request.
 
The connection to the server was lost. Attempting reset: NOTICE:  Message
from PostgreSQL backend:       The Postmaster has informed me that some other backend       died abnormally and
possiblycorrupted shared memory.       I have rolled back the current transaction and am       going to terminate your
databasesystem connection and exit.       Please reconnect to the database system and repeat your query.
 
Failed.

--
Ian Cass



pgsql-sql by date:

Previous
From: Achilleus Mantzios
Date:
Subject: Re: arrays as pgsql function parameters
Next
From: Jan Wieck
Date:
Subject: Re: UPDATE ... FROM vs standard SQL