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

(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(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, January 17, 2005 4:12 PM
To: Rick Schumeyer
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] "template1 does not exist" while installing 8.0RC5 on
RH9

"Rick Schumeyer" <rschumeyer(at)ieee(dot)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