The psql utility in a command helps to interact with the PostgreSQL database easily.
$ sudo -u postgres psql -c “SELECT version() ” To check the PostgresSQL version and confirm installation, run the following command. Run the following commands to start and enable PostgreSQL service. $ sudo yum install postgresql postgresql-contribĪfter the installation, you need to initialize the PostgreSQL database by running the following command.Īfter initializing the database, you need to start the PostgreSQL service and then enable it to make sure that the service starts up during the system boot-up. The -contrib package adds additional functionality and features to the installed PostgreSQL. You can install PostgreSQL on the CentOS repository by running the following command with -contrib package. Install PostgreSQL on CentOS from CentOS repository You should log in as a non-root user and have sudo privileges as the prerequisites. In this tutorial, you learn how to install PostgreSQL on CentOS from the CentOS repository and PostgreSQL repository. PostgreSQL answers the structured query language similar to MySQL. PostgreSQL provides an implementation of the SQL querying language, and it is designed to handle a range of workloads, from single machines to data warehouses or Web services with many concurrent users. PostgreSQL is also known as Postgres, and it is a free, powerful, and open-source relational database management system. Configure and Install PostgreSQL on CentOS 7 and 8
0 kommentar(er)
