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

Re: Alternate Database Locations

From: "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Alternate Database Locations
Date: 2000-10-26 10:08:39
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
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/
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(at)mindspring(dot)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

In response to


pgsql-sql by date

Next:From: Dronamraju RajeshDate: 2000-10-26 12:17:47
Subject: pg_atoi: error in "template1": can't parse "template1"
Previous:From: Stephan SzaboDate: 2000-10-26 05:47:43
Subject: Re: Add Constraint

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