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

Andrew McMillan <andrew@catalyst.net.nz>

From: Andrew McMillan <Andrew@catalyst.net.nz>
To: chuettl@ahorn-Net.de
Cc: PostgreSQL Liste Novice <pgsql-novice@postgresql.org>
Date: 2000-06-26T11:41:50Z
Lists: pgsql-general, pgsql-novice
Carsten Huettl wrote:
> 
> 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?

Looks like you're using the wrong syntax for pg_open?

Try:
	$template_db = pg_Connect("dbname=template1");
or:
	$template_db = pg_Connect("", "", "", "", "template1");

Cheers,
					Andrew.

-- 
_____________________________________________________________________
            Andrew McMillan, e-mail: Andrew@cat-it.co.nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267