PostgreSQL-12 on CentOS7.9 support by Hanwei
Linux/Unix
Linux/Unix
Product 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-12 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-12
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.
Version
PostgreSQL-12.15 on CentOS7.9_latest
Categories
Operating System
Linux/Unix, CentOS 7.9
Delivery Methods