PROTECTED]>
Cc: "general-help postgresql" <[EMAIL PROTECTED]>
Sent: Thursday, October 26, 2000 10:16 AM
Subject: Re: [GENERAL] Alternate locations of DB's
> You must use initlocation to initialize the location and have the path to
the
> location in an environment variable
623
for <[EMAIL PROTECTED]>; Thu, 26 Oct 2000 15:49:38 -0400
Message-ID: <001901c03f85$79a17ac0$330a0a0a@6014cwpza006>
From: "Adam Lang" <[EMAIL PROTECTED]>
To: "Wade D. Oberpriller" <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Subject:
You must use initlocation to initialize the location and have the path to the
location in an environment variable before postmaster is started.
For example:
> setenv PGDATA2 /home/someuser/data
> initlocation 'PGDATA2'
> pg_ctl -D /home/pgsql/data start
> createdb mydb -D 'PGDATA2'
This will st
The problem is that you can't share the same port for different instance of
postmaster.
Start postmaster with the option -p can help. so,
$ nohup postmaster -i -p 5432 -D /home/user/database &
$ nohup postmaster -i -p 5433 -D /home/user1/database &
$ nohup postmaster -i -p 5434 -D /home/user2/dat
I have attempted to configure PostgreSQL as described on the website
to use a different location to no avail. Any hints, suggestions or
instructions
would be appreciated.
RedHat 6.1 and the version of PostgreSQL that came with it.
Michael Black
