[FUG-BR] PostgreSql

[Marcelo da Silva]

opcao listen_addresses

do postgresql.conf  ???????????????

Em 2012-09-13 09:41, andre silva escreveu:
> 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