Ola boa tarde Euler, muito grato pela atencao, fiz as seguintes alteracoes:
NO pgbouncer.ini: [databases] meudb = host=localhost port=5432 dbname=revisa acima entao eu dei um alias chamado meudb para o banco revisa em localhost e porta 5432 [pgbouncer] logfile = C:\Program Files (x86)\PgBouncer\log\pgbouncer.log pidfile = C:\Program Files (x86)\PgBouncer\log\pgbouncer.pid ;ip address or * which means all ip-s listen_addr = localhost listen_port = 6432 auth_type = trust auth_file = C:\Program Files (x86)\PgBouncer\etc\userlist.txt admin_users = postgres acima eu coloque localhost sem estar envolvido por aspas e coloquei o caminho completo como vc mencionou. No userlist.txt : "postgres" "wg091514" obs: o firewall esta desativado ao tentar conectar ocorre o seguinte erro que eu peguei do log: 2016-10-26 14:49:26.091 5184 LOG File descriptor limit: -1 (H:-1), max_client_conn: 100, max fds possible: 130 2016-10-26 14:49:26.104 5184 LOG listening on ::1/6432 2016-10-26 14:49:26.104 5184 LOG listening on 127.0.0.1:6432 2016-10-26 14:49:26.104 5184 LOG process up: pgbouncer 1.7.2, libevent 2.0.21-stable (win32), adns: evdns2, tls: OpenSSL 1.0.2g 1 Mar 2016 2016-10-26 14:49:46.800 5184 LOG C-00770FF0: meudb/postgres@[::1]:51808 login attempt: db=meudb user=postgres tls=no 2016-10-26 14:49:46.954 5184 WARNING 2016-10-26 14:49:46.955 5184 LOG S-007A7258: meudb/postgres@127.0.0.1:5432 closing because: connect failed (age=0) 2016-10-26 14:50:01.858 5184 WARNING 2016-10-26 14:50:01.859 5184 LOG S-007A7258: meudb/postgres@127.0.0.1:5432 closing because: connect failed (age=0) 2016-10-26 14:50:17.042 5184 WARNING 2016-10-26 14:50:17.043 5184 LOG S-007A7258: meudb/postgres@127.0.0.1:5432 closing because: connect failed (age=0) 2016-10-26 14:50:26.101 5184 LOG Stats: 0 req/s, in 0 b/s, out 0 b/s,query 0 us 2016-10-26 14:50:31.931 5184 WARNING 2016-10-26 14:50:31.931 5184 LOG S-007A7258: meudb/postgres@127.0.0.1:5432 closing because: connect failed (age=0) 2016-10-26 14:50:46.966 5184 LOG C-00770FF0: meudb/postgres@[::1]:51808 closing because: client_login_timeout (server down) (age=60) 2016-10-26 14:50:46.966 5184 WARNING C-00770FF0: meudb/postgres@[::1]:51808 Pooler Error: client_login_timeout (server down) GRATO [image: Foto] *LuMoraes* *O mais completo para seu comércio.* 2016-10-26 13:30 GMT-02:00 Euler Taveira <eu...@timbira.com.br>: > On 26-10-2016 11:32, lu moraes santos wrote: > > listen_addr = localhost > > listen_port = 6432 > > auth_type = md5 > > auth_file = pgbouncer-users.txt > > admin_users = postgres > > > > No userlist.txt : > > > pgbouncer-users.txt ou userlist.txt? Coloca o caminho completo no > auth_file pois sem o caminho completo o carregamento do arquivo em > auth_file depende do diretório atual. Alguma pista no log (inicie o > serviço com -v)? > > > psql: ERROR: pgbouncer cannot connect to server > > > Você já verificou o firewall da máquina? > > > -- > Euler Taveira Timbira - http://www.timbira.com.br/ > PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento > _______________________________________________ > pgbr-geral mailing list > pgbr-geral@listas.postgresql.org.br > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
