pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed"template1 does not exist" while installing 8.0RC5 on RH9
4+ messages / 2 participants
[nested] [flat]
* "template1 does not exist" while installing 8.0RC5 on RH9
@ 2005-01-17 20:31 Rick Schumeyer <rschumeyer@ieee.org>
0 siblings, 1 reply; 4+ messages in thread
From: Rick Schumeyer @ 2005-01-17 20:31 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: "template1 does not exist" while installing 8.0RC5 on RH9
@ 2005-01-17 21:11 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rick Schumeyer <rschumeyer@ieee.org>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2005-01-17 21:11 UTC (permalink / raw)
To: Rick Schumeyer <rschumeyer@ieee.org>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: "template1 does not exist" while installing 8.0RC5 on RH9
@ 2005-01-17 21:33 Rick Schumeyer <rschumeyer@ieee.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Rick Schumeyer @ 2005-01-17 21:33 UTC (permalink / raw)
To: 'Tom Lane' <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
(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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: "template1 does not exist" while installing 8.0RC5 on RH9
@ 2005-01-17 22:15 Tom Lane <tgl@sss.pgh.pa.us>
parent: Rick Schumeyer <rschumeyer@ieee.org>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2005-01-17 22:15 UTC (permalink / raw)
To: Rick Schumeyer <rschumeyer@ieee.org>; +Cc: pgsql-admin
"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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2005-01-17 22:15 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-01-17 20:31 "template1 does not exist" while installing 8.0RC5 on RH9 Rick Schumeyer <rschumeyer@ieee.org>
2005-01-17 21:11 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-01-17 21:33 ` Rick Schumeyer <rschumeyer@ieee.org>
2005-01-17 22:15 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox