Обсуждение: Question: PostgreSQL on Amazon linux EC2
Hi Postgres team,
I would like to know if PostgreSQL can be installed and used without any issues on Amazon Linux EC2 machines.
I was going through the documentation and couldn't find very specific details related to support.
Any input will be much helpful.
Warm regards,
Ajay
Em seg., 6 de jul. de 2020 às 21:55, Ajay Patel <mailajaypatel@gmail.com> escreveu:
Hi Postgres team,I would like to know if PostgreSQL can be installed and used without any issues on Amazon Linux EC2 machines.
Yes you can, but not with the repositories at yum.postgresql.org. There's a dependency of a package that only exists on RHEL or CentOS and fail.
I was going through the documentation and couldn't find very specific details related to support.Any input will be much helpful.
You'll be able to :
- compile PostgreSQL
- download and install rpm packages by hand
- use a Amazon provided repo that installs more recent Postgres versions - actually not up-to-date.
After struggling with the points above I decided just to use CentOS on EC2. It works perfectly and from CentOS 7 and up it is supported by AWS on all instance types and their exquisite hardware like network interfaces for EBS performance.
Flavio Gurgel
Thank you Flavio, this is helpful.
Have you faced any other challenges or any other problems after installing Postgres?
Warm regards,
Ajay
On Mon, Jul 6, 2020 at 4:45 PM Flavio Henrique Araque Gurgel <fhagur@gmail.com> wrote:
Em seg., 6 de jul. de 2020 às 21:55, Ajay Patel <mailajaypatel@gmail.com> escreveu:Hi Postgres team,I would like to know if PostgreSQL can be installed and used without any issues on Amazon Linux EC2 machines.Yes you can, but not with the repositories at yum.postgresql.org. There's a dependency of a package that only exists on RHEL or CentOS and fail.I was going through the documentation and couldn't find very specific details related to support.Any input will be much helpful.You'll be able to :- compile PostgreSQL- download and install rpm packages by hand- use a Amazon provided repo that installs more recent Postgres versions - actually not up-to-date.After struggling with the points above I decided just to use CentOS on EC2. It works perfectly and from CentOS 7 and up it is supported by AWS on all instance types and their exquisite hardware like network interfaces for EBS performance.Flavio Gurgel
Thank you Flavio, this is helpful.Have you faced any other challenges or any other problems after installing Postgres?
I suggest you to try it and read a bit, you'll find a lot of feedback from people that already did it on the internet and AWS documentation is key when dealing with their hardware specifics. I only learned how to do some stuff their way when I tried, even with AWS premium support at hand. Because every database is different.
Questions on this list are better handled when you have a more specific question with a problem you're experiencing (like your first one) and the hackers list is more aimed at Postgres development, post user questions on pgsql-general.
Flavio Gurgel
Thanks Flavio.
I believe trying is the best way forward. Thank you for the guidance.
Warm regards,
Ajay Patel
On Jul 7, 2020, at 3:20 AM, Flavio Henrique Araque Gurgel <fhagur@gmail.com> wrote:
Thank you Flavio, this is helpful.Have you faced any other challenges or any other problems after installing Postgres?No problem related to software installation whatsoever, you'll need to take care of the same points as any Postgres usage and some cloud specific care like replication between geographically separated instances (what they call availability zones) and disk performance.I suggest you to try it and read a bit, you'll find a lot of feedback from people that already did it on the internet and AWS documentation is key when dealing with their hardware specifics. I only learned how to do some stuff their way when I tried, even with AWS premium support at hand. Because every database is different.Questions on this list are better handled when you have a more specific question with a problem you're experiencing (like your first one) and the hackers list is more aimed at Postgres development, post user questions on pgsql-general.Flavio Gurgel
On Mon, 6 Jul 2020 at 15:55, Ajay Patel <mailajaypatel@gmail.com> wrote:
Hi Postgres team,I would like to know if PostgreSQL can be installed and used without any issues on Amazon Linux EC2 machines.I was going through the documentation and couldn't find very specific details related to support.Any input will be much helpful.
In a way, this is not a whole lot different from asking,
"I would like to know if PostgreSQL can be installed and used without any issues on Dell server machines."
In that case, there could be questions about whether there are good drivers for disk controllers that would vary from model to model, and some things like that. But there are few up-front answers the way there used to be for how to handle (say) different versions of AIX.
Amazon EC2 provides virtualized "gear" that simulates x86-64 hardware reasonably decently; there can certainly be performance issues relating to how fast their simulated disk is, and how fast their simulated network is.
But there are no highly-specific-to-EC2 details related to hardware support, as you noticed on that web page.
If you do not have performance or load requirements that are so high that they point at edge cases where the EC2 virtualized environment starts to break down, then it's probably mostly smooth sailing.
You need to be aware that they do not promise super-high-availability, so you should be sure to keep good backups lest your server gets dropped on the floor and you lose all your data. I'm not sure there's good stats just yet as to how often that happens. But it isn't difficult to provision a pgbackrest server that will capture backups into S3 cloud storage to help protect from that.
When confronted by a difficult problem, solve it by reducing it to the
question, "How would the Lone Ranger handle this?"
question, "How would the Lone Ranger handle this?"