pg_dump: missing pg_database entry - Mailing list pgsql-general

From gl@lbn.fr
Subject pg_dump: missing pg_database entry
Date
Msg-id 1150119491.505043.277730@f14g2000cwb.googlegroups.com
Whole thread Raw
Responses Re: pg_dump: missing pg_database entry
Re: pg_dump: missing pg_database entry
List pgsql-general
Hello,

I'm experiencing a strange problem with PostgreSQL 7.4.9.
One of my database production servers has 2 large databases, it's still
possible to connect to them and pass queries, but the pg_database
system table is empty, which prohibits such actions as dumping the
databases.

For instance:

postgres@dial-bdd1:~$ pg_dump maf
pg_dump: missing pg_database entry for database "maf"

does not work,but:

postgres@dial-bdd1:~$ psql maf
Welcome to psql 7.4.9, 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

maf=#

This works, but the pg_database looks like it's empty:

maf=# select * from pg_database;
 datname | datdba | encoding | datistemplate | datallowconn |
datlastsysoid | datvacuumxid | datfrozenxid | datpath | datconfig |
datacl

---------+--------+----------+---------------+--------------+---------------+--------------+--------------+---------+-----------+--------
(0 rows)

I tried to repair the system indexes, but it doesn't work either...

Thanks in advance for your help.


pgsql-general by date:

Previous
From: "John Smith"
Date:
Subject: Re: ECPG and Curors.
Next
From: "James Watson"
Date:
Subject: Searching BLOB