Обсуждение: running two clusters on one machine
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
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 & 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
----- "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