'How can I setup pglogic between two AWS Aurora clusters?
I am using AWS Aurora postgresql11 and want to use pglogic to setup the replica to another Aurora cluster in the same account/region.
I followed this doc: https://github.com/2ndQuadrant/pglogical to set up the whole flow but stuck on creating subscription.
What I did is to create two nodes in the source and target clusters by using pglogical.create_node.
# in source cluster
select pglogical.create_node(node_name := 'master-replica', dsn := 'host=xxxx.ap-southeast-2.rds.amazonaws.com port=5432 dbname=mydb');
# in target cluster
select pglogical.create_node(node_name := 'slave-replica', dsn := 'host=xxxx.ap-southeast-2.rds.amazonaws.com port=5432 dbname=mydb');
But when I create subscription
select pglogical.create_subscription(subscription_name := 'subscription1', provider_dsn := 'host=xxxxx.cluster-clkciynowztg.ap-southeast-2.rds.amazonaws.com port=5432 dbname=mydb');
ERROR: could not connect to the postgresql server: fe_sendauth: no password supplied
I didn't specify any username/password, why it complains about authentication error?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
