Overview
This is an open-source software.This AMI contains PostgreSQL-14 on CentOS7.9 and includes support.
Perform a minimal installation of CentOS 7.9 and update it to the latest version.
OS version: CentOS7.9
PostgreSQL Version: PostgreSQL-14
CentOS 7 is a Linux enterprise-class operating system that is functionally compatible with its upstream source, Red Hat Enterprise Linux (RHEL).
PostgreSQL,also known as Postgres,is a free and open-source relational database management system (RDBMS) that emphasizes extensibility and SQL compliance.It supports transactions with atomicity,consistency,isolation,durability(ACID) properties.
Highlights
- PostgreSQL-14 on CentOS7.9 with support
- Professional technical support and fast respon
- Optimize the software PostgreSQL-14 on CentOS7.9
Details
Typical total price
$0.103/hour
Pricing
- ...
Instance type | Product cost/hour | EC2 cost/hour | Total/hour |
---|---|---|---|
t2.nano | $0.04 | $0.006 | $0.046 |
t2.micro AWS Free Tier | $0.04 | $0.012 | $0.052 |
t2.small Recommended | $0.08 | $0.023 | $0.103 |
t2.medium | $0.08 | $0.046 | $0.126 |
t2.large | $0.18 | $0.093 | $0.273 |
t2.xlarge | $0.18 | $0.186 | $0.366 |
t2.2xlarge | $0.38 | $0.371 | $0.751 |
t3.nano | $0.04 | $0.005 | $0.045 |
t3.micro AWS Free Tier | $0.04 | $0.01 | $0.05 |
t3.small | $0.08 | $0.021 | $0.101 |
Additional AWS infrastructure costs
Type | Cost |
---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
disabled
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Update to latest
Additional details
Usage instructions
SSH as user "centos" to the running instance and use sudo to run commands requiring root access.
Use "sudo su - root" to switch to root.
OS:CentOS7.9
Server version: PostgreSQL-14.5
Postgresql database user: postgres
Installation mode: source code installation
Postgresql Installation directory: /usr/local/postgresql
Data file directory: /pgdata
Configuration file: /pgdata/postgresql.conf
Local connection postgresql: 1: #sudo su - postgres 2: #psql
To start postgresql: 1: #sudo su - postgres 2: #pg_ctl -D /pgdata -l logfile start PS:pg_ctl is pg with underline and ctl. The webpage may not display "underline".
To stop postgresql: 1: #sudo su - postgres 2: #pg_ctl -D /pgdata -l logfile stop PS:pg_ctl is pg with underline and ctl. The webpage may not display "underline".
For security reasons, remote connection to the postgresql service is not configured. You can modify the two configuration files:/pgdata/postgresql.conf,/pgdata/pg_hba.conf,to configure remote connections.
PostgreSQL Default Port:5432 this is by default not allowed on cloud firewall for security. Please allow SSH port 22, PostgreSQl Port 5432 to limited IPs for access.
If you have any configuration problems, please feel free to contact our email:prosupport@hanweie.com .
Resources
Vendor resources
Support
Vendor support
If you encounter problems in the process of using the system, please feel free to contact us by email:prosupport@hanweie.com ,thank you!
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.