experimenting: 2 questions #985
sandrobordacchini
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
-
Hello everyone.
I just discovered pg_auto_failover and I am experimenting a bit.
I really like the approach and i'll probably give it a try on a few ha dbs in production soon.
My "experimenting" scenario is formed by monitor, pgsql1, pgsql2 and a client machine (all debian 10), with pgsql 12 on board and pg_autoctl is version 2.0, extension version 2.0, compiled with PostgreSQL 15.0
I have a couple questions
First question
I created the ha db ("testhadb") without specifying --username so testhadb was owned by postgres.
To allow proper access from my client vm, i created a testhauser role and i changed the ownership of testhadb with an alter statement.
All the changes have been correctly propagated to the secondary node.
I added (on both pgsql1 and pgsql2):
host "testhadb" "testhauser" client md5
to pg_hba.conf where pg_autoctl created these (this is the pgsql1 node):
Am I jeopardizing anything with this ownership change of db testhadb from postgres to testhauser?
Second question
Starting from a working 3-nodes cluster (like i have now), is there any possibility to add a second database (i.e. testhadb2) for a different application?
Thanks.
Beta Was this translation helpful? Give feedback.
All reactions