Setup Pgpool2 with Postgresql Streaming Replication

From: alanhi <tnguyen3(at)honolulu(dot)gov>
To: pgsql-general(at)postgresql(dot)org
Subject: Setup Pgpool2 with Postgresql Streaming Replication
Date: 2020-10-22 01:44:59
Message-ID: 1603331099660-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.500000 | primary | 0 |
true | 0 | |
| 2020-10-21 11:56:48
1 | ltpgsql12 | 6432 | down | 0.500000 | 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hou, Zhijie 2020-10-22 02:49:40 How to get debuginfo from building source code
Previous Message Matt DeLuco 2020-10-21 21:28:20 Re: json_to_recordset() and CTE performance