Did you do an install from source? If so, I had a problem similar to
this when installing on 6.5.3 on RH6.0. The postgres install script
doesn't clean out the old binaries from /usr/bin, and setting your
path as listed in the installation instructions puts the newly created
binaries directory after /usr/bin. The result is confusion and chaos
as the different versions of data and code are unable to understand
each other. My solution was to copy all the new binaries into
/usr/bin and re-run initdb, but setting the path so the new binaries
are located first would also probably work.
My problem was different, so I can't guarantee this is the answer.
initdb worked for me, but pg_dump gave me a "couldn't find any
tables!" error. It sounds to me like these both might be a similar
case of mismatched versions living on the same system though.
Tucker
> Greetings.
>
> I have read many of the questions concerning this issue. I
> too have installed PostgreSQL 6.5.3 faithfully following the
> instructions in the INSTALL file. The initdb crashes with
> the following error:
>
> ERROR: pg_atoi: error in "template1": can't parse
> "template1"
>
> In my reading of the question archive, I see the solution
> seems to be to clean out all the old templates. We did a
> fresh install of Redhat 6.2 in a CS class, and it must
> automatically install postgres because postgres was already
> present on the system.
>
> My question is: How does one find all the old libraries and
> clean them out?
>
> Thanks for your time,
>
> Jim Buckley,
> CS Student,
> Oregon State University.
>
