'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