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

I'm trying to install 8.0RC5 from source on a RedHat9 system.

I'm following the directions from the INSTALL file.

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'

I'm not sure where I went wrong.

"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

(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

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