Обсуждение: PostgreSQL Logical replication FROM RDS TO EC2

Поиск
Список
Период
Сортировка

PostgreSQL Logical replication FROM RDS TO EC2

От
Sbob
Дата:
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






Re: PostgreSQL Logical replication FROM RDS TO EC2

От
Kashif Zeeshan
Дата:
Hi Sbob

Please share the error log to pinpoint the exact cause of the error.


On Mon, Jun 10, 2024 at 12:25 AM Sbob <sbob@quadratum-braccas.com> wrote:
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.
!?>


This is a server crash and its a serious problem.
 

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