Re: running two clusters on one machine - Mailing list pgsql-general

From Adrian Klaver
Subject Re: running two clusters on one machine
Date
Msg-id 257279674.1345361238438287845.JavaMail.root@sz0030a.emeryville.ca.mail.comcast.net
Whole thread Raw
In response to running two clusters on one machine  (Eric Smith <esmith@haas-software.com>)
List pgsql-general
----- "Emanuel Calvo Franco" <postgres.arg@gmail.com> wrote:

> To run servers at diferent ports you must use postgres binary.
>
> postgres -D data1 -p 5432 -l logfile &
> postgres -D data2 -p 5433 -l logfile &

That is not true. You can set the port in the postgresql.conf for each cluster to be different and use pg_ctl to start
theappropriate cluster. See: 
http://www.postgresql.org/docs/8.3/interactive/runtime-config-connection.html

>
> I never used pg_ctl to run postgres and don't ask me why.
>
>
> 2009/3/28, Eric Smith <esmith@haas-software.com>:
> > All,
> >
> > I'm trying to run two database clusters on a single machine, and am
> > failing.  I use initdb to create the two clusters... each has their
> > own directory structure.  I can start one server or the other with
> > pg_ctl, but once the first starts, the second just hangs on
> "waiting
> > for server to start...".
> >
> > The two servers are using different ports.  I'm running v 8.3 on a
> > Mac  running 10.5.
> >
> > What's the secret step I'm missing here?
> >
> > Thanks,
> > Eric
> >
> >
> > --
> > Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
> >
>
>
> --
>       Emanuel Calvo Franco
>         Sumate al ARPUG !
>       (www.postgres-arg.org -
>          www.arpug.com.ar)
>     ArPUG / AOSUG Member
>    Postgresql Support & Admin
>

Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Michael Black
Date:
Subject: FW: [GENEAL] dynamically changing table
Next
From: Jennifer Trey
Date:
Subject: Re: PostgreSql with or without Plus?