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

PICCORO McKAY Lenz mckaygerhard at gmail.com
Mon Sep 10 13:42:58 UTC 2012


root at sysdevel:~# netstat -tlpn | grep 5432
tcp        0      0 0.0.0.0:5432            0.0.0.0:*
LISTEN      6408/postgres
tcp6       0      0 :::5432                 :::*
LISTEN      6408/postgres
root at sysdevel:~#

config as same as previus i said, listen on all ports (*) and no firewall,
also u may notice that many users will see the connection problem as
debian issue..

installation proces, easy (i also test with wheeze):

1) take debian oficial netinstall/cdinstall-lxde (i test with both)
2) install everithing basic, but not any database
3) finish install and them open console root
4) added backports options repository (if prefer pinnig)
5) open aptitude and carefully select lasted release of posgres 9.1
and none of 8.X series
6.1 ) no tune config: local connectios are open.. remote conection are
closed/blinds
6.2 tuning configs: set true in pg_hba.conf for all users, listen to
any connectins in postgres.conf, set port manualy, and remenber
there's no firewall (all tables are flushing) same as previous, cant
connect from remote host, canot see the port.

7) were i solved: purge or remove the backport/9.1/9.0 installed
8) install all 8.X series..
9.1) i can now connect susessfully from any host
9.2) remove and force purge postgres 8.X unninstall
9.3) again install backpor/9.1 postgres
9.4) eureka! i see the port open, and work prefectly


please solve it due in squeeze are easy to solve, but wheeze not have
a 8.X packages available..

also u may notice that many users will see the connection problem as
debian issue..

On Fri, Sep 7, 2012 at 4:10 PM, Christoph Berg <myon at debian.org> wrote:
>
> 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/




--
Lenz McKAY Gerardo (PICCORO)
http://qglochekone.blogspot.com



More information about the Pkg-postgresql-public mailing list