Thread: Database does not exist in the system catalog - postgresql 7.2.1-5

Hello,

I have moved one of our sites from one machine to another that uses
postgres for it database. When I use the web site I get this:

Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1:
Database "ecad" does not exist in the system catalog

In the logs I get this:

FATAL 1:  Database "template0" is not currently accepting connections
FATAL 1:  Database "template0" is not currently accepting connections
...

I can use PgAdmin to connect to 'ecad' with out any problems. The way I
read the docs is this might be a authentication problem. I have this in
my pg_hba

Host     0.0.0.0     0.0.0.0     trust

I want it to be 'password' but doing that means I am unable to connect
with PgAdmin.

Do you have any pointers on how to attack this problem? Can I provide
more information concurring this? Also is this the right list for this
sort thing?

Thanks,
Rick Eicher II

"Rick Eicher II" <rick@pbol.net> writes:
> When I use the web site I get this:

> Warning: pg_connect() unable to connect to PostgreSQL server: FATAL 1:
> Database "ecad" does not exist in the system catalog

> I can use PgAdmin to connect to 'ecad' with out any problems. The way I
> read the docs is this might be a authentication problem.

No, it isn't.  I'm wondering if you have two different postmasters
running (on two machines, or two ports on one machine) and you are
confused about which postmaster is being connected to in each case.

            regards, tom lane