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  ("Florian G. Pflug" <fgp@phlo.org>)
Re: pg_dump: missing pg_database entry  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "John Smith"
Дата:
Сообщение: Re: ECPG and Curors.
Следующее
От: "James Watson"
Дата:
Сообщение: Searching BLOB