Re: Alternate Database Locations

Okay I am still doing something wrong here

I set PGDATA2=/home/user1/database
export PGDATA2

then I start postmaster
postmaster -d PGDATA2 -i -p  5431 &
and i get

Can't create pid file: /usr/local/pgsql/data/postmaster.pid
Is another postmaster (pid: 10686) running?

What am I missing... I know it must be simple!!!

Thanks for all of your help!


At 10:43 PM 10/25/00 -0400, Tom Lane wrote:
>"Brian C. Doyle" <bcdoyle@mindspring.com> writes:
> > I am still trying to find out how to get multiple postmasters running on
> > different ports at the same time.  Does anyone have any clue how to do 
> that?
>
>Uh, you just do it.  Start each postmaster in a different data directory
>and with a different port number (-D and -P switches) and you're set.
>
>Unless you run out of shared memory or some such, in which case some
>tweaking of kernel parameters is called for...
>
>                         regards, tom lane