fly-apps / postgres-flex

Postgres HA setup using repmgr
87 stars 43 forks source link

Configuring Postgres from Docker container #207

Open lithdew opened 1 year ago

lithdew commented 1 year ago

I noticed that for the TimescaleDB Docker image, the TIMESCALEDB_ENABLED environment variable is explicitly set to append 'timescaledb' to "shared_preload_libraries" in the Postgres config.

I'd like to install other Postgres extensions in my own custom Docker image such as pg_stat_monitor or pg_safeupdate which requires overwriting Postgres' config with shared_preload_libraries.

fly pg config exists, though I would prefer not to have to manually re-configure my Postgres cluster every time I re-deploy a new one.

Are there any ways to make Postgres configuration changes right from the Docker image and ensure that it persists throughout a deployed Fly.io Postgres cluster?