[Pkg-postgresql-public] Bug#684429: postgresql 9.1 cant allow conection: port 5432 are not visible in any case

[Christoph Berg]

Control: tag -1 unreproducible
Control: severity -1 normal

Re: PICCORO McKAY Lenz 2012-08-09 <CALci+FSPTEkxoLPeG3CLGacHqXQ+gb_oz3n-cw=KDBApEFTNVQ at mail.gmail.com>
> ------- line to listen are here:
> listen_addresses = '*'		# what IP address(es) to listen on;
> 					# comma-separated list of addresses;
> 					# defaults to 'localhost', '*' = all
> 					# (change requires restart)
> port = 5432				# (change requires restart)
> 
> 
> ------- commands showing no ports available if host are used:
> 
> root at sysdevel:/var/log# /etc/init.d/postgresql restart
> Restarting PostgreSQL 9.1 database server: main.
> root at sysdevel:/var/log# netstat -nxl | grep PGSQL
> unix  2      [ ACC ]     STREAM     LISTENING     940787
> /var/run/postgresql/.s.PGSQL.5433

Hi, a late followup here:

That command actually excludes the TCP ports, the correct command to
use here would be netstat -tlpn | grep 543.

Also, you have port 5433 listed here - please make sure the system is
really using the config file you think it is using. If things still
don't work, please provide logfiles so we can have a closer look.

Christoph
-- 
cb at df7cb.de | http://www.df7cb.de/