RE: pgsql setup

Here's some documentation that I wrote while trying to install the binary
version of postgres. See if it helps.

The > denotes your shell prompt.

--------------Begin Documentation----------------
Installing PGSQL

As root
> useradd postgres
> mkdir /usr/local/pgsql
> chown postgres:postgres /usr/local/pgsql
> tar -xvf postgresxxx.tar
> cd postgres*
> cd /src
>./configure
> gmake
> gmake install
> LD_LIBRARY_PATH=/usr/local/pgsql/lib
> export LD_LIBRARY_PATH
> cd /etc
> pico etc.so.conf (ADD: /usr/local/pgsql/lib)
> /sbin/ldconfig
> mkdir /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su - postgres
> /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
End message:

Success. You can now start the database server using:

/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data start

> nohup /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data \
</dev/null >> server.log 2>>1 &
> su
> password
> cd /etc
> pico profile
ADD: PATH=$PATH:/usr/local/pgsql/bin
ADD: MANPATH=$MANPATH:/usr/local/pgsql/man
> cd /usr/local/pgsql/doc
> gmake install
> cd /usr/local/pgsql/contrib/linux
> sh postgres.init.sh install
> /sbin/ldconfig

REGRESSION:
(http://www.postgresql.org/docs/admin/regress.htm)
> exit (to go back to postgres account)
> cd /usr/local/pgsql/src/test
> gmake clean
> gmake all
> cd regress
> gmake runtest
> gmake runcheck
> make bigcheck
> gmake clean
> dropdb regression
> createdb testdb
> psql testdb
> ps -x to verify postmaster still running.

-----Original Message-----
From: Carsten Huettl [mailto:CHUETTL(at)ahorn-Net(dot)de]
Sent: Wednesday, July 12, 2000 3:45 PM
To: pgsql-novice(at)postgresql(dot)org; pgsql-general(at)postgresql(dot)org
Subject: [NOVICE] pgsql setup

Hello,

I am runing pgsql with suse linux v.6.4

I have installed pgsql with rpm.
When I start initdb as user postgres I get the following error:

/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.

What can I do do fix this?

TIA
C.

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