Install PostgreSQL in CentOS

PostgreSQL is an advanced and powerful Object-Relational database management system (DBMS), with a strong reputation on enterprise environment, designed for scalability, performance, high availability, reliability and feature robustness.

Install

# dnf install postgresql postgrepsql-server postgresql-contrib

Please note at this time the PostgreSQL server is not ready to use yet, if you execute:

# psql -U postgres

You get an error like this:

psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

In order to fix it you need to:

Create/initialize the cluster:

# postgresql-setup --initdb --unit postgresql

Manage the Server process

Start the server

# systemctl start postgresql

Check the status

# systemctl status postgresql

Restart the server

# systemctl restart postgresql

Stop the server

# systemctl stop postgresql

Verify that the server starts with the Operating System

# sudo systemctl is-enabled postgresql

Start the service with the Operating System

# systemctl enable postgresql

Connect to the server

# su - postgres -c psql
About the Author

Leave a Reply

%d bloggers like this: