[pgpool-general: 8246] Re: pcp_recovery_node command fails
Tatsuo Ishii
ishii at sraoss.co.jp
Fri Jun 24 08:46:26 JST 2022
> Many responses recommended installing the pgpool_recovery extension, I had done it as part of the install. My install was done with RPMs.
>
> ERROR: extension "pgpool_recovery" already exists
> 2022-06-23 16:29:25.782 EDT [21981] STATEMENT: CREATE EXTENSION pgpool_recovery;
> The recovery_1st_stage script came from a sample provided with the RPM version. The only thing I should need to do with it is to adjust the path of $PGHOME.
It's apparent that the correct version of pgpool_recovery extension
was not installed or pgpool_recovery extension was not installed at
all. You can check it by following command using psql on the primary
PostgreSQL:
test=# \dx pgpool_recovery
List of installed extensions
Name | Version | Schema | Description
-----------------+---------+--------+-------------------------------------------
pgpool_recovery | 1.4 | public | recovery functions for pgpool-II for V4.3
(1 row)
> Regards,
>
> Todd Stein
>
> -----Original Message-----
> From: Todd Stein
> Sent: Thursday, June 23, 2022 4:08 PM
> To: Jon SCHEWE <jon.schewe at raytheon.com>; pgpool-general at pgpool.net
> Subject: RE: pcp_recovery_node command fails
>
> This is the stdout:
> ERROR: executing recovery, execution of command failed at "1st stage"
> DETAIL: command:"recovery_1st_stage"
>
> The pgpool logs don't have much useful info. Even when I set them to debug, it's not very helpful.
>
> This seems to be a pretty common issue, lots of people post about the issue, but I've not seen a resolution to it yet.
>
> the postgres log is actually more useful:
> ERROR: function pgpool_recovery(unknown, unknown, unknown, unknown, integer, unknown, unknown) does not exist at character 8
> 2022-06-23 16:03:53.740 EDT [25708] HINT: No function matches the given name and argument types. You might need to add explicit type casts.
> 2022-06-23 16:03:53.740 EDT [25708] STATEMENT: SELECT pgpool_recovery('recovery_1st_stage', 'nodea', '/var/lib/pgsql/12/data', '5432', 0, '5432', 'nodeb')
>
>
> Regards,
>
> Todd Stein
>
> -----Original Message-----
> From: pgpool-general <pgpool-general-bounces at pgpool.net> On Behalf Of Jon SCHEWE
> Sent: Thursday, June 23, 2022 3:34 PM
> To: Todd Stein <todd.stein at microfocus.com>; pgpool-general at pgpool.net
> Subject: [pgpool-general: 8242] Re: pcp_recovery_node command fails
>
>> I'm trying to use pcp_recovery_node for online recovery in a pgpool/postgresql-12 cluster.
>>
>> My cluster has PostgreSQL 12.8 and pgpool 4.3.2 running on CentOS 7.9 linux.
>>
>>
>>
>> I've tried so many things, I'll not go into those details just yet.
>>
>>
>>
>> To start with, here is the output of the pcp_recovery_node command:
>>
>>
>>
>> pcp_recovery_node -U postgres -h <VIP> -p 9898 -n 0
>>
>> Password:
>>
>> ERROR: executing recovery, execution of command failed at "1st stage"
>>
>> DETAIL: command:"recovery_1st_stage"
>>
>
> Do you see anything in your logs about the errors? Usually this is either on stdout from the service or in /var/log/pgpool...
> I'm guessing that your recovery_1st_stage script either isn't defined or isn't doing what you expect.
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list