PostgreSQL Database Server
PostgreSQL is an open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. PostgreSQL comes with many features aimed to help developers build applications, administrators to protect data integrity and build fault-tolerant environments, and help you manage your data no matter how big or small the dataset. In addition to being free and open source, PostgreSQL is highly extensible. For example, you can define your own data types, build out custom functions, even write code from different programming languages without recompiling your database.
Features
AAMI built with the latest, stable version of PostgreSQL.
AMI compatible for spinning up PostgreSQL database nodes with the service up and running.
AMI is built on a patched operating system and the node created from this is ready to be deployed in production.
How It Works
When an EC2 node spun up from this AMI, the PostgreSQL service is up and running.
SSH into the newly spun up node if you need to perform any additional configuration. The database port 5432 is open and you could connect to the database instance remotely also.
Click on the links below to take you to Amazon Marketplace for spinning up EC2 nodes.
Configuration
When an EC2 node spun up from this AMI, the database service would be available on port 5432.
The database service can be managed using standard steps:
$ sudo systemctl [start|stop|status] POSTGRESQL.service
where the POSTGRESQL name is specific to the operating system as follows:
Ubuntu: postgresql@13-main
Debian: postgresql@13-main
Red Hat Enterprise Linux 7: postgresql-13
Red Hat Enterprise Linux 8: postgresql
CentOS 7: postgresql-13
CentOS 8: postgresql
Amazon Linux: postgresql-13
SUSE Linux: postgresql
Unsupported Configurations
Kurian releases latest, stable versions of open source software on popular Linux distributions. If you need a configuration that is not currently available in marketplace, send us your requirements to contact@kurianinc.us. Please include the following info in the email:
Name of Software with version numbers that need to be released as AMIs.
Linux distribution and the version.
The EC2 instance type that you plan to spin up using the AMI (optional).
Upgrade
Follow official documentation for the directions for any upgrades.
Maintenance and Troubleshooting
The Cassandra service is cassandra, and it can be managed using standard options available for a Linux service. See the last section also.
The application can be maintained following the official documents.
Kurian can help with configuring the application for your specific needs using this AMI. Contact us with details to contact@kurianinc.us
Remote Access to EC2 Node
Following are the standard AWS defined users available for SSH when a node is provisioned:
Amazon Linux: ec2-user
Red Hat Linux: ec2-user
SuSE Linux: ec2-user
Fedora: fedora
CentOS: centos
Debian Linux: admin
Ubuntu: ubuntu
Release history
05/31/2021 – Initial release on Debian 10, Ubuntu 16.04/18.04/20.04, Amazon Linux 2, CentOS 7.9/8.3, RHEL 7 and 8, SUSE Linux platforms. Not supported on Amazon Linux 2018, Fedora 31.
All Products
- Apache Web Server
- CIS Benchmark Hardened Linux AMIs
- DevOps Desk with Ansible
- Apache Cassandra Node
- Jenkins Server
- Jenkins Slave
- Joomla! on LAMP Stack
- Kurian Build Server
- LAMP Stack
- Nagios Server
- Nexus Repository Manager
- OpenJDK Java Machine
- Patched Linux Distributions
- Postfix Mail Server
- Secured MariaDB Server
- WordPress on LAMP Stack