[FUG-BR] PostgreSql

[andre silva]

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: denisgranato at gmail.com
> Date: Thu, 13 Sep 2012 09:51:32 -0300
> To: freebsd at fug.com.br
> 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 <andre_bjl at hotmail.com> 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