Postgres Pro
Downloads
Home   >   mailing lists

Thread: pd_dumpall

pd_dumpall

From
"Raymund"
Date:

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

Re: pd_dumpall

From
Tom Lane
Date:
"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