Re: How to run a second instance on the same server? - Mailing list pgsql-general

From John R Pierce
Subject Re: How to run a second instance on the same server?
Date
Msg-id 541B8426.2060503@hogranch.com
Whole thread Raw
In response to How to run a second instance on the same server?  (Andreas <maps.on@gmx.net>)
List pgsql-general
On 9/18/2014 6:14 PM, Andreas wrote:
>
> I've got 2 hardware servers running PG 9.3.5 from the
> postgres.org-repository. It's a Ubuntu server 12.x.
>
> Box 2 replictes box 1. That works.
>
> I'd like to use Box 2 as a Test- and Training installation as it is
> probaply bored to death just mirroring Box 1.
> AFAIK I can't just create an additional DB on Box 2 that doesn't exist
> on Box 1, too.
>
> How can I start a second PG server say on Port 5430?
>
> It needs to
> have an own data directory and config in /etc
> and it needs to get started automagically at boot time.

in ubuntu, see: man pg_createcluster



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



pgsql-general by date:

Previous
From: Andreas
Date:
Subject: How to run a second instance on the same server?
Next
From: Jov
Date:
Subject: Re: How can i monitor exactly what (partition) tables are accessed by a query?