PostgreSQL

Initial set-up

Install (the default is v10.23 as of 2023-10-13)

• Last tested on 2023-10-13 (RHEL 8.8 (Ootpa))

$ sudo yum module list | grep postgresql
$ sudo yum install @postgresql

to install a specific version

$ sudo yum install @postgresql:9.6

for the initial set-up

$ sudo postgresql-setup --initdb
 * Initializing database in '/var/lib/pgsql/data'
 * Initialized, logs are in /var/lib/pgsql/initdb_postgresql.log

for setting up a password for the postgres account

$ sudo passwd postgres
Changing password for user postgres.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.

enable PostgreSQL server at the boot time

$ sudo systemctl enable postgresql

Prerequisite for psql console

change to postgres user account

$ sudo -iu postgres

log into postgres console

$ psql
psql (10.23)
Type "help" for help.

postgres=#

Usage

PostgreSQL

Command	Action	Description or Notes
\q	Quit
Example	Example	Example
Example	Example	Example

\q

Resources

Introduction to PostgreSQL for MySQL Users