pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_atoi: error in "template1": can't parse "template1"
2+ messages / 2 participants
[nested] [flat]

* pg_atoi: error in "template1": can't parse "template1"
@ 2000-10-26 12:17 Dronamraju Rajesh <drajesh80@yahoo.com>
  2000-10-26 15:00 ` Re: [SQL] pg_atoi: error in "template1": can't parse "template1" Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 2+ messages in thread

From: Dronamraju Rajesh @ 2000-10-26 12:17 UTC (permalink / raw)
  To: pgsql-admin@postgresql.org; pgsql-sql

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/



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: [SQL] pg_atoi: error in "template1": can't parse "template1"
  2000-10-26 12:17 pg_atoi: error in "template1": can't parse "template1" Dronamraju Rajesh <drajesh80@yahoo.com>
@ 2000-10-26 15:00 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2000-10-26 15:00 UTC (permalink / raw)
  To: Dronamraju Rajesh <drajesh80@yahoo.com>; +Cc: pgsql-admin@postgresql.org; pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2000-10-26 15:00 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-10-26 12:17 pg_atoi: error in "template1": can't parse "template1" Dronamraju Rajesh <drajesh80@yahoo.com>
2000-10-26 15:00 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox