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