Posts

Showing posts from July, 2020

How to install PostgreSQL on Centos 7

Image
What is PostgreSQL PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks. Install PostgreSQL on Centos 7Initializing Database To install the PostgreSQL server along with the PostgreSQL contrib package which provides several additional features for the PostgreSQL database simply type: [root@PostgreSQL ~]# yum install postgresql-server postgresql-contrib -y Initializing Database Start the postgreSQL by help of below commands: [root@PostgreSQL ~]# postgresql-setup initdb Starting PostgreSQL [root@PostgreSQL ~]# systemctl start postgresql [root@PostgreSQL ~]# systemctl enable postgresql Verifying PostgreSQL Installation [root@PostgreSQL ~]# sudo -u postgres psql -c "SELECT version();" Install PostgreSQL f...