From: | Jim Mercer <jim(at)reptiles(dot)org> |
---|---|
To: | Benjamin Krajmalnik <kraj(at)servoyant(dot)com> |
Cc: | "Gezeala M(dot) Bacu?o II" <gezeala(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Installing multiple instances of Postgred on one FreeBSD server |
Date: | 2013-05-01 22:02:35 |
Message-ID: | 20130501220235.GA39674@reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, May 01, 2013 at 03:40:31PM -0600, Benjamin Krajmalnik wrote:
> 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.
you can probably set destdir or something in ports to point at /usr/local2 or something, but you will need to be careful that the configs done conflict for listen ip, port and sockets.
the jail solution is quite clean, and allows for a straight up ports install/config.
sorry for the lack of formatting, using tiny keyboard.
--jim
>
>
>
>
>
> From: Gezeala M. Bacu?o II [mailto:gezeala(at)gmail(dot)com]
> Sent: Wednesday, May 01, 2013 3:38 PM
> To: Jim Mercer
> Cc: Benjamin Krajmalnik; pgsql-admin(at)postgresql(dot)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(at)reptiles(dot)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(at)reptiles(dot)org]
> > Sent: Wednesday, May 01, 2013 2:20 PM
> > To: Benjamin Krajmalnik
> > Cc: pgsql-admin(at)postgresql(dot)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(at)reptiles(dot)org +1 416
> > 410-5633
> > "He who dies with the most toys is nonetheless dead"
>
> --
> Jim Mercer Reptilian Research jim(at)reptiles(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>
>
>
--
Jim Mercer Reptilian Research jim(at)reptiles(dot)org +1 416 410-5633
"He who dies with the most toys is nonetheless dead"
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Mercer | 2013-05-02 12:58:49 | Re: Installing multiple instances of Postgred on one FreeBSD server |
Previous Message | Benjamin Krajmalnik | 2013-05-01 21:40:31 | Re: Installing multiple instances of Postgred on one FreeBSD server |