Setup Pgpool2 with Postgresql Streaming Replication - Mailing list 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