Обсуждение: pd_dumpall
Hello,
Why did I get an error message like this:
[postgres@Prometheus data]$ pg_dumpall > 8-13alldb.bu
connected to template1...
dumping database "chatTv"...
dumping database "chattv"...
pg_dump: [archiver (db)] connection to database "chattv" failed: FATAL 1: Datab
ase "chattv" does not exist.
The database subdirectory '/usr/local/pgsql/data/base/16652' is missing.
pg_dump failed on chattv, exiting
Though the chatTv database exist and even works when I use “pg_dump chatTv” command.
Is there something wrong with my database configuration?
Thanks,
Raymund
"Raymund" <rasejo@amazing-lifestyles.com> writes:
> pg_dump: [archiver (db)] connection to database "chattv" failed: FATAL
> 1: Datab
> ase "chattv" does not exist.
> The database subdirectory '/usr/local/pgsql/data/base/16652' is
> missing.
So, is there such a directory?
It would be useful to see the output of
select oid,* from pg_database;
regards, tom lane