From: Benjamin Krajmalnik <kraj@servoyant.com>
To: Gezeala M. Bacuño II <gezeala@gmail.com>
To: Jim Mercer <jim@reptiles.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: Installing multiple instances of Postgred on one FreeBSD server
Date: Wed, 1 May 2013 15:40:31 -0600
Message-ID: <F4E6A2751A2823418A21D4A160B6898892BCE3@fletch.stackdump.local> (raw)
In-Reply-To: <CAJKO3mWgZ0V_08D03z1fV=GZ1_2RwAMZZD5uSnvnSBLQjfmMWQ@mail.gmail.com>
References: <F4E6A2751A2823418A21D4A160B6898892BCE0@fletch.stackdump.local>
<20130501202021.GA36302@reptiles.org>
<F4E6A2751A2823418A21D4A160B6898892BCE2@fletch.stackdump.local>
<20130501202401.GA36654@reptiles.org>
<CAJKO3mWgZ0V_08D03z1fV=GZ1_2RwAMZZD5uSnvnSBLQjfmMWQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
The problem, as I see it without using jails, is that the binaries are going to be installed in the same location as the 9.0 - unless I am not seeing something properly.
From: Gezeala M. Bacuño II [mailto:gezeala@gmail.com]
Sent: Wednesday, May 01, 2013 3:38 PM
To: Jim Mercer
Cc: Benjamin Krajmalnik; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Installing multiple instances of Postgred on one FreeBSD server
I used to do the ezjail route before but for ease, you can modify the setting "unix_socket_directory" on your postgresql.conf and have it point to another folder (default is /tmp) to have more than 1 instance listen on port 5432. Of course you need to add an alias IP for each instance and add that IP on your postgresql.conf "listen_addresses".
--
regards
gezeala bacuño II
On Wed, May 1, 2013 at 1:24 PM, Jim Mercer <jim@reptiles.org> wrote:
On Wed, May 01, 2013 at 02:21:44PM -0600, Benjamin Krajmalnik wrote:
> So essentially we would have to run jails on this - does that affect
> performance?
i would say minimal impact.
>
>
> -----Original Message-----
> From: Jim Mercer [mailto:jim@reptiles.org]
> Sent: Wednesday, May 01, 2013 2:20 PM
> To: Benjamin Krajmalnik
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] Installing multiple instances of Postgred on one
> FreeBSD server
>
> On Wed, May 01, 2013 at 01:58:21PM -0600, Benjamin Krajmalnik wrote:
> > I would like to install PG 9.2 on the same server and use Slony to
> > replicate the databases, and once everything is up take the 9.0
> > cluster down.
>
> allocate a new ip to the server.
> reconfigure/restart 9.0 to listen on the main IP (not "all" as default)
>
> use ezjail to create a freebsd jail on thenew IP
>
> install 9.2 in the jail
>
> treat it them as two servers.
>
> point clients at new ip.
>
> once migrated, delete all 9.0 from the main server.
>
> if you need to upgrade again, add another jail.
>
> stop and delete the old jail whe the next upgrade is complete.
>
> repeat as often as you want to upgrade.
>
> i'm pretty sure this can be adapted to linux, but i forget what their
> jail equivilent is.
>
> the overhead is minimal
>
>
>
> --
> Jim Mercer Reptilian Research jim@reptiles.org +1 416
> 410-5633
> "He who dies with the most toys is nonetheless dead"
--
Jim Mercer Reptilian Research jim@reptiles.org +1 416 410-5633 <tel:%2B1%20416%20410-5633>
"He who dies with the most toys is nonetheless dead"
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: kraj@servoyant.com, gezeala@gmail.com, jim@reptiles.org
Subject: Re: Installing multiple instances of Postgred on one FreeBSD server
In-Reply-To: <F4E6A2751A2823418A21D4A160B6898892BCE3@fletch.stackdump.local>
References: <F4E6A2751A2823418A21D4A160B6898892BCE0@fletch.stackdump.local> <20130501202021.GA36302@reptiles.org> <F4E6A2751A2823418A21D4A160B6898892BCE2@fletch.stackdump.local> <20130501202401.GA36654@reptiles.org> <CAJKO3mWgZ0V_08D03z1fV=GZ1_2RwAMZZD5uSnvnSBLQjfmMWQ@mail.gmail.com> <F4E6A2751A2823418A21D4A160B6898892BCE3@fletch.stackdump.local>
* 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