Question: PostgreSQL on Amazon linux EC2

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.

https://www.postgresql.org/docs/11/supported-platforms.html

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:

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

Thanks Flavio.

I believe trying is the best way forward. Thank you for the guidance.

Warm regards,

Ajay Patel

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.

https://www.postgresql.org/docs/11/supported-platforms.html

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?"