Setup PostgreSQL cluster in docker compose for local development

[mfvanek]

See https://hub.docker.com/r/paunin/postgresql-cluster-pgsql/ and https://habr.com/ru/post/334484/

[Evreke]

I am working on mfvanek/pg-index-health#121 and faced some problems trying to start cluster from resources provided by you.

postgres-cluste-pgsql it looks nice, but it hasn't been updated for a long time, so the latest version doesn't work, since some changes have been made to the repositories referenced by docker files.

pg-dock is not working either but seems more simpler to fix than first one.

There are two ways i see.

1. Fix one of two provided solutions to use them.
2. Provide new solution.

Personally i prefer first way.

[mfvanek]

@Evreke Let's take a look at bitnami containers https://github.com/bitnami/bitnami-docker-postgresql

[Evreke]

For local development you can use default bitnami postgresql container with repmgr. It works like a charm. I used it working on mfvanek/pg-index-health#121

[Evreke]

Sorry, I've been busy for a long time. I am starting to work on this task. @mfvanek

[Evreke]

With afb84a5 I add plugin that searches and run containers defined in docker-compose file.

This approach hash drawbacks:

• gradle tasks must be used to start project.
• you need to connect to the debugger after running the application in debug mode, otherwise it will not progress further.
• if you try to stop application your build will be canceled so composeDown task won't run. I guess it's because of gradle misconfiguration.
• the most serious disadvantage is the inability to programmatically manage the cluster.

But advantages are:

• a more concise way to add services is to simply add them to the compose file.
• probably the fastest way to integrate into a cluster and test hypotheses.