Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by hub.org (8.10.1/8.11.0) with ESMTP id e9QF0vU82054; Thu, 26 Oct 2000 11:00:57 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id e9QF0O505655; Thu, 26 Oct 2000 11:00:24 -0400 (EDT) To: Dronamraju Rajesh cc: pgsql-admin@postgresql.org, pgsql-sql@postgresql.org Subject: Re: [SQL] pg_atoi: error in "template1": can't parse "template1" In-reply-to: <20001026121747.24312.qmail@web9610.mail.yahoo.com> References: <20001026121747.24312.qmail@web9610.mail.yahoo.com> Comments: In-reply-to Dronamraju Rajesh message dated "Thu, 26 Oct 2000 05:17:47 -0700" Date: Thu, 26 Oct 2000 11:00:24 -0400 Message-ID: <5652.972572424@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200010/121 X-Sequence-Number: 915 Dronamraju Rajesh writes: > I have installed postgres 6.5.1 on my RedHat Linux > box. The installation went smooth without any > problems. Now when i run initdb I got errors. > Adding template1 database to pg_database... > ERROR: pg_atoi: error in "template1": can't parse > "template1" Hm. I think the most likely cause is that you are using library files (global.bki etc) that are not for the same version of Postgres as your executable is. The error message looks like there is some confusion about which column is which in pg_database, which is quite possible if the executable and .bki files don't match. In any case, it's a little bit silly to be installing 6.5.1 today. I'd suggest removing all trace of Postgres from your machine and then making a fresh installation of Postgres 7.0.2 (or wait a couple days for 7.0.3). regards, tom lane