PostgreSQL Software Installation on Amazon EC2/Azure VM Linux

On an Amazon EC2 or Azure VM Linux host, the PostgreSQL software is installed by the package manager provided by the Red Hat OS, which is based on the default configuration. For customization, you have to work with the configuration options. You can create multiple PostgreSQL clusters on Linux hosts to segregate business requirements for separate windows of maintenance, with different ports for access. You have to work on several configuration tasks after installing the PostgreSQL cluster software, such as initializing the PostgreSQL cluster database, configuring the database parameters to expand the default memory, installing and configuring extensions, setting up firewall and network rules, and creating user databases. As the default PostgreSQL port 5432 is not secure, you have to create a non-default port for database access to protect the database from internal and external threats and vulnerabilities.