[Pgpool-general] Starting with detached nodes

[Yoshiyuki Asaba]

Hi,

From: Nico -telmich- Schottelius <nico-pgpool at schottelius.org>
Subject: [Pgpool-general] Starting with detached nodes
Date: Fri, 16 May 2008 14:02:21 +0200

> Hello!
> 
> Currently in our two server setup the second box is out of sync,
> because of the possible bug report in the last mails.
> 
> Now I need to restart pgpool. What I do is
> 
> * ulimit -c unlimited
> * ./pgpool -n -d 2>&1 | tee LOG5
> 
> On another shell:
> * ./pcp_detach_node 10 62.65.1.1 9898 pcp weak-pw 1
> * ./pcp_node_info 10 62.65.1.1 9898 pcp weak-pw 1
> 
> So I make sure the wrong node is detached asap.
> 
> Is it possible to tell pgpool before startup which nodes
> it should not attach?

No it can't. But I think this is a useful. For example, new
backend_statusN parameter is.

backend_status0 = true /* attach */
backend_status1 = false /* detach */

Regards,
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp