pg_dump: missing pg_database entry
| От | gl@lbn.fr |
|---|---|
| Тема | pg_dump: missing pg_database entry |
| Дата | |
| Msg-id | 1150119491.505043.277730@f14g2000cwb.googlegroups.com обсуждение исходный текст |
| Ответы |
Re: pg_dump: missing pg_database entry
Re: pg_dump: missing pg_database entry |
| Список | 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 по дате отправления: