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