Find host name and port using PSQL commands

Question

I have a PSQL and am trying to get a perl application connecting to a database. Is there a command to find the current port and host on which the database is running?

Answer 1

The default PostgreSQL port is 5432 . The host on which the database is running must be provided by your hosting provider; I assume that it will be the same host as the web server if it is not specified. This will usually be configured as localhost if your web server and database server are on the same host.

Answer 2

 SELECT * FROM pg_settings WHERE name = 'port'; 

Answer 3

This command will give you the postgres port number

  \conninfo 

If postgres runs on a Linux server, you can also use the following command

 sudo netstat -plunt |grep postgres 

OR (if he comes as postmaster)

 sudo netstat -plunt |grep postmaster 

and you will see something like this

 tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 140/postgres tcp6 0 0 ::1:5432 :::* LISTEN 140/postgres 

in this case, the port number is 5432, which is also the default port number

credit reference

Answer 4

select inet_server_addr(); provides the IP address of the server.

Answer 5

select inet_server_port(); provides the server port.

Answer 6

This is a non-sql method. Instructions are given on the image itself. Select the server on which you want to find information, and then follow the steps.

Answer 7

 select inet_server_addr( ), inet_server_port( ); 

Answer 8

The postgresql port is defined in your postgresql.conf file.

For me on Ubuntu 14.04 this is /etc/postgresql/9.3/main/postgresql.conf

Inside there is a line:

 port = 5432 

Changing the number requires restarting postgresql for it to take effect.

Answer 9

You can use the command in psql \conninfo you will get You are connected to database "your_database" as user "user_name" on host "host_name" at port "port_number".

Answer 10

go to "Terminal" and just type

 service postgres status 

In the results you can get the port more

In my case, it works on port "5432" (by default).
I am using CentOS 7.Hope this helps.

Answer 11

 SELECT CURRENT_USER usr, :'HOST' host, inet_server_port() port; 

This uses the psql built-in HOST variable described here

And the Postgres System Information Functions documented here

Answer 12

 service postgresql status 

returns: 10 / main (port 5432): online

I am using Ubuntu 18.04