Thread

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

   Carsten Huettl <chuettl@ahorn-net.de> — 2000-06-23T09:53:09Z

   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.
   
   

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

   Andrew McMillan <andrew@catalyst.net.nz> — 2000-06-26T11:41:50Z

   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
   
   
   
   

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

   Tom Lane <tgl@sss.pgh.pa.us> — 2000-06-26T14:59:51Z

   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
   
   

4. How to install perl module without root access

   Ryan Ho <ryanho@pacific.net.sg> — 2000-06-26T16:46:30Z

   Hi,
   I am using a shared web server with a web hosting company. We have no
   root access. I know it is possible to compile and install postgreSQL
   even without root access but is it possible to install the perl module
   Pg without root access? Is it possible to install and run it off a local
   directory in which I have access rights? I heard about the perl
   -I option but I don't know if it would work in this case.
   
   Thanks in Advance
   
   Ryan
   
   
   

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

   Carsten Huettl <chuettl@ahorn-net.de> — 2000-06-27T11:48:21Z

   Andrew McMillan schrieb:
   > 
   > > 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?
   
   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.
   
   

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

   Carsten Huettl <chuettl@ahorn-net.de> — 2000-06-27T11:50:06Z

   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.