Обсуждение: 6.4.1 problem

Having a bit of a problem gettin 6.4.1 running on RH 5.1.  Source went
into /usr/src/pgsql and runtime into /var/lib/pgsql [RH default dir
for postgresql].

Everything went without a problem until the initdb process, which
keeps failing with the error messages below....PGLIB & PBDATA paths
correctly functioning, environment seems proper, postgres has correct
permissions, etc, etc.

Any help greatly appreciated...

........Bill Sneed, Prospect, Maine.......initdb: using /var/lib/pgsql/lib/local1_template1.bki.source as input to
createthe template database. 
initdb: using /var/lib/pgsql/lib/global1.bki.source as input to create the global classes.
initdb: using /var/lib/pgsql/lib/pg_hba.conf.sample as the host-based authentication control file.

We are initializing the database system with username postgres (uid=100).
This user will own all the files and must also own the server process.

Creating Postgres database system directory /var/lib/pgsql/data

Creating Postgres database system directory /var/lib/pgsql/data/base

initdb: creating template database in /var/lib/pgsql/data/base/template1
Running: postgres -boot -C -F -D/var/lib/pgsql/data -Q template1
    syntax error 2305 : parse error
Creating global classes in /base
Running: postgres -boot -C -F -D/var/lib/pgsql/data -Q template1

Adding template1 database to pg_database...
Running: postgres -boot -C -F -D/var/lib/pgsql/data -Q template1 < /tmp/create.5700
ERROR:  pg_atoi: error in "template1": can't parse "template1"
ERROR:  pg_atoi: error in "template1": can't parse "template1"
initdb: could not log template database
initdb: cleaning up.

Summary:  If you build Postgresql from the source distribution, ensure
that you remove the RH rpm package(s) first.  This avoids getting the
wrong executables durint initdb and such.

I had this type of problem on one of my RH/Linux installations.  It turned
out that RH has a /usr/bin/initdb.  I should have been running the
/usr/local/pgsql/bin/initdb.

I removed the postgres RPM package(s) and tried again.  All went well.

mike

Dr Michael A. Koerber
MIT/LL
Radar Imaging Techniques

On Sat, 26 Dec 1998, Bill Sneed wrote:

> Having a bit of a problem gettin 6.4.1 running on RH 5.1.  Source went
> into /usr/src/pgsql and runtime into /var/lib/pgsql [RH default dir
> for postgresql].
>
> Everything went without a problem until the initdb process, which
> keeps failing with the error messages below....PGLIB & PBDATA paths
> correctly functioning, environment seems proper, postgres has correct
> permissions, etc, etc.
>
> Any help greatly appreciated...
>
> ........Bill Sneed, Prospect, Maine.......