search

pgpool / pgpool2_on_k8s

57 stars 36 forks source link

ERROR: sr_check_user is not set, exiting... #26

Open ricrug opened 1 year ago

ricrug commented 1 year ago

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

are these the correct symbols?

pengbo0328 commented 1 year ago

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 commented 1 year ago

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