<div dir="ltr"><div>Thanks Bo, you nailed it.</div><div><br></div><div>Now all works as expected and the new features in 4.1.x are great :)<br></div><div><br></div><div>Best regards,</div><div>LA<br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, May 28, 2020 at 3:55 AM <<a href="mailto:pgpool-general-request@pgpool.net">pgpool-general-request@pgpool.net</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Send pgpool-general mailing list submissions to<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<br>
To subscribe or unsubscribe via the World Wide Web, visit<br>
<a href="http://www.sraoss.jp/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.sraoss.jp/mailman/listinfo/pgpool-general</a><br>
or, via email, send a message with subject or body 'help' to<br>
<a href="mailto:pgpool-general-request@pgpool.net" target="_blank">pgpool-general-request@pgpool.net</a><br>
<br>
You can reach the person managing the list at<br>
<a href="mailto:pgpool-general-owner@pgpool.net" target="_blank">pgpool-general-owner@pgpool.net</a><br>
<br>
When replying, please edit your Subject line so it is more specific<br>
than "Re: Contents of pgpool-general digest..."<br>
<br>
<br>
Today's Topics:<br>
<br>
1. [pgpool-general: 7046] Suggestion to GUI kind tool to manage<br>
pgpool (postgann2020 s)<br>
2. [pgpool-general: 7047] Re: Suggestion to GUI kind tool to<br>
manage pgpool (Pierre Timmermans)<br>
3. [pgpool-general: 7048] Upgrade from pgpool 4.0.x to 4.1.x<br>
(Lu?s Alves)<br>
4. [pgpool-general: 7049] Re: Suggestion to GUI kind tool to<br>
manage pgpool (Bo Peng)<br>
5. [pgpool-general: 7050] Re: Suggestion to GUI kind tool to<br>
manage pgpool (Tatsuo Ishii)<br>
6. [pgpool-general: 7051] Re: Upgrade from pgpool 4.0.x to 4.1.x<br>
(Bo Peng)<br>
<br>
<br>
----------------------------------------------------------------------<br>
<br>
Message: 1<br>
Date: Wed, 27 May 2020 21:28:45 +0530<br>
From: postgann2020 s <<a href="mailto:postgann2020@gmail.com" target="_blank">postgann2020@gmail.com</a>><br>
To: <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 7046] Suggestion to GUI kind tool to manage<br>
pgpool<br>
Message-ID:<br>
<<a href="mailto:CANynezN%2BcyHtLf_JXqJSyFTyP9qUYFfGgXcyqb-ZCvu1zw4Ocg@mail.gmail.com" target="_blank">CANynezN+cyHtLf_JXqJSyFTyP9qUYFfGgXcyqb-ZCvu1zw4Ocg@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi Team,<br>
<br>
Thanks for your support.<br>
<br>
Could someone please suggest GUI kind tool to manage pgpool activities.<br>
<br>
Thanks & Regards,<br>
Postgann.<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200527/68febd66/attachment-0001.html" rel="noreferrer" target="_blank">http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200527/68febd66/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 2<br>
Date: Wed, 27 May 2020 16:12:49 +0000 (UTC)<br>
From: Pierre Timmermans <<a href="mailto:ptim007@yahoo.com" target="_blank">ptim007@yahoo.com</a>><br>
To: <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a>, postgann2020 s <<a href="mailto:postgann2020@gmail.com" target="_blank">postgann2020@gmail.com</a>><br>
Subject: [pgpool-general: 7047] Re: Suggestion to GUI kind tool to<br>
manage pgpool<br>
Message-ID: <<a href="mailto:544544190.340381.1590595969261@mail.yahoo.com" target="_blank">544544190.340381.1590595969261@mail.yahoo.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
There is an official pgpool front-end, written in php<br>
I made a GUI tool on top of postgres replication / pgpool, it is a nodejs application (back-end) and react (front-end). It is not maintained but I could if there is a need (I am not using postgres anymore myself, unfortunately my current company is purely oracle)<br>
<a href="https://github.com/saule1508/pgcluster" rel="noreferrer" target="_blank">https://github.com/saule1508/pgcluster</a><br>
<br>
Pierre <br>
<br>
On Wednesday, May 27, 2020, 05:59:38 PM GMT+2, postgann2020 s <<a href="mailto:postgann2020@gmail.com" target="_blank">postgann2020@gmail.com</a>> wrote: <br>
<br>
Hi Team,<br>
<br>
Thanks for your support.<br>
<br>
Could someone please suggest GUI kind tool to manage pgpool activities.<br>
<br>
Thanks & Regards,<br>
Postgann.<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200527/37077a08/attachment-0001.html" rel="noreferrer" target="_blank">http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200527/37077a08/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 3<br>
Date: Wed, 27 May 2020 18:13:37 +0100<br>
From: Lu?s Alves <<a href="mailto:luisalves00@gmail.com" target="_blank">luisalves00@gmail.com</a>><br>
To: <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 7048] Upgrade from pgpool 4.0.x to 4.1.x<br>
Message-ID:<br>
<CADYm=go2DRpAe6Z2Vt86i4BA+_1kqvJ3okfitYBenZJmPn=<a href="mailto:5Gw@mail.gmail.com" target="_blank">5Gw@mail.gmail.com</a>><br>
Content-Type: text/plain; charset="utf-8"<br>
<br>
Hi,<br>
<br>
I had version 4.0.x working fine and tried to upgrade to version 4.1.2<br>
Now I cannot run the online recovery and I cannot figure out why.<br>
Here is my configs:<br>
<br>
pgpool.conf:<br>
<br>
recovery_user = 'postgres'<br>
# Online recovery user<br>
recovery_password = ''<br>
# Online recovery password<br>
<br>
recovery_1st_stage_command = 'recovery_1st_stage'<br>
<br>
(like the documentation example)<br>
[node1]# su - postgres<br>
[node1]$ vi /var/lib/pgsql/data/recovery_1st_stage<br>
[node1]$ vi /var/lib/pgsql/data/pgpool_remote_start<br>
[node1]$ chmod +x<br>
/var/lib/pgsql/data/{recovery_1st_stage,pgpool_remote_start}<br>
<br>
#I'm using custom folder instead of /var/lib/pgsql/data /11/data<br>
-bash-4.2$ echo $PGDATA<br>
/var/lib/pgsql/data<br>
<br>
#file is present and with proper permissions<br>
-bash-4.2$ ll | grep recovery_1st_stage<br>
-rwxr-xr-x 1 postgres postgres 2708 May 26 12:54 recovery_1st_stage<br>
<br>
#extension is also there:<br>
-bash-4.2$ psql template1 -c "CREATE EXTENSION pgpool_recovery"<br>
ERROR: extension "pgpool_recovery" already exists<br>
<br>
# .pgpoolkey is on postgres home folder<br>
-bash-4.2$ pwd<br>
/var/lib/pgsql<br>
-bash-4.2$ ll -a | grep .pgpoolkey<br>
-rw------- 1 postgres postgres 15 May 27 17:13 .pgpoolkey<br>
<br>
# pool_passwd has the correct credentials<br>
[root@node1 pgpool-II]# cat pool_passwd<br>
pgpool:AES8G1vPLHVO8dPOJrWMfl5BQ==<br>
postgres:AES+LJaYEZCYYD3X2eQw8++yQ==<br>
<br>
<br>
then executing:<br>
<br>
pcp_recovery_node -w -h 10.3.84.4 -p 9898 -U pgpool -n 1<br>
<br>
gives this output in the log<br>
<br>
2020-05-27 18:48:12: pid 6478: LOG: starting recovering node 1<br>
2020-05-27 18:48:12: pid 6478: LOG: executing recovery<br>
2020-05-27 18:48:12: pid 6478: DETAIL: starting recovery command: "SELECT<br>
pgpool_recovery('recovery_1st_stage', 'node-02', '/var/lib/pgsql/data',<br>
'5432', 1, '5432')"<br>
2020-05-27 18:48:12: pid 6478: LOG: executing recovery<br>
2020-05-27 18:48:12: pid 6478: DETAIL: disabling statement_timeout<br>
2020-05-27 18:48:12: pid 6478: ERROR: executing recovery, execution of<br>
command failed at "1st stage"<br>
2020-05-27 18:48:12: pid 6478: DETAIL: command:"recovery_1st_stage"<br>
2020-05-27 18:48:12: pid 5980: LOG: PCP process with pid: 6478 exit with<br>
SUCCESS.<br>
2020-05-27 18:48:12: pid 5980: LOG: PCP process with pid: 6478 exits with<br>
status 0<br>
<br>
Look like recovery_1st_stage is not executed as on previous version I could<br>
see content of recovery_1st_stage file in the log.<br>
<br>
What I'm missing here? What else can I check?<br>
<br>
Best regards,<br>
Lu?s Alves<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200527/e9abe46b/attachment-0001.html" rel="noreferrer" target="_blank">http://www.sraoss.jp/pipermail/pgpool-general/attachments/20200527/e9abe46b/attachment-0001.html</a>><br>
<br>
------------------------------<br>
<br>
Message: 4<br>
Date: Thu, 28 May 2020 11:26:03 +0900<br>
From: Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
To: postgann2020 s <<a href="mailto:postgann2020@gmail.com" target="_blank">postgann2020@gmail.com</a>><br>
Cc: <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 7049] Re: Suggestion to GUI kind tool to<br>
manage pgpool<br>
Message-ID: <<a href="mailto:20200528112603.c6e96bfaa5c198a379d18d35@sraoss.co.jp" target="_blank">20200528112603.c6e96bfaa5c198a379d18d35@sraoss.co.jp</a>><br>
Content-Type: text/plain; charset=US-ASCII<br>
<br>
PgpoolAdmin is a GUI management tool for Pgpool-II<br>
<br>
Download:<br>
<a href="https://pgpool.net/mediawiki/index.php/Downloads#pgpoolAdmin" rel="noreferrer" target="_blank">https://pgpool.net/mediawiki/index.php/Downloads#pgpoolAdmin</a><br>
<br>
The next generation GUI management tool is under development.<br>
<br>
On Wed, 27 May 2020 21:28:45 +0530<br>
postgann2020 s <<a href="mailto:postgann2020@gmail.com" target="_blank">postgann2020@gmail.com</a>> wrote:<br>
<br>
> Hi Team,<br>
> <br>
> Thanks for your support.<br>
> <br>
> Could someone please suggest GUI kind tool to manage pgpool activities.<br>
> <br>
> Thanks & Regards,<br>
> Postgann.<br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
<br>
------------------------------<br>
<br>
Message: 5<br>
Date: Thu, 28 May 2020 11:43:37 +0900 (JST)<br>
From: Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>><br>
To: <a href="mailto:postgann2020@gmail.com" target="_blank">postgann2020@gmail.com</a><br>
Cc: <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 7050] Re: Suggestion to GUI kind tool to<br>
manage pgpool<br>
Message-ID: <<a href="mailto:20200528.114337.1661291751118638774.t-ishii@sraoss.co.jp" target="_blank">20200528.114337.1661291751118638774.t-ishii@sraoss.co.jp</a>><br>
Content-Type: Text/Plain; charset=us-ascii<br>
<br>
> Hi Team,<br>
> <br>
> Thanks for your support.<br>
> <br>
> Could someone please suggest GUI kind tool to manage pgpool activities.<br>
<br>
There's an official GUI tool called PgpoolAdmin. It's written in PHP<br>
and available here:<br>
<br>
<a href="https://pgpool.net/mediawiki/index.php/Downloads#pgpoolAdmin" rel="noreferrer" target="_blank">https://pgpool.net/mediawiki/index.php/Downloads#pgpoolAdmin</a><br>
<br>
Note that PgpoolAdmin 4.1 is not only compatible with Pgpool-II 4.1<br>
but older versions of Pgpool-II.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
<br>
<br>
------------------------------<br>
<br>
Message: 6<br>
Date: Thu, 28 May 2020 11:55:49 +0900<br>
From: Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
To: Lu?s Alves <<a href="mailto:luisalves00@gmail.com" target="_blank">luisalves00@gmail.com</a>><br>
Cc: <a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
Subject: [pgpool-general: 7051] Re: Upgrade from pgpool 4.0.x to 4.1.x<br>
Message-ID: <<a href="mailto:20200528115549.f6b07979de33185e2f3dafee@sraoss.co.jp" target="_blank">20200528115549.f6b07979de33185e2f3dafee@sraoss.co.jp</a>><br>
Content-Type: text/plain; charset=UTF-8<br>
<br>
Hello,<br>
<br>
On Wed, 27 May 2020 18:13:37 +0100<br>
Lu?s Alves <<a href="mailto:luisalves00@gmail.com" target="_blank">luisalves00@gmail.com</a>> wrote:<br>
<br>
> Hi,<br>
> <br>
> I had version 4.0.x working fine and tried to upgrade to version 4.1.2<br>
> Now I cannot run the online recovery and I cannot figure out why.<br>
> Here is my configs:<br>
> <br>
> pgpool.conf:<br>
> <br>
> recovery_user = 'postgres'<br>
> # Online recovery user<br>
> recovery_password = ''<br>
> # Online recovery password<br>
> <br>
> recovery_1st_stage_command = 'recovery_1st_stage'<br>
> <br>
> (like the documentation example)<br>
> [node1]# su - postgres<br>
> [node1]$ vi /var/lib/pgsql/data/recovery_1st_stage<br>
> [node1]$ vi /var/lib/pgsql/data/pgpool_remote_start<br>
> [node1]$ chmod +x<br>
> /var/lib/pgsql/data/{recovery_1st_stage,pgpool_remote_start}<br>
> <br>
> #I'm using custom folder instead of /var/lib/pgsql/data /11/data<br>
> -bash-4.2$ echo $PGDATA<br>
> /var/lib/pgsql/data<br>
> <br>
> #file is present and with proper permissions<br>
> -bash-4.2$ ll | grep recovery_1st_stage<br>
> -rwxr-xr-x 1 postgres postgres 2708 May 26 12:54 recovery_1st_stage<br>
> <br>
> #extension is also there:<br>
> -bash-4.2$ psql template1 -c "CREATE EXTENSION pgpool_recovery"<br>
> ERROR: extension "pgpool_recovery" already exists<br>
<br>
You got an error here.<br>
In Pgpool-II 4.1, pgpool_recovery EXTENSION is updated to 1.3.<br>
<br>
If your recovery_1st_stage script uses the latest pgpool_recovery, <br>
you need to update the pgpool_recovery EXTENSION version to 1.3.<br>
<br>
If the result of the command below shows "1.2",<br>
<br>
-bash-4.2$ psql template1 -c "select extversion from pg_extension where extname = 'pgpool_recovery'";<br>
extversion <br>
------------<br>
1.2<br>
<br>
you need to update the pgpool_recovery EXTENSION version to 1.3.<br>
<br>
-bash-4.2$ psql template1 -c "ALTER EXTENSION pgpool_recovery UPDATE TO '1.3'"<br>
<br>
> # .pgpoolkey is on postgres home folder<br>
> -bash-4.2$ pwd<br>
> /var/lib/pgsql<br>
> -bash-4.2$ ll -a | grep .pgpoolkey<br>
> -rw------- 1 postgres postgres 15 May 27 17:13 .pgpoolkey<br>
> <br>
> # pool_passwd has the correct credentials<br>
> [root@node1 pgpool-II]# cat pool_passwd<br>
> pgpool:AES8G1vPLHVO8dPOJrWMfl5BQ==<br>
> postgres:AES+LJaYEZCYYD3X2eQw8++yQ==<br>
> <br>
> <br>
> then executing:<br>
> <br>
> pcp_recovery_node -w -h 10.3.84.4 -p 9898 -U pgpool -n 1<br>
> <br>
> gives this output in the log<br>
> <br>
> 2020-05-27 18:48:12: pid 6478: LOG: starting recovering node 1<br>
> 2020-05-27 18:48:12: pid 6478: LOG: executing recovery<br>
> 2020-05-27 18:48:12: pid 6478: DETAIL: starting recovery command: "SELECT<br>
> pgpool_recovery('recovery_1st_stage', 'node-02', '/var/lib/pgsql/data',<br>
> '5432', 1, '5432')"<br>
> 2020-05-27 18:48:12: pid 6478: LOG: executing recovery<br>
> 2020-05-27 18:48:12: pid 6478: DETAIL: disabling statement_timeout<br>
> 2020-05-27 18:48:12: pid 6478: ERROR: executing recovery, execution of<br>
> command failed at "1st stage"<br>
> 2020-05-27 18:48:12: pid 6478: DETAIL: command:"recovery_1st_stage"<br>
> 2020-05-27 18:48:12: pid 5980: LOG: PCP process with pid: 6478 exit with<br>
> SUCCESS.<br>
> 2020-05-27 18:48:12: pid 5980: LOG: PCP process with pid: 6478 exits with<br>
> status 0<br>
> <br>
> Look like recovery_1st_stage is not executed as on previous version I could<br>
> see content of recovery_1st_stage file in the log.<br>
> <br>
> What I'm missing here? What else can I check?<br>
> <br>
> Best regards,<br>
> Lu?s Alves<br>
<br>
<br>
-- <br>
Bo Peng <<a href="mailto:pengbo@sraoss.co.jp" target="_blank">pengbo@sraoss.co.jp</a>><br>
SRA OSS, Inc. Japan<br>
<br>
<br>
------------------------------<br>
<br>
_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br>
<br>
End of pgpool-general Digest, Vol 103, Issue 16<br>
***********************************************<br>
</blockquote></div>