Eles nao querem q mexa em nada no bd, mas se for preciso levo ate o responsavel pela empresa. Existe uma vpn entre a filial e a matriz, e preciso q esta porta esteja na escuta na matriz onde ta instalado no o bd, com isso poderá migrar o banco de dados da matriz pra filial entre a vpn. Andre
> Date: Thu, 13 Sep 2012 10:12:11 -0300 > From: [email protected] > To: [email protected] > Subject: Re: [FUG-BR] PostgreSql > > 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 ------------------------- Histórico: http://www.fug.com.br/historico/html/freebsd/ Sair da lista: https://www.fug.com.br/mailman/listinfo/freebsd
