[pgpool-general: 5802] Re: How do U get my 'Master' out of Stand-by

[Eric Powell]

Ok. Figured out how to get node reattached as Master.

Thanks.

Eric

On Nov 9, 2017 10:08 AM, "Eric Powell" <epowell at 3-gis.com> wrote:

> I am learning to use and deploy PGPOOL-II, and have run into a problem in
> my test environment:
>
> Our test environment (Centos 7 and AWS) spins down every night, and for
> some unknown reason, when it spun up the other morning, the firewall on the
> Master database came up blocking traffic on port 5432. I have resolved that
> issue, have streaming replication back up and running, but this also caused
> PGPOOL to status the node as 'down' and place the the pool into standby:
>
> postgres=# show pool_nodes;
>  node_id |  hostname   | port | status | lb_weight |  role   | select_cnt
> | load_balance_node | replication_delay
> ---------+-------------+------+--------+-----------+--------
> -+------------+-------------------+-------------------
>  0       | 172.17.5.9  | 5432 | down   | 0.500000  | standby | 0
> | false             | 0
>  1       | 172.17.5.10 | 5433 | up     | 0.500000  | standby | 3
> | true              | 0
> (2 rows)
>
> How do I tell PGPOOL to bring Node 0 to status 'up' and pull the it out of
> out of standby mode?
>
> IF it is in the docs, I apologize...lot's to digest....
>
> Configuration:
>
> Postgres 9.5 on Centos 7, PGPool 3.6.x on Centos.
>
> I don't have watchdog and health-check configured, yet.
>
> Any help would be appreciated.
>
> --
>
> *Eric Powell, PG, GISP*
>
> *| **Senior Solutions Engineer* *|* *3-GIS* *|* *Mapping the Future*
>
> *|* *256.560.0744 <(256)%20560-0744> x 294 *office *|* *256.560.0746
> <(256)%20560-0746>* fax *|* *803.640.3491 <(803)%2640-3491>* mobile *|*
> www.3-gis.com
>
>
> "Eschew Obfuscation"
>
>

-- 
CONFIDENTIALITY NOTICE:
The contents of this email message and any attachments are intended solely 
for the addressee(s) and may contain confidential and/or privileged 
information and may be legally protected from disclosure. If you are not 
the intended recipient of this message or their agent, or if this message 
has been addressed to you in error, please immediately alert the sender by 
reply email and then delete this message and any attachments. If you are 
not the intended recipient, you are hereby notified that any use, 
dissemination, copying, or storage of this message or its attachments is 
strictly prohibited. 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20171109/06b748e7/attachment.html>