From: | Lilly Sarkis <marianne(dot)sarkis(at)moai(dot)com> |
---|---|
To: | "'Carsten Huettl'" <CHUETTL(at)ahorn-Net(dot)de>, pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | RE: pgsql setup |
Date: | 2000-07-13 16:38:39 |
Message-ID: | C34890BB3CA1D31182DA009027B72660468845@sfomsx03 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew McMillan | 2000-07-13 19:41:52 | Re: tuple maximum size; plpgsql to sendmail? |
Previous Message | ERIC Lawson - x52010 | 2000-07-13 15:30:15 | tuple maximum size; plpgsql to sendmail? |