Thread: FATAL 1: Database dbname=template1 does not exist in pg_database

FATAL 1: Database dbname=template1 does not exist in pg_database

From
Carsten Huettl
Date:
Hello again,

When I ty to access my pgsql with apache and php3 I got the following
error:

FATAL 1:  Database dbname=template1 does not exist in pg_database
When I connect with psql I can see template1.

How do I insert template1 into pg_database?

TIA
C.

Re: FATAL 1: Database dbname=template1 does not exist in pg_database

From
Tom Lane
Date:
Carsten Huettl <chuettl@ahorn-Net.de> writes:
> When I ty to access my pgsql with apache and php3 I got the following
> error:

> FATAL 1:  Database dbname=template1 does not exist in pg_database
> When I connect with psql I can see template1.

> How do I insert template1 into pg_database?

Read it again: the error message is complaining because you tried to
access a database named "dbname=template1".  Better check the syntax
on the connection subroutine you are using --- looks like a confusion
between positional parameters and keyword-style connect strings...

            regards, tom lane

Re: FATAL 1: Database dbname=template1 does not exist in pg_database

From
Carsten Huettl
Date:
Tom Lane schrieb:

> Read it again: the error message is complaining because you tried to
> access a database named "dbname=template1".  Better check the syntax
> on the connection subroutine you are using --- looks like a confusion
> between positional parameters and keyword-style connect strings...

In the meantime I figured out, was was going wrong with my
postgresql installation.
I made a big mistake configuring the config.inc.php3 file
There I had wrong entries for user and stduser. After correcting this
phpPGadmin work quite well.

C.