Overview
This product has charges associated with it for seller support. This is open source software, which is repackaged by Hanwei. The additional cost is applicable to the extended support of 24-hour response time.
This AMI contains PostgreSQL-13 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-13
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.
How To Use
1.Connection Methods
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
2.PostgreSQL Service Management
Local connection postgresql: 1: #sudo su - postgres 2: #psql
To start postgresql: 1: #sudo su - postgres 2: #pg_ctl -D /pgdata -l logfile start
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".
3.Configuration Information
Postgresql database user: postgres Installation mode: source code installation Postgresql Installation directory: /usr/local/postgresql Data file directory: /pgdata Configuration file: /pgdata/postgresql.conf 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.
Highlights
- PostgreSQL-13 on CentOS7.9 includes support
- Professional technical support and fast response
- Optimize the software PostgreSQL-13 on CentOS7.9
Details
Typical total price
$0.132/hour
Pricing
- ...
Instance type | Product cost/hour | EC2 cost/hour | Total/hour |
---|---|---|---|
t1.micro | $0.04 | $0.02 | $0.06 |
t2.nano | $0.04 | $0.006 | $0.046 |
t2.micro AWS Free Tier | $0.04 | $0.012 | $0.052 |
t2.small | $0.04 | $0.023 | $0.063 |
t2.medium | $0.04 | $0.046 | $0.086 |
t2.large | $0.04 | $0.093 | $0.133 |
t2.xlarge | $0.39 | $0.186 | $0.576 |
t2.2xlarge | $0.39 | $0.371 | $0.761 |
t3.nano | $0.04 | $0.005 | $0.045 |
t3.micro AWS Free Tier | $0.04 | $0.01 | $0.05 |
Additional AWS infrastructure costs
Type | Cost |
---|---|
EBS General Purpose SSD (gp2) volumes | $0.10/per GB/month of provisioned storage |
Vendor refund policy
no refunds
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
Updated to the 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-13.10
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
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".
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.
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.