> We are using RDS and would like to have a standard PostgreSQL instead.
Having not used Postgres RDS, what about it makes you want to have a standard Postgres instead?
Having not used Postgres RDS, what about it makes you want to have a standard Postgres instead?
- not so bad pricing
- good defaults
- no need to worry regarding the backups and easy disaster recovery
- some monitoring out of the box
- support TLS with a valid cert out of the box
- easy replication
Here are some pain-points we have, I'm probably forgetting some but those were really painful:
- You don't have a superadmin access, we had several issues where some tables, sequences or objects where associated with a user we wanted to delete and this was really hard, I think we were supposed to change the owner of each objects one by one. [0] shows the issue. In the end, we solved it by dumping the database, deleting the user, recreating the database. Thankfully, this wasn't in prod.
- Many extensions cannot be installed, for example Timescale. It's a bit sad having PostgreSQL and not being able to take full advantage of it.
What I regret about those is that there is nothing you can do, for the first point I looked everywhere and many have this issue but there is nothing you can do to solve it easily, there is posts both on StackOverflow and PostgreSQL mailing list but no easy solution, you have to track one by one the object whose owner you want to delete and reassign them. For the second, it means you can't use many useful extensions like Timescale or anything not yet released.
If there was some AMI with PostgreSQL already installed and correctly configured on which we could just connect an EBS, we could migrate very easily.
[0] https://stackoverflow.com/questions/44718654/cant-delete-pos...