Then, a good security measure is to specify the hosts that can access it. The client must be installed on each of the systems that will access PostgreSQL. Now, we have to allow access to remote connections.
If both are effective, the final change will be made. There you will have to enter the password twice. To do this, just use the Unix passwd command. To avoid problems, it is convenient to create a password. The problem is that you do not define a password, so it makes you vulnerable. Change the password to the “postgres” user and allow the remote connectionsĭuring the installation of PostgreSQL, a new user called postgres is created. To check that everything is going well, check the status of the service: :~# systemctl status postgresql-13Īs you can see, everything’s fine. Then, if you want PostgreSQL to start along with the system run this command: :~# systemctl start postgresql-13 At this point, the PostgreSQL service is not enable, so you can’t use it yet. With this, we will have already started the initial database. To achieve this, it is necessary to execute the following command: :~# /usr/pgsql-13/bin/postgresql-13-setup initdb Configure PostgreSQL on CentOS / RHEL 8 / Oracle Linux 8 Initialize PostgreSQL database and start the serviceĪfter installing it, the first thing to do is to initialize the database. :~# dnf install postgresql13-server postgresql13Ģ.- Install PostgreSQL 13 8 on AlmaLinux OS 8 / CentOS 8Īfter that, let us configure it. Then, disable the PostgreSQL module on CentOS 8. To do this, run the following command: :~# dnf install Not only is it easy, but also safe and the possibility to be always up to date.
The best way to install PostgreSQL 13 on CentOS 8, RHEL 8 and Oracle Linux 8 is to add the official PostgreSQL refill. Or if you are using a server connect to it using ssh. Important, if we are going to store large quantities of records. And it is recommended to install it because thanks to it, we can enjoy interesting news and improvements in the performance of the application. However, we already have available version 13.
Install PostgreSQL 13 on CentOS 8 / RHEL 8 / Oracle Linux 8īoth RHEL 8 and its derivatives include PostgreSQL 10 in their repositories. At the end of the post, you will have a PostgreSQL installation ready to start working. In addition, we’ll show you the most basic configurations. So, in this post, I will show you how to install PostgreSQL 13 on CentOS 8 / RHEL 8 / Oracle Linux 8. Despite easy installation, not always many users do.
Its robustness, high availability, and ease of installation make it perhaps the most advanced in the world. PostgreSQL is one of the most popular database management systems in the world.
0 kommentar(er)
