Re: [SQL] pg_atoi: error in "template1": can't parse "template1" - Mailing list pgsql-admin

From Tom Lane
Subject Re: [SQL] pg_atoi: error in "template1": can't parse "template1"
Date
Msg-id 5652.972572424@sss.pgh.pa.us
Whole thread Raw
In response to pg_atoi: error in "template1": can't parse "template1"  (Dronamraju Rajesh <drajesh80@yahoo.com>)
List pgsql-admin
Dronamraju Rajesh <drajesh80@yahoo.com> 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

pgsql-admin by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: pg_user, changing priviliges
Next
From: Alfred Perlstein
Date:
Subject: Re: disable auto-commit