Pgbouncer does not connect via service in windows

Asked

Viewed 93 times

0

I installed pgbouncer as a service in windows 10 using: 

pgbouncer.exe --regservice   <pgbouncer.ini>

Placing the ini path and from the folder where the pgbouncer exe is. The service is installed normally and I can start it by windows service manager.

But when I connect using the zeos in Delphi it says:

SQL Error: ERROR: No such user: postgres

Same error occurs using psql.

If I start pgbouncer via cmd using:

pgbouncer pgbouncer.ini

Everything works fine. Only the service that doesn’t work.

delphi postgresql zeos psql
  • 1

    it seems to me something with the user who is running the service... try to set it in the login tab in the windows service properties window

  • @Rovannlinhalis tried as you said and I couldn’t connect. The interesting thing is that the only user he accepts is: pgbouncer, however the password (which I tried several) it says is invalid: SQL Error: ERROR: Auth failed

  • I managed to take one more step I added: auth_user=postgres in pgbouncer.ini Like this: [databases]&#xA;&#xA;template1 = host=127.0.0.1 port=5432 dbname=novo auth_user=postgres Now when I connect it recognizes that the postgres user exists but now says that: SQL Error: fe_sendauth: no password supplied

1 answer

0

The whole problem is due to version. I installed the version: 1.6.1 64bits and it worked.

Browser other questions tagged delphi postgresql zeos psql

You are not signed in. Login or sign up in order to post.