[Pgpool-general] Dynamically adding a Postgresql node to pgpool

[Gerd König]

Hello,

Harold Lim schrieb:
> Hi Greg,
> 
> Thanks. So, I don't have to shutdown my postgresql nodes?
> 
> In the user manual, it says: If PostgreSQL have already started, you need to shutdown PostgreSQL process. 
> 
> Is that talking about all my postgresql nodes? or just the one that I want to dynamically add?

...just the new one. You have to shutdown postgres there because you have to
rsync/scp/... the cluster directory to the new node. Please check the doc,
section "online recovery", you'll find all the details there...

regards---GERD---


> 
> 
> 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] Dynamically adding a Postgresql node to pgpool
>> To: rold_50 at yahoo.com
>> Cc: pgpool-general at pgfoundry.org
>> Date: Wednesday, April 1, 2009, 1:53 AM
>> Hi Harold,
>>
>> Harold Lim schrieb:
>>> Hi All,
>>>
>>> What is the exact procedure to dynamically add a
>> postgresql to pgpool?
>>> It says on the user manual:
>>> "If you wish to add PostgreSQL server
>> dynamically, add backend_hostname etc. parameters and reload
>> pgpool.conf."
>>> Does "reload pgpool.conf" mean stopping
>> pgpool and then starting it?
>> No, it really means "reload" =>
>> "<path_to_pgpool>/bin/pgpool reload"
>>
>>
>> regards...GERD...
> 
> 
>       
> 

-- 
/===============================\
| Gerd König
| - Infrastruktur -
|
| TRANSPOREON GmbH
| Pfarrer-Weiss-Weg 12
| DE - 89077 Ulm
|
|
| Tel: +49 [0]731 16906 16
| Fax: +49 [0]731 16906 99
| Web: www.transporeon.com
|
\===============================/



Bleiben Sie auf dem Laufenden.
Jetzt den Transporeon Newsletter abonnieren!
http://www.transporeon.com/unternehmen_newsletter.shtml


TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056
Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon