How to add read-replicas a database that is already connected on hasura cloud #7664
BenoitRanque
announced in
How To
Replies: 1 comment 2 replies
-
- name: default
kind: postgres
configuration:
connection_info:
database_url:
from_env: PG_DATABASE_URL
isolation_level: read-committed
use_prepared_statements: false
tables: "!include default/tables/tables.yaml"
- name: default
kind: postgres
configuration:
connection_info:
database_url:
from_env: PG_DATABASE_URL
isolation_level: read-committed
use_prepared_statements: false
read_replicas:
- database_url:
from_env: PG_READONLY_DATABASE_URL
isolation_level: read-committed
pool_settings:
connection_lifetime: 600
use_prepared_statements: false
tables: "!include default/tables/tables.yaml"
- name: default
kind: postgres
configuration:
connection_info:
database_url:
from_env: PG_DATABASE_URL
isolation_level: read-committed
use_prepared_statements: false
read_replicas:
- database_url:
from_env: PG_READONLY_DATABASE_URL
isolation_level: read-committed
pool_settings:
connection_lifetime: 600
use_prepared_statements: false
- database_url:
from_env: PG_READONLY_DATABASE2_URL
isolation_level: read-committed
pool_settings:
connection_lifetime: 600
use_prepared_statements: false
tables: "!include default/tables/tables.yaml"
|
Beta Was this translation helpful? Give feedback.
2 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
While it is currently possible when creating the connection,
it is currently not possible to add read replicas to a postgres database that is already connected.
This is a UI issue, and will be fixed soon.
In the meantime, this can be worked around by writing some metadata manually.
Instructions to follow
Beta Was this translation helpful? Give feedback.
All reactions