Last Error Unable to use plugins to establish logical replication on source PostgreSQL instance. Follow all prerequisites for 'PostgreSQL as a source in DMS' from https://docs.aws.amazon.com/dms/lates

Question

> Last Error: Unable to use plugins to establish logical replication on the source PostgreSQL instance. Follow all prerequisites for 'PostgreSQL as a source in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html. Stop Reason: FATAL_ERROR. Error Level: FATAL.

i'm attempting to create a task from an RDS PostgreSQL 15.3 source endpoint to an S3 target endpoint using AWS DMS. However, the task is failing with the above error message. I have already made modifications in the RDS parameter group, but the error persists. Is there anyone who knows a solution?

```
logical_replication = 1
max_wal_senders = 10
max_replication_slots = 10
wal_sender_timeout = 0
max_worker_processes = 8
max_logical_replication_workers = 8
max_parallel_workers = 8
max_worker_processes = 8
shared_preload_libraries = pglogical
```

Riku_Kobayashi · Answer

Hello.  
Have you restarted RDS after changing the parameter group?  
Some parameters require a restart to take effect.  
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.PostgreSQL.html#CHAP_Source.PostgreSQL.Prerequisites  
> Some parameters are static, and you can only set them at server start. Any changes to their entries in the configuration file (for a self-managed database) or DB parameter group (for an RDS for PostgreSQL database) are ignored until the server is restarted. For more information, see the PostgreSQL documentation

Last Error Unable to use plugins to establish logical replication on source PostgreSQL instance. Follow all prerequisites for 'PostgreSQL as a source in DMS' from https://docs.aws.amazon.com/dms/lates

Add your answer

Relevant content