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
Uh oh!
There was an error while loading. Please reload this page.
-
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