From: | Sbob <sbob(at)quadratum-braccas(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | PostgreSQL Logical replication FROM RDS TO EC2 |
Date: | 2024-06-09 19:24:58 |
Message-ID: | 61f16775-dba4-40e0-be99-7cd82d5dd4a2@quadratum-braccas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi all;
I created a PUBLICATION in RDS and it succeeded
however if I try to create a subscrption on a PostgreSQL db that is on
an EC2 node I get an error:
prod_db=# create subscription alltables_sub connection
'host=prod-aws-endpoint.us-east-1.rds.amazonaws.com port=5432
user=prod_DBuser dbname=prod_db' publication alltables_pub;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?>
Anyone seen this? do I need to specify the rds_admin user in the create
subscription connection line? Does aws block logical replication out of
RDS to another db?
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Kashif Zeeshan | 2024-06-09 19:35:17 | Re: PostgreSQL Logical replication FROM RDS TO EC2 |
Previous Message | M Sarwar | 2024-06-09 17:11:23 | Re: How to find the view modified date and time and user name |