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@xxxxxxxxx] > Sent: Wednesday, May 01, 2013 3:38 PM > To: Jim Mercer > Cc: Benjamin Krajmalnik; pgsql-admin@xxxxxxxxxxxxxx > Subject: Re: 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@xxxxxxxxxxxx> 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@xxxxxxxxxxxx] > > Sent: Wednesday, May 01, 2013 2:20 PM > > To: Benjamin Krajmalnik > > Cc: pgsql-admin@xxxxxxxxxxxxxx > > Subject: Re: 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@xxxxxxxxxxxx +1 416 > > 410-5633 > > "He who dies with the most toys is nonetheless dead" > > -- > Jim Mercer Reptilian Research jim@xxxxxxxxxxxx +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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > > > -- Jim Mercer Reptilian Research jim@xxxxxxxxxxxx +1 416 410-5633 "He who dies with the most toys is nonetheless dead" -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin