Re: Question: PostgreSQL on Amazon linux EC2

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Question: PostgreSQL on Amazon linux EC2
Дата
Msg-id CAFNqd5VhC9H5HONWSJV_U7k+jasfT8oe-OWiUZ+n9zsre-fZiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Question: PostgreSQL on Amazon linux EC2  (Ajay Patel <mailajaypatel@gmail.com>)
Список pgsql-hackers
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?"

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: OpenSSL 3.0.0 compatibility
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: Default setting for enable_hashagg_disk (hash_mem)