Thread: pg_id: command not found

Hello,

still again:

I try to setup postgresql on my system.
SuSE Linux post 6.3.
I installed postgres via the supplied rpm file
 postgres-6.5.3-65.i386.rpm
I create a user postgres, then
su postgres
and
/usr/lib/pgsql/bin init db - u postgres
but all I got is

postgres@thetys:/usr/lib/pgsql > /usr/lib/pgsql/bin/initdb -u postgres

/usr/lib/pgsql/bin/initdb: pg_id: command not found
Unable to determine a valid username.  If you are running
initdb without an explicit username specified, then there
may be a problem with finding the Postgres shared library
and/or the pg_id utility.

I did
export PGLIB=/usr/lib/pgsql/lib/
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/pgsql/lib/

but again the same err msg.
The pg_id file is in the directory bin.
I tried:
chown -R postgres /usr/lib/pgsql
but it did not help

What else can I do?

C.


--
Carsten Huettl - <http://www.ahorn-Net.de>
pgp-key on request

"Carsten Huettl" <CHUETTL@ahorn-Net.de> writes:
> postgres@thetys:/usr/lib/pgsql > /usr/lib/pgsql/bin/initdb -u postgres

> /usr/lib/pgsql/bin/initdb: pg_id: command not found

Is /usr/lib/pgsql/bin in your PATH?

            regards, tom lane

Thank you Tom,

> Is /usr/lib/pgsql/bin in your PATH?

Very easy. I mus have been blind...

Maentime I found SuSE Linux supplies a package called pg_data???.rpm which includes the database
files. Installing this seams to be the same as running initdb.
After I installed the package I found the new database directory in /var/lib/pgsql/
btw. I found somethings seams to be wrong with the and package rpm say nothing needs to be updated
or so but there are some files missing from pg_ifa.
After reinstalling the files I can run postgres now without problems.

C.



--
Carsten Huettl - <http://www.ahorn-Net.de>
pgp-key on request