problem with table system

From: Loïc TREGOUËT <loic(at)cri74(dot)org>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: problem with table system
Date: 2000-09-21 17:39:38
Message-ID: 39CA47DA.11C9D737@cri74.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


When i try the command \dt or when i try to extract directly from the
system tables , i've the following error

docserv=> \dt
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.

Vacuum don't work :
docserv=> vacuum verbose analyze ;
NOTICE: CreatePortal: portal <vacuum> already exists
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
We have lost the connection to the backend, so further processing is
impossible. Terminati

Extract of postgres.log

StartTransactionCommand
query: SELECT usename, relname, relkind, relhasrules FROM pg_class,
pg_user WHERE usesysid = relowner and (
relkind = 'r' OR relkind = 'i' OR relkind = 'S') and relname !~ '^pg_'
and (relkind != 'i' OR relname !~ '^x
inx') ORDER BY relname
ProcessQuery
/usr/lib/postgresql/bin/postmaster: reaping dead processes...
/usr/lib/postgresql/bin/postmaster: CleanupProc: pid 25962 exited with
status 11
/usr/lib/postgresql/bin/postmaster: CleanupProc: reinitializing shared
memory and semaphores
shmem_exit(0) [#0]
binding ShmemCreate(key=52e389, size=2006016)

Thanks , Loic

Browse pgsql-admin by date

  From Date Subject
Next Message Gavin M. Roy 2000-09-21 21:58:38 PostgresQL Connection Question
Previous Message Stephan Szabo 2000-09-21 16:53:49 Re: Can't dump database