On Fri, 2003-10-10 at 07:13, Laszlo Hornyak wrote: > Hi! > > I believe you don`t need to recompile, just > export PGDATA=/home/me/pgdata > pg_initdb > pg_ctl start > and ready to go.
If you do this, each separate instance needs a different port. That can be set in $PGDATA/postgresql.conf. When you connect to the server (with psql or another frontend) you specify the correct port for the server you want. psql -p 5433 -d mydatabase or export PGPORT=5433 psql -d mydatabase -- Oliver Elphick [EMAIL PROTECTED] Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "He that covereth his sins shall not prosper; but whoso confesseth and forsaketh them shall have mercy." Proverbs 28:13 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster