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

[Gerd König]

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..