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
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 |