Обсуждение: pg_atoi: error in "template1": can't parse "template1"

Поиск
Список
Период
Сортировка

pg_atoi: error in "template1": can't parse "template1"

От
Dronamraju Rajesh
Дата:
Dear all,

   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. I have
seen the Postgres FAQ also and have ensured that all
the directories i,e /usr/local/pgsql, /home/postgres
etc are owned by postgres super user. I also have set
the following environmental variables: -

PATH=/usr/bin:/usr/local/bin:/usr/local/pgsql/bin
HOME=/home/postgres
INPUTRC=/etc/inputrc
LC_COLLATE=C
SHELL=/bin/bash
PGLIB=/usr/local/pgsql/lib
USER=postgres
PGDATA=/usr/local/pgsql/data
MANPATH=:/usr/local/pgsql/man
LC_CTYPE=C
LANG=en_US
OSTYPE=Linux
SHLVL=1
LC_COLLATE=C

But even then I got errors when I run initdb like

Adding template1 database to pg_database...
ERROR:  pg_atoi: error in "template1": can't parse
"template1"
ERROR:  pg_atoi: error in "template1": can't parse
"template1"
        syntax error 1 : parse errorinitdb: could not
log template database
initdb: cleaning up.

PLEASE help me in this regard.

Thanks & Regards
Rajesh.

__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf!  It's FREE.
http://im.yahoo.com/

Re: [SQL] pg_atoi: error in "template1": can't parse "template1"

От
Tom Lane
Дата:
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