Acho dificil, mas se não funcionar - dê um retorno. 2012/9/13 andre silva <[email protected]>
> > 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 > -- 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
