Database Engines

How to Install PostgreSQL 13 on Linux CentOS 8 / RHEL

With PostgreSQL performance, you will be impressed since it works much faster the MySQL. The reason why it works faster is related to that it puts all information into files that are cached and depending on your server's drive speed the information inserted and shown is really fast. So in this tutorial, we’ll walk you through the installation and initial configuration of PostgreSQL 13 on CentOS 8. Updates for PostgreSQL 13 will be released for five years through November 2025. You must run all commands as root. Installing PostgreSQL 13 packages Add PostgreSQL repository to the system. dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm Turn off the PostgreSQL modules with an older version present in the system. dnf -qy module disable postgresql Let’s install PostgreSQL 13 server. dnf install -y postgresql13-server Initial configuration Initialize the database. /usr/pgsql-13/bin/postgresql-13-setup initdb Initializing database ... OK Start and enable autostart of the PostgreSQL service. systemctl enable --now postgresql-13 Set a password for…

Read time: 2 mins Read more »

How to Install MariaDB 10.1 on Linxu CentOS 7 Server or VPS, VDS

We all know, that MySQL is one of the popular database engines for WordPress, Simple apps and small e-commerce, and other sites. MySQL has many subtypes, for example, you can install clean MySQL on your server, you can install Percona MySQL, MariaDB and also other types. In this how-to, we will show you how you can install MariaDB 10.1 version on your Linux Centos 7 Server also this can be done on our hosted VPS and VDS. 1. We need to add a repository in your Linux Centos 7 cat <<EOF | sudo tee -a /etc/yum.repos.d/MariaDB.repo # MariaDB 10.1 CentOS repository list # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.1/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1 EOF 2. Let's install MariaDB 10.1 using YUM sudo yum -y install MariaDB-server MariaDB-client 3. Let's enable MariaDB to start when our Linux boots sudo systemctl start mariadb.service 4. Let's start the MariaDB server sudo systemctl enable mariadb.service 5. Let's finish the installation…

Read time: 2 mins Read more »

How to enable remote access to PostgreSQL server on VPS, VDS, Linux server

Now that we have installed our PostgreSQL, if you haven't then you can find instructions on How to Install PostgreSQL on Linux CentOS 7 Server, VPS, VDS you can find here on how to change PostgreSQL main root user password you can also find by clicking here but for now, let's talk on How to enable remote access so that you can access your PostgreSQL server using management tools like DataGrip or other tools, that you like. To enable remote access to PostgreSQL server: Connect to the PostgreSQL server via SSH. Get location of postgresql.conf file by executing the command (it should be something like /var/lib/pgsql/data/postgresql.conf): psql -U postgres -c 'SHOW config_file' Open postgresql.conf file nano /var/lib/pgsql/data/postgresql.conf Add the following line to the end: listen_addresses = '*' Get the location of pg_hba.conf file: grep pg_hba.conf /var/lib/pgsql/data/postgresql.conf Edit ph_hba.conf nano /var/lib/pgsql/data/pg_hba.conf Add the following line to the end of /var/lib/pgsql/data/pg_hba.conf file: host samerole all 192.168.0.1/24 md5 * 192.168.0.1/24…

Read time: 1 min Read more »

How to connect to PostgreSQL on Linux, VPS, VDS, Server for first time

If you are using or starting to use PostgreSQL and have installed it or are planning to install it then here is our tutorial on How to Install PostgreSQL on Linux CentOS 7 Server, VPS, VDS But once you have a ready PostgreSQL server you would need to set up a password to project to your main root user and at the same to connect to it using a management tool. A little reminder doesn't use this for your App connection since this is the main root user that has unlimited access and privileges to the PostgreSQL databases including users and data. Setting a password for the postgres user On Linux systems, there is no default password set. To set the default password: Run the psql command from the postgres user account: sudo -u postgres psql postgres Set the password: \password postgres Enter a password. Close psql. \q

Read time: 1 min Read more »

How to Install PostgreSQL on Linux CentOS 7 Server, VPS, VDS

As we know, there are many database engines available to be used for the project. Some of them are Windows-based, some Linux-based, and also some are both platforms based. Recently I got the need to use PostgreSQL and I can say, that the processes that I needed to run using it were much faster than with MySQL but the Database engine you would need to choose what your app requires since not all apps support PostgreSQL, MySQL or MongoDB. PostgreSQL is a powerful open-source relational database platform. It’s scalable across multiple platforms and is a widely used and well-loved tool. In this tutorial, we’ll show you how to install PostgreSQL on CentOS 7! How Does PostgreSQL work? PostgreSQL uses SQL for relational queries and JSON for non-relational queries. One advantage of using PostgreSQL is its immense community support! Its open-source nature means that a lot of developers contribute to this utility’s growth. PostgreSQL is scalable, reliable, and…

Read time: 6 mins Read more »