Pgpool2 Service Won't Start

[alanhi]

Hi,

Hi, my pgpool status indicates that it failed even after trying to restart
the service.  What can I check to see what configurations may be causing
this?  Thanks.

Alan

● pgpool2.service - pgpool-II
   Loaded: loaded (/lib/systemd/system/pgpool2.service; enabled; vendor
preset: enabled)
   Active: failed (Result: exit-code) since Fri 2020-10-16 10:16:21 HST;
10min ago
 Docs: man:pgpool(8)
  Process: 20052 ExecStart=/usr/sbin/pgpool -n (code=exited, status=3)
 Main PID: 20052 (code=exited, status=3)





--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Re: Pgpool2 Service Won't Start

[alanhi]

Hi Bo,

I replaced the pgpool.conf file with the original file, reconfigured and it
works now.  Interesting because it was pretty much the same settings after
reconfiguring again.  Must be a setting that I missed.

Thanks,
Alan


Bo Peng wrote
> Hi,
> 
> On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
> alanhi <

> tnguyen3@

> > wrote:
> 
>> Hi,
>> 
>> Hi, my pgpool status indicates that it failed even after trying to
>> restart
>> the service.  What can I check to see what configurations may be causing
>> this?  Thanks.
>> 
>> Alan
>> 
>> ● pgpool2.service - pgpool-II
>>Loaded: loaded (/lib/systemd/system/pgpool2.service; enabled; vendor
>> preset: enabled)
>>Active: failed (Result: exit-code) since Fri 2020-10-16 10:16:21 HST;
>> 10min ago
>>  Docs: man:pgpool(8)
>>   Process: 20052 ExecStart=/usr/sbin/pgpool -n (code=exited, status=3)
>>  Main PID: 20052 (code=exited, status=3)
> 
> You may go to https://www.pgpool.net/mailman/listinfo/pgpool-general to
> ask questions.
> Could you share the result of "systemctl status pgpool" and pgpool log?
>  
>> --
>> Sent from:
>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>> 
>> 
> 
> 
> -- 
> Bo Peng <

> pengbo@.co

> >
> SRA OSS, Inc. Japan


Bo Peng wrote
> Hi,
> 
> On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
> alanhi <

> tnguyen3@

> > wrote:
> 
>> Hi,
>> 
>> Hi, my pgpool status indicates that it failed even after trying to
>> restart
>> the service.  What can I check to see what configurations may be causing
>> this?  Thanks.
>> 
>> Alan
>> 
>> ● pgpool2.service - pgpool-II
>>Loaded: loaded (/lib/systemd/system/pgpool2.service; enabled; vendor
>> preset: enabled)
>>Active: failed (Result: exit-code) since Fri 2020-10-16 10:16:21 HST;
>> 10min ago
>>  Docs: man:pgpool(8)
>>   Process: 20052 ExecStart=/usr/sbin/pgpool -n (code=exited, status=3)
>>  Main PID: 20052 (code=exited, status=3)
> 
> You may go to https://www.pgpool.net/mailman/listinfo/pgpool-general to
> ask questions.
> Could you share the result of "systemctl status pgpool" and pgpool log?
>  
>> --
>> Sent from:
>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>> 
>> 
> 
> 
> -- 
> Bo Peng <

> pengbo@.co

> >
> SRA OSS, Inc. Japan


Bo Peng wrote
> Hi,
> 
> On Fri, 16 Oct 2020 14:33:33 -0700 (MST)
> alanhi <

> tnguyen3@

> > wrote:
> 
>> Hi,
>> 
>> Hi, my pgpool status indicates that it failed even after trying to
>> restart
>> the service.  What can I check to see what configurations may be causing
>> this?  Thanks.
>> 
>> Alan
>> 
>> ● pgpool2.service - pgpool-II
>>Loaded: loaded (/lib/systemd/system/pgpool2.service; enabled; vendor
>> preset: enabled)
>>Active: failed (Result: exit-code) since Fri 2020-10-16 10:16:21 HST;
>> 10min ago
>>  Docs: man:pgpool(8)
>>   Process: 20052 ExecStart=/usr/sbin/pgpool -n (code=exited, status=3)
>>  Main PID: 20052 (code=exited, status=3)
> 
> You may go to https://www.pgpool.net/mailman/listinfo/pgpool-general to
> ask questions.
> Could you share the result of "systemctl status pgpool" and pgpool log?
>  
>> --
>> Sent from:
>> https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
>> 
>> 
> 
> 
> -- 
> Bo Peng <

> pengbo@.co

> >
> SRA OSS, Inc. Japan





--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Setup Pgpool2 with Postgresql Streaming Replication

[alanhi]

Hi,

I'm following the steps from:

https://access.crunchydata.com/documentation/pgpool/4.0.0/example-cluster.html

I'm at step 7.3.8.1 Set up PostgreSQL standby server:
Ran this command on the primary server: pcp_recovery_node -h 192.168.80.90
-p 9898 -U postgres -n 1
And received this error: 
ERROR:  recovery is checking if postmaster is started
DETAIL:  postmaster on hostname:"ltpgsql12" database:"template1"
user:"postgres" failed to start in 90 second

How can I get this command to run successfully?

Also, when I ran this command: psql -p 5433 -c "show pool_nodes"
It shows the following pgpool2 node status, but when I did a listing of
databases on the primary and standby servers, I don't see the databases on
the primary replicated to the standby.  How can I setup the Postgresql
Streaming Replication and check if it's working?

node_id | hostname  | port | status | lb_weight |  role   | select_cnt |
load_balance_node | replication_delay | replication_state |
replication_sync_state | last_status_change
-+---+--++---+-++---+---+---++-
 0   | ltpgsql11 | 6432 | up | 0.50  | primary | 0  |
true  | 0 |   | 
  
| 2020-10-21 11:56:48
 1   | ltpgsql12 | 6432 | down   | 0.50  | standby | 0  |
false | 0 |   | 
  
| 2020-10-21 11:56:48
(2 rows)


Thanks,
Alan



--
Sent from: https://www.postgresql-archive.org/PostgreSQL-general-f1843780.html