0

I researched for spring boot, PostgreSQL and pgbouncer example and cannot find anywhere.

Do you know can we integrate pgbouncer with spring javax.sql.DataSource?

Can you share with me any page that can I take reference. When I look to Pgbouncer page cannot find example?

Muhammed şahsuvaroğlu
  • 479
  • 2
  • 7
  • 20
  • 1
    You just setup the database with a JDBC URL that poins to the pgBouncer server and port. Spring//JDBC won't even know that it's not a Postgres database but a load balancer. –  Aug 26 '20 at 13:53
  • my postgre host localhost port 5432 but pgbouncer is host 127.0.0.1 port xxx you mean I only change localhost to127.0.01 and port right? thats enough? – Muhammed şahsuvaroğlu Aug 26 '20 at 14:01
  • 1
    That should be enough, yes (and it's Postgres, not "postgre") –  Aug 26 '20 at 14:02
  • yes thank you ,but I get the error "prepared statement "S_24" already exists – Muhammed şahsuvaroğlu Aug 26 '20 at 14:03
  • For that error, see [Postgres - ERROR: prepared statement “S_1” already exists](https://stackoverflow.com/questions/7611926/postgres-error-prepared-statement-s-1-already-exists) – Mark Rotteveel Aug 27 '20 at 08:56

0 Answers0