[Pgpool-general] Migrating from single postgresql to pgpool with multiple postgresql nodes

[Harold Lim]

Thanks Gerd.

Another Question. I currently have Java servlets that talks to postgresql using JDBC.

With pgpool, how does it work now? What address should I change the jdbc address to?


Thanks,
Harold


--- On Wed, 4/1/09, Gerd König <koenig at transporeon.com> wrote:

> From: Gerd König <koenig at transporeon.com>
> Subject: Re: [Pgpool-general] Migrating from single postgresql to pgpool with multiple postgresql nodes
> To: rold_50 at yahoo.com
> Cc: pgpool-general at pgfoundry.org
> Date: Wednesday, April 1, 2009, 2:10 AM
> Hello Harold,
> 
> Harold Lim schrieb:
> > Hi All,
> > 
> > For example, I currently have a postgresql node
> already with data/tables in it.
> > 
> > If I want to migrate to pgpool, does pgpool
> automatically populate/replicate the data I have in my
> original postgresql node to my new postgresql nodes?
> > 
> 
> No, not automatically, but if you want to add a new node,
> it's as simple as:
> 1.) install postgres on the new node (obvious ;-) )
> 2.) add the new node to pgpool.conf backend section
> 3.) "activate" this node e.g. via "online
> recovery"
> 
> regards..GERD..