Ubuntu
postgresql package

Opening port for listening default postgresql 5432 port

Asked by Mikey

I installed server 12.10 with the "--without-recommends ubuntu-desktop" option - this gives a minimal Unity GUI, without most of the addons for a desktop user.

Now I installed postgreSQL - service is running but I cannot connect using PGAdmin because the server is not listeing on port 5432,the default port for postgreSQL.

What is the command I should use to open port 5432 (or any port) for listening?

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu postgresql Edit question
Assignee:
No assignee Edit question
Solved by:
marcobra (Marco Braida)
Solved:
Last query:
Last reply:
Revision history for this message
actionparsnip (andrew-woodhead666) said : 		#1

The default OS has all ports open and available by default.

Revision history for this message
Best marcobra (Marco Braida) (marcobra) said : 		#2

Please edit the postgresql configuration to enable

http://linuxpoison.blogspot.it/2012/01/how-to-install-configure-postgresql.html

http://www.postgresql.org/docs/current/static/runtime-config-connection.html#GUC-LISTEN-ADDRESSES

http://dba.stackexchange.com/questions/18717/how-to-connect-to-an-remote-postgresql-database-on-ubuntu-using-pgadmin3

Revision history for this message
Mikey (9-mikey) said : 		#3

Thanks marcobra (Marco Braida), that solved my question.

Revision history for this message
Mikey (9-mikey) said : 		#4

Thanks to both of you. I had to use root credentials to edit the file but that did it.