(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