Homogeneous migration of RDS postgres database

Question

I would like to use transportable tables to migrate a database from one postgres rds instance to another. I've followed the instructions found here and here. I have modified the shared_preload_libraries parameter to include only pg_transport an rebooted the instances. However, when I log on to the database with psql and run 'show shared_preload_libraries' I find that rds has added in rdsutils, so now when I run the transport function it of course fails with:

ERROR:  no extensions except for pg_transport can be installed to use pg_transport

I have not been able to find a way to stop rds from adding rdsutils to the shared libraries. How can I stop rds adding in rdsutils?! Without being able to disable it somehow, pg_transport is not usable.

```
ERROR:  no extensions except for pg_transport can be installed to use pg_transport
```

I have not been able to find a way to stop rds from adding rdsutils to the shared libraries. How can I stop rds adding in rdsutils?! Without being able to disable it somehow, pg_transport is not usable.

Answer

Hello, please check the [Limitations for using PostgreSQL transportable databases](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.TransportableDB.html#PostgreSQL.TransportableDB.Limits). Some of the limitations are  Read replicas, Unsupported column types, Tablespaces, Compatibility, Extensions, Roles and ACLs, Concurrent transports, RDS for PostgreSQL DB instances only.  If limitations are not the issue, you can always reach out to AWS support by creating a support case.

Homogeneous migration of RDS postgres database

相關內容