A configuração acima é padrão até em Linux.
2012/9/13 Denis Granato <[email protected]> > Bom dia Andre, > > Configurou o arquivo /usr/local/pgsql/data/pg_hba.conf > > liberando o acesso pela sua rede? > > # IPv4 local connections: > ###host all all 127.0.0.1/32 trust > host all all 192.168.0.0/24 md5 > > abs > > > On Thu, Sep 13, 2012 at 9:41 AM, andre silva <[email protected]> > wrote: > > > > > Bom dia!!! > > > > Estou com um problema de comunicao onde nao consigo ter acesso na porta > > 5432do db. Alguem pode ajudar a resolver, pois ate o momento nao seguir > ter > > exito. > > > > Usando a ferramenta pgAdmin III aparece o seguinte erro de conexao: > > > > Server doesn't listen > > The server doesn't accept connections: the connection library reports > > could not connect to server: Connection refused (0x0000274D/10061) Is the > > server running on host "192.168.0.70" and accepting TCP/IP connections on > > port 5432? > > If you encounter this message, please check if the server you're trying > to > > contact is actually running PostgreSQL on the given port. Test if you > have > > network connectivity from your client to the server host using ping or > > equivalent tools. Is your network / VPN / SSH tunnel / firewall > configured > > correctly? > > For security reasons, PostgreSQL does not listen on all available IP > > addresses on the server machine initially. In order to access the server > > over the network, you need to enable listening on the address first. > > For PostgreSQL servers starting with version 8.0, this is controlled > using > > the "listen_addresses" parameter in the postgresql.conf file. Here, you > can > > enter a list of IP addresses the server should listen on, or simply use > '*' > > to listen on all available IP addresses. For earlier servers (Version 7.3 > > or 7.4), you'll need to set the "tcpip_socket" parameter to 'true'. > > You can use the postgresql.conf editor that is built into pgAdmin III to > > edit the postgresql.conf configuration file. After changing this file, > you > > need to restart the server process to make the setting effective. > > If you double-checked your configuration but still get this error > message, > > it's still unlikely that you encounter a fatal PostgreSQL misbehaviour. > You > > probably have some low level network connectivity problems (e.g. firewall > > configuration). Please check this thoroughly before reporting a bug to > the > > PostgreSQL community. > > > > Grato, > > > > André Luiz > > ------------------------- > > Histórico: http://www.fug.com.br/historico/html/freebsd/ > > Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd > > > ------------------------- > Histórico: http://www.fug.com.br/historico/html/freebsd/ > Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd > -- João Luis Mancy dos Santos joaocep at gmail.com (msn too) http://joaocep.blogspot.com http://www.istf.com.br/perguntas/ http://www.fug.com.br/content/view/20/69/ uin 82889044 ------------------------- Histórico: http://www.fug.com.br/historico/html/freebsd/ Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd
