O pessoal q instalou e configurou o bd disse q nao precisa mexer neste arquivo a mesma esta comentanda no arquivo postgresql.conf. Como nao tenho experiencia em configuracao de bd, fico grato com qq ajuda dos srs. André Luiz
> From: [email protected] > Date: Thu, 13 Sep 2012 09:51:32 -0300 > To: [email protected] > Subject: Re: [FUG-BR] PostgreSql > > 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 ------------------------- Histórico: http://www.fug.com.br/historico/html/freebsd/ Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd
