pg_auto_failover setup query #1046
krishnakongara123
started this conversation in
General
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I've created my setup using below command
pg_autoctl create postgres --pgdata /apps/t360/pgsql_data/autodb --auth trust --ssl-self-signed --username keycloak_dev --dbname keycloakdb--hostname 11.254.118.24 --pgport 1521 --name node_3 --pgctl /apps/t360/pgsql-16/bin/pg_ctl --monitor 'postgres://autoctl_node@11.254.118.25:1521/pg_auto_failover?sslmode=require'
My monito node is : 11.254.118.25
My Primary is : 11.254.118.24
Standby 1 : 11.254.118.18
Standby 2 : 11.254.118.19
Once my HA setup is up and running,
Do i need to maintain this user forever keycloak_dev ? and keycloakdb?
the reason for asking this question is that, i had this issue... Due to some requirement changes,
i had to re-create the user and database with different name,
but the moment i tried changing the parameter max_connections....
it stopped working, neither it's not coming up nor failover is happening ?
the reason from pg_autoctl status telling that keycloak_dev user is missing... asking me add it back...
in that situation,
i'm unable to add that user back, as my both secondary instances are in read-only state and primary is not coming...
how to handle such situations?
Beta Was this translation helpful? Give feedback.
All reactions