I just installed PostgreSQL 7.0.2 on a RedHat 6.1 machine using rpm.
now I am trying to run initdb:
$ initdb -r /usr/local/pgsql/data
/usr/bin/initdb: [: integer expression expected before -eq
/usr/bin/initdb: [: integer expression expected before -ne
We are initializing the database system with username postgres
(uid=uid=40(postg
res)).
This user will own all the files and must also own the server process.
Creating template database in /usr/local/pgsql/data/base/template1
ERROR: pg_atoi: error in "uid": can't parse "uid"
ERROR: pg_atoi: error in "uid": can't parse "uid"
syntax error 20 : parse errorinitdb: could not create template
database
initdb: cleaning up by wiping out /usr/local/pgsql/data/base/template1
not sure why this is happening, but I can't seem to overcome it. There is
no initdb -D, but initdb -r seems to do accomplish the same thing.
Any help would be greatly appreciated.
Thanks,
Nickou