Re: Running multiple instances off one set of binaries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>
Cc: Karl Denninger <karl(at)denninger(dot)net>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Running multiple instances off one set of binaries
Date: 2013-02-10 14:57:41
Message-ID: 19564.1360508261@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> writes:
> On Sat, Feb 9, 2013 at 7:39 PM, Karl Denninger <karl(at)denninger(dot)net> wrote:
>> Am I correct in that I can do this by simply initdb-ing the second instance
>> with a different data directory structure, and when starting it do so with a
>> different data directory structure?

> You are correct.

You also need a separate port number for the second instance (obviously,
only one of them can have 5432). Another point is that you may have to
twiddle the kernel's shmem settings to make enough shared memory
available for both installations. But people do this all the time.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2013-02-10 15:12:32 Re: Tcl & PG on Win 7 64 bit - is it working for anyone?
Previous Message Carlo Stonebanks 2013-02-10 05:39:53 Re: Tcl & PG on Win 7 64 bit - is it working for anyone?