Re: running two clusters on one machine

----- "Emanuel Calvo Franco" <postgres(dot)arg(at)gmail(dot)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 the appropriate 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(at)haas-software(dot)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(at)postgresql(dot)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(at)comcast(dot)net