I need to migrate a production database from Postgres 9.0 to Postgres
9.2.
Running FreeBSD 8.1/amd64, and presently running Postgres 9.0.4.
Due to the nature of the application, I cannot have any considerable
downtime, so the pg_dump and install new version route is not an option.
I would like t
On Wed, May 01, 2013 at 01:58:21PM -0600, Benjamin Krajmalnik wrote:
> I need to migrate a production database from Postgres 9.0 to Postgres
> 9.2.
>
> Running FreeBSD 8.1/amd64, and presently running Postgres 9.0.4.
>
> Due to the nature of the application, I cannot have any considerable
> downt
: 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 need to migrate a production database from Postgres 9.0 to Postgres
> 9.2.
>
> Run
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
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 t
dnesday, 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 in
affect
> > performance?
>
> i would say minimal impact.
>
> >
> >
> > -Original Message-
> > From: Jim Mercer [mailto:j...@reptiles.org]
> > Sent: Wednesday, May 01, 2013 2:20 PM
> > To: Benjamin Krajmalnik
> > Cc: pgsql-admin@po
: 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 anoth
d.
--jim
>
>
>
>
>
> From: Gezeala M. Bacu?o II [mailto:geze...@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
>
ginal Message-
> > > From: Jim Mercer [mailto:j...@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
> > > >
> > > >
> > > > -Original Message-
> > > > From: Jim Mercer [mailto:j...@reptiles.org]
> > > > Sent: Wednesday, May 01, 2013 2:20 PM
> > > > To: Benjamin Krajmalnik
> > > > Cc: pgsql-admin@postg
On Wed, May 08, 2013 at 10:03:30AM +0300, Achilleas Mantzios wrote:
> Pretty informative Jim, thanx.
>
> Do you remember which version, when, by who, were these shortcomings
> (different user, different port) resolved?
> At the time it seemed like a very hard thing to implement in the current
> st
On Ôåô 08 ÌáÀ 2013 08:28:31 Jim Mercer wrote:
> On Wed, May 08, 2013 at 10:03:30AM +0300, Achilleas Mantzios wrote:
> > Pretty informative Jim, thanx.
> >
> > Do you remember which version, when, by who, were these shortcomings
> > (different user, different port) resolved?
> > At the time it seem
On Wed, May 08, 2013 at 05:29:53PM +0300, Achilleas Mantzios wrote:
> 1st the above links do not reveal anything new.
> 2nd, judging by the wiki : https://wiki.freebsd.org/Jails ,
> jailified SysV IPC (or SysV IPC-ified jails) (the specific territory where
> pgsql comes in contact with jails)
>
On May 8, 2013, at 11:32 AM, Jim Mercer wrote:
> On Wed, May 08, 2013 at 05:29:53PM +0300, Achilleas Mantzios wrote:
>> 1st the above links do not reveal anything new.
>> 2nd, judging by the wiki : https://wiki.freebsd.org/Jails ,
>> jailified SysV IPC (or SysV IPC-ified jails) (the specific terr
15 matches
Mail list logo