Find the host name and port using PSQL commands

Question

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

User · Answer

select inet server addr     inet server port

User · Answer

The postgresql port is defined in your postgresql conf file     For me in Ubuntu 14 04 it is   etc postgresql 9 3 main postgresql conf  Inside there is a line    port   5432   Changing the number there requires restart of postgresql for it to take effect

User · Answer

go to the  Terminal  and just type   service postgres status   In the results you can get the port details  In my case it s running on port  5432   default  I m using CentOS 7 Hope this helps

User · Answer

service postgresql status   returns  10 main  port 5432   online  I m running Ubuntu 18 04

User · Answer

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

User · Answer

From the terminal you can simply do a  quot postgres list clusters quot   pg lsclusters  It will return Postgres version number  cluster names  ports  status  owner  and the location of your data directories and log file

User · Answer

SELECT CURRENT USER usr    HOST  host  inet server port   port    This uses psql s built in HOST variable  documented here  And postgres System Information Functions  documented here

User · Answer

SELECT   FROM pg settings WHERE name    port

User · Answer

select inet server addr    gives you the ip address of the server

User · Answer

The default PostgreSQL port is 5432   The host that the database is operating on should have been provided by your hosting provider  I d guess it would be the same host as the web server if one wasn t specified   Typically this would be configured as localhost  assuming your web server and database server are on the same host

User · Answer

From the terminal you can do    conninfo  I would suggest reading a documentation on their exhaustive list of all commands using

User · Answer

This is non-sql method  Instructions are given on the image itself  Select the server that you want to find the info about and then follow the steps

User · Answer

select inet server port    gives you the port of the server

User · Answer

This command will give you postgres port number      conninfo   If postgres is running on Linux server  you can also use the following command  sudo netstat -plunt  grep postgres   OR  if it comes as postmaster   sudo netstat -plunt  grep postmaster   and you will see something similar as 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  port number is 5432 which is also default port number  credits link

[postgresql] Find the host name and port using PSQL commands

Examples related to postgresql

Examples related to psql