On Thu, Apr 9, 2015 at 5:00 AM, dlefebvre <dlefeb...@synotis.com> wrote:
> Hi, > > I use ubuntu 14.01 and i install a postgresql 9.3 server. I want to connect > an other pc from local network to this server. But the server seems to only > listen on localhost. > I'm running 9.3.6 on Fedora 21 x86_64. > > There is the conf files : > > pg_hba.conf : > <snip> Mine looks about the same. > > postgresql.conf (with the only lines i changed) : > > # - Connection Settings - > > tcpip_socket = true > > listen_addresses = '*' # what IP address(es) to listen on; > # comma-separated list of > addresses; > # defaults to 'localhost'; use '*' > for all > # (change requires restart) > I have this commented out entirely in my configuration. I.e> #listen_address = 'localhost" > port = 5432 # (change requires restart) > > my iptables are setup : > > > As best as I can tell, this looks OK. > and so, using netstat it seems like the server only listen on localhost : > > :~$ netstat -lt > Active Internet connections (only servers) > Proto Recv-Q Send-Q Local Address Foreign Address State > tcp 0 0 dlefebvre-ubuntu:domain *:* LISTEN > tcp 0 0 localhost:ipp *:* LISTEN > tcp 0 0 localhost:postgresql *:* LISTEN > tcp6 0 0 ip6-localhost:ipp [::]:* LISTEN > :~$ > My netstat -lt shows <quote> netstat -lt Active Internet connections (only servers) Proto Recv-Q Send-Q Local Address Foreign Address State tcp 0 0 0.0.0.0:ssh 0.0.0.0:* LISTEN tcp 0 0 localhost:postgres 0.0.0.0:* LISTEN tcp 0 0 localhost:smtp 0.0.0.0:* LISTEN tcp6 0 0 [::]:ssh [::]:* LISTEN tcp6 0 0 localhost:postgres [::]:* LISTEN </quote> Note that my entry for postgres shows 0.0.0.0:* instead of *:* > Logs dosen't show any errors and of course the server is running, i can > access in localhost without any trouble. > > I google all link i could found, every people who had the same issue made > mistake in configuration file. I think i am not, this is why i request your > help. > > Thanks for your time, i stay avaible if you need any more information. > > Cheers, Damien Lefebvre. > > > > > -- > View this message in context: > http://postgresql.nabble.com/Cannot-connect-from-local-network-to-my-postgresql-server-tp5845229.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- If you sent twitter messages while exploring, are you on a textpedition? He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown
