You can check the version and compilation: And you can even do that on the Free tier. If you create an Amazon RDS PostgreSQL service, you have the “real” PostgreSQL. You cannot mistakenly select Aurora here. There is no ambiguity there: only one service has the PostgreSQL name and logo. Here is how you create a PostgreSQL database in RDS: you select “PostgreSQL” with the PostgreSQL logo and can choose mostly any supported version (at the time of writing this: any minor version between 9.5.2 to 12.4):
RDS is the family name for all managed relational databases and this includes Open Source databases (PostgreSQL, MySQL, MariaDB), some commercial databases (Oracle Database, Microsoft SQL Server), and Amazon Aurora (I will talk about it later). Here is where I’ve heard some wrong messages, so let’s be clear: Amazon RDS for PostgreSQL is running the real PostgreSQL, compiled from the postgres community sources. There are no doubts about this: you run the community postgres. But if you consider cloud as a hosting solution, installing PostgreSQL in EC2 + EBS is a valid solution. There’s a trend to build microservices with the database embedded with the stateless application and people forget that the database is a stateful component (we called that persistent 15 years ago, or durable 30 years ago) that cannot be stopped and started elsewhere. Please take care of your backups if you do that. But you need to do all the “Ops” work (so the TCO may be higher than what you think). This has the lowest cost because PostgreSQL is free of any subscription. You have the full choice of version, you can even compile it from sources, and add whatever extensions you want.
AWS POSTGRESQL RDS FDW INSTALL
Obviously, you can install PostgreSQL on an EC2 instance, as a database running on IaaS (Infrastructure as a Service). This is wrong and I’m writing this post to clarify it. I’ve heard and read people saying that the PostgreSQL managed service is not the true open-source PostgreSQL from the community.
0 kommentar(er)
