4 ms·

Is pgbouncer enabled by default in here ? One other request - could you write how to use it (connect to it) ?

gyzmau 5y ago
Not really replying to your question. But recently I got the occasion to work with https://github.com/CrunchyData/postgres-operator https://github.com/CrunchyData/postgres-operator . It's a bit rough around the edges wit the v5, which is very recent, but overall I was really happy with it. I am still not using it in production but it's on the way.
- mdasen 5y ago
  I'm curious if you've looked at https://github.com/zalando/postgres-operator https://github.com/zalando/postgres-operator and had thoughts on how it compared. The CrunchyData operator seems to use Patroni and links to the Patroni documentation which links to the Zalando Postgres Operator from the same company as Patroni.
angelico 5y ago
Hi! I'm one of the contributors to the repo. Just to clarify, our Docker image [0] only contains the latest version of Postgres (13) and the common extensions listed out here [1]. All the other features such as this [2] and this [3] are only available in the AWS EC2 or DO droplet images. We've since updated our README to make that clearer :-) You can still connect the DB with a PgBouncer image spun up in another container however. Unfortunately, I can't really recommend you which one since there doesn't seem to be an official Docker image for PgBouncer and I myself have never tried any of the existing ones out there. If you're looking to use PostgREST however, they do have an official Docker image that you can use over here [4]. [0]: https://hub.docker.com/r/supabase/postgres https://hub.docker.com/r/supabase/postgres [1]: https://github.com/supabase/postgres#extensions https://github.com/supabase/postgres#extensions [2]: https://github.com/supabase/postgres#enhanced-security https://github.com/supabase/postgres#enhanced-security [3]: https://github.com/supabase/postgres#additional-goodies https://github.com/supabase/postgres#additional-goodies [4]: https://hub.docker.com/r/postgrest/postgrest/ https://hub.docker.com/r/postgrest/postgrest/

Not really replying to your question. But recently I got the occasion to work with https://github.com/CrunchyData/postgres-operator https://github.com/CrunchyData/postgres-operator . It's a bit rough around the edges wit the v5, which is very recent, but overall I was really happy with it. I am still not using it in production but it's on the way.

mdasen 5y ago
I'm curious if you've looked at https://github.com/zalando/postgres-operator https://github.com/zalando/postgres-operator and had thoughts on how it compared. The CrunchyData operator seems to use Patroni and links to the Patroni documentation which links to the Zalando Postgres Operator from the same company as Patroni.

angelico 5y ago

Hi! I'm one of the contributors to the repo. Just to clarify, our Docker image [0] only contains the latest version of Postgres (13) and the common extensions listed out here [1]. All the other features such as this [2] and this [3] are only available in the AWS EC2 or DO droplet images. We've since updated our README to make that clearer :-) You can still connect the DB with a PgBouncer image spun up in another container however. Unfortunately, I can't really recommend you which one since there doesn't seem to be an official Docker image for PgBouncer and I myself have never tried any of the existing ones out there. If you're looking to use PostgREST however, they do have an official Docker image that you can use over here [4]. [0]: https://hub.docker.com/r/supabase/postgres https://hub.docker.com/r/supabase/postgres [1]: https://github.com/supabase/postgres#extensions https://github.com/supabase/postgres#extensions [2]: https://github.com/supabase/postgres#enhanced-security https://github.com/supabase/postgres#enhanced-security [3]: https://github.com/supabase/postgres#additional-goodies https://github.com/supabase/postgres#additional-goodies [4]: https://hub.docker.com/r/postgrest/postgrest/ https://hub.docker.com/r/postgrest/postgrest/