From: | Kashif Zeeshan <kashi(dot)zeeshan(at)gmail(dot)com> |
---|---|
To: | Sbob <sbob(at)quadratum-braccas(dot)com> |
Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
Subject: | Re: PostgreSQL Logical replication FROM RDS TO EC2 |
Date: | 2024-06-09 19:35:17 |
Message-ID: | CAAPsdhfBNqk4xx5wmWMJRU+XdcMrkZTkVTWuZuF3YraKiLc3fA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)quadratum-braccas(dot)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
>
>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Edwin UY | 2024-06-10 00:09:14 | GRANT CONNECT ON DATABASE |
Previous Message | Sbob | 2024-06-09 19:24:58 | PostgreSQL Logical replication FROM RDS TO EC2 |