Postgresql which port

Active 9 years, 1 month ago. Viewed 62k times. Configuration: Ubuntu 9. Improve this question. Matthew Rankin Matthew Rankin 1, 3 3 gold badges 14 14 silver badges 32 32 bronze badges. Add a comment. Active Oldest Votes. What you want is netstat 8. Improve this answer. The equivalent modern command is ss -plung grep postgres note, same flags — ptman. There is no g flag anymore for the ss command. Try: ss -pa grep postgresql — GrayedFox.

GrayedFox thanks for the update, but for me that gives the name of the port, not the number, so I think ss -pan grep postgres is more suitable — ptman. Dan Stangel Dan Stangel 1 1 silver badge 3 3 bronze badges. It will work for this case, but is not a general-purpose solution Magnus Hagander Magnus Hagander 2, 12 12 silver badges 7 7 bronze badges. Dominik Dominik 2, 13 13 silver badges 9 9 bronze badges. Try Free Request Support. Sign in to ask the community. Surround SCM. Information Article Text.

Stop the PostgreSQL service if it is running. Open the postgresql configuration file in any text edit. Change the port number in the Connections and Authentication section of the configuration file. Click the Windows Start menu. Choose Run. Launch Windows Control Pane , the full version.

That is easiest to do by entering Windows Control Pane in the Windows taskbar search box for launching commands. Choose Windows Defender Firewall. When the app launches, click on Advanced Settings in the left hand stack of choices. Click on Inbound Rules. The illustration above appears. Click on New Rule. Choose Port and click Next.

Enter and click Next. Choose Allow the connection and click Next.