[pgpool-general: 8182] Setting up an streaming replication cluster is giving me trouble

Felix Rubio felix at kngnt.org
Thu May 26 21:18:09 JST 2022


Hi everybody!

I am trying to set up a streaming replication cluster, using docker 
containers based on alpine. Inside the container, this is what I am 
doing right now:

apk add postgresql14
curl -s 
https://raw.githubusercontent.com/pgpool/pgpool2/master/src/sample/pgpool.conf.sample-stream 
 > /etc/pgpool/pgpool.conf.sample
curl -s 
https://raw.githubusercontent.com/pgpool/pgpool2/master/src/sample/pool_hba.conf.sample 
 > /etc/pgpool/pool_hba.conf.sample
cd /scratch
rm -rf * && su-exec postgres pgpool_setup -n 3

This is the output I am getting:
--------------------
/scratch # rm -rf * && su-exec postgres pgpool_setup -n 3
PostgreSQL major version: 140
Starting set up in streaming replication mode
creating startall and shutdownall
creating failover script
creating database cluster /scratch/data0...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /scratch/data1...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
creating database cluster /scratch/data2...done.
update postgresql.conf
creating pgpool_remote_start
creating basebackup.sh
creating recovery.conf
temporarily start data0 cluster to create extensions
temporarily start pgpool-II to create standby nodes
2022-05-26 12:13:04.670: main pid 1861: FATAL:  could not read pid file
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" 
failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" 
failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" 
failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
[..... this message appears a number of times ....]
recovery node 1...ERROR: connection to host "localhost" failed with 
error "Connection refused"
done.
recovery node 2...ERROR: connection to host "localhost" failed with 
error "Connection refused"
done.
creating follow primary script
psql: error: connection to server on socket "/tmp/.s.PGSQL.11000" 
failed: No such file or directory
	Is the server running locally and accepting connections on that socket?
shutdown all

pgpool-II setting for streaming replication mode is done.
To start the whole system, use /scratch/startall.
To shutdown the whole system, use /scratch/shutdownall.
pcp command user name is "postgres", password is "postgres".
Each PostgreSQL, pgpool-II and pcp port is as follows:
#1 port is 11002
#2 port is 11003
#3 port is 11004
pgpool port is 11000
pcp port is 11001
The info above is in README.port.
--------------------

I have checked and, indeed, the socket /tmp/.s.PGSQL.11000 does not 
exist. If I run a ps during the script execution, I can see the postgres 
server running:
--------------------
  2247 postgres  0:00 /usr/libexec/postgresql14/postgres -D data0
  2248 postgres  0:00 postgres: logger
  2250 postgres  0:00 postgres: checkpointer
  2251 postgres  0:00 postgres: background writer
  2252 postgres  0:00 postgres: walwriter
  2253 postgres  0:00 postgres: autovacuum launcher
  2254 postgres  0:00 postgres: archiver
  2255 postgres  0:00 postgres: stats collector
  2256 postgres  0:00 postgres: logical replication launcher
--------------------

So... I am kind of lost here... what can I do? Thank you!
-- 
Felix Rubio
"Don't believe what you're told. Double check."



More information about the pgpool-general mailing list