Introduction to PostgreSQL Port
PostgreSQL provides a facility to make connections between client and server using port number, IP address, and the default port number of PostgreSQL is 5432. The Port number, IP address are the database administrative part. It plays an important role in the database management system to establish a connection with remote users, which we called TCP/IP connection; it uses a local socket for configuration. With the help of port number and IP address, we are able to connect multiple connections in the network to remote access server and database. It also includes security for windows operating systems.
Syntax:
Port = Port Number
listen_addresses = ‘ip address’
Explanation:
- In the above syntax, where Port Number is specified Port number that we need to change, and listen_connection is used to IP address.
- With the help of the above syntax, we can change the Port number and IP.
How does Port work in PostgreSQL?
- We must install PostgreSQL in our system.
- We require basic knowledge about PostgreSQL.
- We must require knowledge about configuration files.
- We just need basic knowledge about TCP/IP.
Basic term related to the port number:
1. listen_addresses
listen_address specifies TCP/IP single or multiple address on the server to establish a connection from the client site. If the listen_address value is *, that means it is available for all IP addresses. The IP address 0.0.0.0 allows listing all IPv4 addresses and :: allows all IPv6 addresses. If the above two addresses are empty, then the server is not able to listen to any IP.
2. Port
The default port number is 5432. TCP port uses this port number to listen to all IP addresses on the server.
3. max_connections
It determines the maximum number of connections on the database server. Typically 100 connections may allow, but sometimes it may be less. It depends on your system’s kernel setting. If we increase the size of the number of users, then it is harmful to PostgreSQL.
4. superuser_reserved_connections
It is used to check the number of connection slots available for PostgreSQL superusers. The max size of connection is 3 that means a superuser is allowed.
5. What is a requirement of port number
Suppose we need to access data in the database on client location, which we call remote users on various locations in the network at that time we need Port Number.
6. How to check the port IP address
Suppose we need to check the Port number and IP address; at that time, we use the following command for the Windows operating system as well as Linux.
Code:
grep port number
Explanation:
- In the above command where grep is commanded along with the port number of the current system. It shows the IP address.
- Another way to check Port Number and IP address are we can directly open postgresql.conf file and check Port number and IP.
- Illustrate the end result of the above declaration by using the use of the following snapshot.
7. Edit postgresql.conf
Suppose we need to take the remote access of the database at that time we need to make some changes in the postgresql.conf file. Illustrate the end result of the above declaration by using the use of the following snapshot.
Explanation:
- In the above snapshot, the listen_addresses we mentioned are 1.1.1.1, and the port number is by default 5432. Here we can change the port number and IP address as per requirement.
8. How to restart PostgreSQL
After editing of listen to addresses and IP, we must restart the postgresql service. On the Linux system, we directly start the postgresql service through the terminal. And windows, we need to search services in the search option of the start menu. Illustrate the end result of the above declaration by using the use of the following snapshot.
9. Configuration of pg_hba.conf for authentication
In this file, we allow remote access using IP4 and IP5 IP addresses to access databases and all users with the help of the md5 protocol.
10. Windows firewall port
At this point, we can run the PostgreSQL database on a windows server with a firewall.
In the above scenario, you can just turn off the firewall.
Steps for turn off windows firewall are as follow:
- Open Control Panel.
- Select System and Security.
- Select Windows Firewall.
- Select Turn Windows Firewall on or off option.
- Save setting and exit.
Another option for setup of firewall are as follows:
- Open Control Panel.
- Select System and Security.
- Select Windows Firewall.
- Select Advanced Setting.
- Right-click on Inbound Rule.
- Select a new.
- Select Port in Rule Type.
- Select TCP program and enter port number (here, you can use the default port number of any other user-defined).
- Next, select the Allow the connection.
- Then select when we need to apply the rule (Domain, Private and Public checked all three options).
- Then assign any name that you want.
- Finally, click on finish.
Remotely Access the User and Database
Suppose we need to access databases and users on different systems. If we don’t have another machine, then we can execute on pgAdmin4. When we complete the above setting, then open pgAdmin4 and follow the following steps.
- First, create a new server (right-click on the server and create the server).
- Then give the name to the server.
- Then click on the connection and give the remote machine’s IP address that we also need to give a password and save the setting.
- Then see the new server on the left side of the window.
- Select created server and open with entering a password.
Conclusion
From the above article, we saw basic terms of networking as well as related to port numbers. From this article, we are able to access the remote machine, and we also see how we can do setup or configuration of PostgreSQL Port on windows operating systems. The same thing is applicable for Linux operating systems. Finally, from this article, we are able to do the configuration for the remote machine.
Recommended Articles
This is a guide to PostgreSQL Port. Here we discuss the introduction, how the port works in PostgreSQL, remotely access the user and database. You may also have a look at the following articles to learn more –