To open the file you’ve to use the keyword “nano” or you can run the command in the terminal that is provided below: sudo nano /etc/postgresql/13/main/nf Now we need to open the file and make some changes in order to allow a remote connection. In order to allow all the IP addresses to connect to the PostgreSQL server, we need to configure the file and make some changes, for that you have located the configuration file in the previous step. Configure PostgreSQL to Allow Remote Connections Also, you need to edit “pg_hba.conf” in the same directory to allow remote access. You need to change the listening address in the nf configuration file showing in the command output. In order to install PostgreSQL on our system we need to update our repository and for that execute the below command: sudo -u postgres psql -c "SHOW config_file " If not, use one of the below links to install the PostgreSQL database server on your system. This article assumes that you already have running a PostgreSQL server on your system. In this article we’ll first go through the installation of PostgreSQL on ubuntu 20.04 then we’ll configure it to allow remote connection Prerequsities PostgreSQL is used by many large companies to save and store their data for various applications and it supports various programming interfaces as well as videos, texts, and images. With PostgreSQL users can expand the system by defining self-data types, functions, and operators. An open-source, object-based relational database PostgreSQL, provides the user with the implementation of SQL and is commonly hosted on Linux.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |