RDS Postgresql Subscription Error

Question

Hi! 
We've been trying to set up a pub/sub on RDS postgresql and it is failing with an error we were not able to understand.

Publisher is a Aurora postgresql 16.1 database, subscriber is also a aurora 16.1 database.

Networking between them is set up correctly. rds.logical_replication set to 1 and both databases rebooted.

I already tried every sslmode parameter value possible in the connection string, tried flipping force_ssl db parameter to 1 but no luck.

command:
CREATE SUBSCRIPTION subscription_customer_sandbox
CONNECTION 'customer_host port=5432 dbname=customer_sandbox user=postgres password=customer_password'
PUBLICATION provider_customer_sandbox
WITH (copy_data = true, create_slot = true);

error:
Query 1 ERROR: ERROR:  could not connect to the publisher: connection to server at "customer_host" (10.0.0.0), port 5432 failed: FATAL:  no pg_hba.conf entry for host "10.0.0.1", user "postgres", database "customer_sandbox", SSL encryption
connection to server at "customer_host" (10.0.0.0), port 5432 failed: FATAL:  no pg_hba.conf entry for host "10.0.0.1", user "postgres", database "customer_sandbox", no encryption

Answer

Hi there,

It looks like you you need to specify the host in the connection query, try something like:

`CREATE SUBSCRIPTION subscription_customer_sandbox CONNECTION 'host=pg-10-ident.cxxxxxbz.us-east-1.rds.amazonaws.com customer_host port=5432 dbname=customer_sandbox user=postgres password=customer_password' PUBLICATION provider_customer_sandbox WITH (copy_data = true, create_slot = true);`

And replace your host= with the endpoint of the Publisher.

RDS Postgresql Subscription Error

Relevant content