From: | gl(at)lbn(dot)fr |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pg_dump: missing pg_database entry |
Date: | 2006-06-12 13:38:11 |
Message-ID: | 1150119491.505043.277730@f14g2000cwb.googlegroups.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)dial-bdd1:~$ pg_dump maf
pg_dump: missing pg_database entry for database "maf"
does not work,but:
postgres(at)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kenneth Downs | 2006-06-12 15:08:31 | Re: are there static variables in pgsql? |
Previous Message | Alejandro Michelin Salomon ( Adinet ) | 2006-06-12 13:20:02 | RES: Fabian Pascal and RDBMS deficiencies in fully |