Skip site navigation (1) Skip section navigation (2)

RE: pgsql setup

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 (view raw, whole thread or download thread mbox)
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
> gmake
> gmake install
> LD_LIBRARY_PATH=/usr/local/pgsql/lib
> cd /etc
> pico (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
        /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 install
> /sbin/ldconfig

> 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


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?


Carsten Huettl - <>
pgp-key on request

pgsql-novice by date

Next:From: Andrew McMillanDate: 2000-07-13 19:41:52
Subject: Re: tuple maximum size; plpgsql to sendmail?
Previous:From: ERIC Lawson - x52010Date: 2000-07-13 15:30:15
Subject: tuple maximum size; plpgsql to sendmail?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group