Thread: "template1 does not exist" while installing 8.0RC5 on RH9

"Rick Schumeyer" <rschumeyer@ieee.org> writes:
> Everything looks good, even the "initdb" command, which reports
> everything as ok.

> But the "createdb test" command fails, with error
> 'database "template1" does not exist'

initdb executes half a dozen reconnections to template1 after the
initial bootstrap, so it's real hard to see how a broken pg_database
entry wouldn't have caused a failure during initdb.  I'm wondering
if maybe your createdb command is connecting to a different postmaster
than you think it is.  Check environment variables, path, etc.

            regards, tom lane

(red face) It seems I might possibly have neglected to kill the
postmaster from 7.4 before installing 8.0.

It is amazing how much better things work with the 8.0 postmaster.

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Monday, January 17, 2005 4:12 PM
To: Rick Schumeyer
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] "template1 does not exist" while installing 8.0RC5 on
RH9

"Rick Schumeyer" <rschumeyer@ieee.org> writes:
> Everything looks good, even the "initdb" command, which reports
> everything as ok.

> But the "createdb test" command fails, with error
> 'database "template1" does not exist'

initdb executes half a dozen reconnections to template1 after the
initial bootstrap, so it's real hard to see how a broken pg_database
entry wouldn't have caused a failure during initdb.  I'm wondering
if maybe your createdb command is connecting to a different postmaster
than you think it is.  Check environment variables, path, etc.

            regards, tom lane

"Rick Schumeyer" <rschumeyer@ieee.org> writes:
> (red face) It seems I might possibly have neglected to kill the
> postmaster from 7.4 before installing 8.0.

Ooops ;-).  If you didn't already, I'd suggest wiping and re-initdb'ing
the PGDATA area.  It's possible that the 7.4 postmaster corrupted things
before you killed it.

            regards, tom lane