From rschumeyer@ieee.org Mon Jan 17 20:31:48 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 4C9383A2D76 for ; Mon, 17 Jan 2005 20:31:48 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56928-07 for ; Mon, 17 Jan 2005 20:31:40 +0000 (GMT) Received: from sccrmhc11.comcast.net (sccrmhc11.comcast.net [204.127.202.55]) by svr1.postgresql.org (Postfix) with ESMTP id 63EC33A25A2 for ; Mon, 17 Jan 2005 20:31:40 +0000 (GMT) Received: from dell8200 (pcp05158174pcs.rte20201.de.comcast.net[69.139.132.79]) by comcast.net (sccrmhc11) with SMTP id <20050117203139011000pl5ue>; Mon, 17 Jan 2005 20:31:39 +0000 From: "Rick Schumeyer" To: Subject: "template1 does not exist" while installing 8.0RC5 on RH9 Date: Mon, 17 Jan 2005 15:31:38 -0500 Message-ID: <005a01c4fcd3$8ba79050$0200a8c0@dell8200> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_005B_01C4FCA9.A2D18850" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=AWL, HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200501/178 X-Sequence-Number: 16037 This is a multi-part message in MIME format. ------=_NextPart_000_005B_01C4FCA9.A2D18850 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit 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. ------=_NextPart_000_005B_01C4FCA9.A2D18850 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

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.

 

------=_NextPart_000_005B_01C4FCA9.A2D18850-- From tgl@sss.pgh.pa.us Mon Jan 17 21:12:01 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8709C3A3E7C for ; Mon, 17 Jan 2005 21:12:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63189-05 for ; Mon, 17 Jan 2005 21:11:46 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 85A053A3E8C for ; Mon, 17 Jan 2005 21:11:47 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0HLBik9010577; Mon, 17 Jan 2005 16:11:44 -0500 (EST) To: "Rick Schumeyer" Cc: pgsql-admin@postgresql.org Subject: Re: "template1 does not exist" while installing 8.0RC5 on RH9 In-reply-to: <005a01c4fcd3$8ba79050$0200a8c0@dell8200> References: <005a01c4fcd3$8ba79050$0200a8c0@dell8200> Comments: In-reply-to "Rick Schumeyer" message dated "Mon, 17 Jan 2005 15:31:38 -0500" Date: Mon, 17 Jan 2005 16:11:44 -0500 Message-ID: <10576.1105996304@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/181 X-Sequence-Number: 16040 "Rick Schumeyer" 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 From rschumeyer@ieee.org Mon Jan 17 21:33:41 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 938E83A3B21 for ; Mon, 17 Jan 2005 21:33:41 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66714-01 for ; Mon, 17 Jan 2005 21:33:36 +0000 (GMT) Received: from sccrmhc12.comcast.net (sccrmhc12.comcast.net [204.127.202.56]) by svr1.postgresql.org (Postfix) with ESMTP id EE3E03A2D8C for ; Mon, 17 Jan 2005 21:33:36 +0000 (GMT) Received: from dell8200 (pcp05158174pcs.rte20201.de.comcast.net[69.139.132.79]) by comcast.net (sccrmhc12) with SMTP id <2005011721333601200156c1e>; Mon, 17 Jan 2005 21:33:36 +0000 From: "Rick Schumeyer" To: "'Tom Lane'" Cc: Subject: Re: "template1 does not exist" while installing 8.0RC5 on RH9 Date: Mon, 17 Jan 2005 16:33:34 -0500 Message-ID: <006101c4fcdc$32eaa660$0200a8c0@dell8200> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.6626 In-reply-to: <10576.1105996304@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 Importance: Normal X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/182 X-Sequence-Number: 16041 (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" 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 From tgl@sss.pgh.pa.us Mon Jan 17 22:15:45 2005 X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 186CC3A3DFF for ; Mon, 17 Jan 2005 22:15:45 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 72370-01 for ; Mon, 17 Jan 2005 22:15:38 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 099C63A3EFC for ; Mon, 17 Jan 2005 22:15:39 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j0HMFcJn011105; Mon, 17 Jan 2005 17:15:38 -0500 (EST) To: "Rick Schumeyer" Cc: pgsql-admin@postgresql.org Subject: Re: "template1 does not exist" while installing 8.0RC5 on RH9 In-reply-to: <006101c4fcdc$32eaa660$0200a8c0@dell8200> References: <006101c4fcdc$32eaa660$0200a8c0@dell8200> Comments: In-reply-to "Rick Schumeyer" message dated "Mon, 17 Jan 2005 16:33:34 -0500" Date: Mon, 17 Jan 2005 17:15:38 -0500 Message-ID: <11104.1106000138@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.004 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200501/183 X-Sequence-Number: 16042 "Rick Schumeyer" 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