ERROR: sr_check_user is not set, exiting...

[ricrug]

It keeps stopping at this point even if I set the environment variables:

• PGPOOL_PARAMS_SR_CHECK_USER
• PGPOOL_PARAMS_SR_CHECK_PASSWORD

are these the correct symbols?

[pengbo0328]

It keeps stopping at this point even if I set the environment variables:

Pgpool-II doesn't start when the container is starting?
I am not sure if the incorrect sr_check_user and sr_check_password causes this issue.

If you are setting backend_flag0 = 'ALWAYS_PRIMARY|DISALLOW_TO_FAILOVER', pgpool doesn't use PGPOOL_PARAMS_SR_CHECK_USER and PGPOOL_PARAMS_SR_CHECK_PASSWORD to find the primary node at startup.

If you want to use sr check feature to periodically check the replication delay, then you need to set the following environment variables.
For example, if the username is 'testuser' and password is 'testpassword', then you need to set the following environment variables in your configuration.

PGPOOL_PARAMS_SR_CHECK_USER: 'testuser'
TESTUSER_USERNAME: 'testuser'
TESTUSER_PASSWORD: 'testpassword'
PGPOOL_PASSWORD_ENCRYPTION_METHOD: `scram-sha-256` or `md5` (set the encryption method used in PostgreSQL)

[brandizzi]

Just a note for future debuggers: I had more success by setting the SR check user/passwrod in pgpool.conf:

sr_check_user = 'postgres'
sr_check_password = 'md5<here comes the md5 hash of your pw>'