Hi again! Got this working well, appreciate all the help in previous posts :) and apologies for continuing the question onslaught!...
Is there a list somewhere of all the config options allowed? Right now my config looks like this:
production:
primary:
adapter: postgresql_proxy
host: *****
password: *****
username: *****
database: *****
port: <%= ENV["STATEMENT_TIMEOUT"] ? 5432 : 6432 %>
pool: 30
prepared_statements: false
connect_timeout: 5
checkout_timeout: 5
variables:
statement_timeout: <%= ENV["STATEMENT_TIMEOUT"] || "60s" %>
primary_replica:
adapter: postgresql
replica: true
host: 127.0.0.1
password: *****
username: *****
database: *****
port: <%= ENV["STATEMENT_TIMEOUT"] ? 5432 : 6432 %>
pool: 30
prepared_statements: false
connect_timeout: 5
checkout_timeout: 5
variables:
statement_timeout: <%= ENV["STATEMENT_TIMEOUT"] || "60s" %>
In the old makara setup we had some of this stuff:
blacklist_duration: 5
master_ttl: 5
master_strategy: round_robin
sticky: true
rescue_connection_failures: false
Just curious if you have any helpful additions, or where I should go to see all the options!
Hi again! Got this working well, appreciate all the help in previous posts :) and apologies for continuing the question onslaught!...
Is there a list somewhere of all the config options allowed? Right now my config looks like this:
production:
primary:
adapter: postgresql_proxy
host: *****
password: *****
username: *****
database: *****
port: <%= ENV["STATEMENT_TIMEOUT"] ? 5432 : 6432 %>
pool: 30
prepared_statements: false
connect_timeout: 5
checkout_timeout: 5
variables:
statement_timeout: <%= ENV["STATEMENT_TIMEOUT"] || "60s" %>
primary_replica:
adapter: postgresql
replica: true
host: 127.0.0.1
password: *****
username: *****
database: *****
port: <%= ENV["STATEMENT_TIMEOUT"] ? 5432 : 6432 %>
pool: 30
prepared_statements: false
connect_timeout: 5
checkout_timeout: 5
variables:
statement_timeout: <%= ENV["STATEMENT_TIMEOUT"] || "60s" %>
In the old makara setup we had some of this stuff:
blacklist_duration: 5
master_ttl: 5
master_strategy: round_robin
sticky: true
rescue_connection_failures: false
Just curious if you have any helpful additions, or where I should go to see all the options!