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

Started by Rick Eicher IIover 23 years ago2 messagesgeneral
Jump to latest
#1Rick Eicher II
rick@pbol.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Rick Eicher II (#1)
Re: Database does not exist in the system catalog - postgresql 7.2.1-5

"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