Creating AWS DMS endpoint for PostgreSQL version 14.0 and 14.1?

0

When will AWS enable creating Database Migration Service (DMS) endpoint for PostgreSQL version 14.0 and 14.1?

posta 2 anni fa1122 visualizzazioni
3 Risposte
0

Hello, I don't think you will find a dire answer to this question. AWS announces new technologies when they are ready and tested, but does not provide dates for when this will happen. It probably will soon

Thanks Joel

Joel
con risposta 2 anni fa
0

Postgresql 14.X has some new features related to how changes are being processes and replicated. I do see service team is working towards certifying PG14.x as source/target. Currently PG14.x is not officially supported. But you should be able to use it for full load as source endpoint and as target endpoint (in any config). For cdc if you run into issues do open a support case so that bugs can be timely reported and resolved.

AWS
con risposta 2 anni fa
0

I can't test the endpoint, I get this as a response:

Test Endpoint failed: Application-Status: 1020912, Application-Message: Failure in resolving database version. The database version is not supported., Application-Detailed-Message: Supported major version numbers range is [9..13]. Source database version number is not supported: 140002 PostgreSQL 14.2, compiled by Visual C++ build 1914, 64-bit

This is an issue even for full builds because when you go to run a replication task you get this as an error:

Test connection for replication instance name-of-your-instance and endpoint name-of-your-endpoint should be successful for starting the replication task.

So, because I can't successfully test my connection (in the logs of the pgsql database, you can see it connecting just fine), I can't create a full rebuild replication task.

con risposta 2 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande