From: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
To: Tom Kalafut <tommyk@tridsys.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: multiple postgres instances from RPM install
Date: Wed, 20 Dec 2006 00:19:55 +0530
Message-ID: <a97c77030612191049w5ea7345fs69cb390a01ce6469@mail.gmail.com> (raw)
In-Reply-To: <1C6A5A59B497974EA899736C7A78D8F013F2AA@TSIEXCHANGE.tridsys.com>
References: <1C6A5A59B497974EA899736C7A78D8F013F2AA@TSIEXCHANGE.tridsys.com>
On 12/20/06, Tom Kalafut <tommyk@tridsys.com> wrote:
> After consulting with a teammate, I've found out that they'd have no
> problem simply doing 2 separate makes.
> In fact, I'm glad. It's makes
> much better sense.
i really dont much understand what you have
decided to do. have you considered creating
two separate databases in same postgresql
installation ?
>
> Thanks,
> Tom
>
> Tom Kalafut
> Interchange/CG Crew Member
> Trident Systems Inc.
> tommyk@tridsys.com
> (919)388-1264
>
> -------------------------
> The opinions expressed in this email may not necessarily reflect the
> opinions of Trident Systems Inc.
>
> -----Original Message-----
> From: Rajesh Kumar Mallah [mailto:mallah.rajesh@gmail.com]
> Sent: Tuesday, December 19, 2006 1:26 PM
> To: Tom Kalafut
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] multiple postgres instances from RPM install
>
> On 12/19/06, Tom Kalafut <tommyk@tridsys.com> wrote:
> >
> >
> >
> >
> > I am getting ready to set up 2 postgres instances, but I'm somewhat
> new to
> > postgres. I've used RPM to list out all the files that are installed,
> and I
> > think I've isolated all the executables of which I need to make
> separate
> > copies, but I was hoping for some confirmation.
>
> please read about initdb
>
> you can initdb two different empty directories as two different unix
> users.
> when you initdb a directory you will get a postgresql.conf file in it.
> you can change the port number in that file to run different instances
> separately.
>
> but do you really need two different instances that would possibly
> compete
> each other for resources?
>
> I heard the exact files
> > that need copying are listed in a thread somewhere in the archives,
> but I
> > can't seem to find it. Could someone please point me to it?
> >
> >
> >
> > The motivation behind this is having 2 distinct SELinux policies for 2
> > separate users with their own separate databases.
> >
> >
> >
> > Thanks,
> >
> > Tom
> >
> >
> >
> >
> >
> > Tom Kalafut
> > Interchange/CG Crew Member
> > Trident Systems Inc.
> > tommyk@tridsys.com
> > (919)388-1264
> >
> >
> >
> > -------------------------
> >
> > The opinions expressed in this email may not necessarily reflect the
> > opinions of Trident Systems Inc.
> >
> >
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: mallah.rajesh@gmail.com, tommyk@tridsys.com
Subject: Re: multiple postgres instances from RPM install
In-Reply-To: <a97c77030612191049w5ea7345fs69cb390a01ce6469@mail.gmail.com>
References: <1C6A5A59B497974EA899736C7A78D8F013F2AA@TSIEXCHANGE.tridsys.com> <a97c77030612191049w5ea7345fs69cb390a01ce6469@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox