Dump config through Admin API

[steve-chavez]

Problem

Currently --dump-config outputs the config applied by env vars, files and in-db config.

postgrest-with-postgresql-16 postgrest-run --dump-config 

db-aggregates-enabled = false
db-anon-role = "postgrest_test_anonymous"
...

However that doesn't work for an already running instance

Solution

Use the admin api (ref) to output the config of a running instance. Like:

curl localhost:3001/config

200 OK
Content-Type: text/plain

db-aggregates-enabled = false
db-anon-role = "postgrest_test_anonymous"
db-channel = "pgrst"
db-channel-enabled = true
db-extra-search-path = "public"
db-max-rows = ""
db-plan-enabled = false
db-pool = 1
db-pool-acquisition-timeout = 1
db-pool-max-lifetime = 1800
db-pool-max-idletime = 30
db-pool-automatic-recovery = true
db-pre-request = ""
db-prepared-statements = true
db-root-spec = ""
db-schemas = "test"
db-config = true
db-pre-config = ""
db-tx-end = "commit"
db-uri = "postgresql://"
jwt-aud = ""
jwt-role-claim-key = ".\"role\""
jwt-secret = ""
jwt-secret-is-base64 = false
jwt-cache-max-lifetime = 0
log-level = "error"
openapi-mode = "follow-privileges"
openapi-security-active = false
openapi-server-proxy-uri = ""
server-cors-allowed-origins = ""
server-host = "!4"
server-port = 3000
server-trace-header = ""
server-timing-enabled = false
server-unix-socket = ""
server-unix-socket-mode = "660"
admin-server-port = ""

[wolfgangwalther]

Would also be helpful to look at the schema cache.

[SkyWriter]

Warm greetings! I took a stab on it, and wondering if I'm going in a right direction with my implementation at #3193 at all. Can someone take a brief look?

(Just a draft now, I'm going to bring it to a production quality, with tests and other important things, before submitting for a real review)

[SkyWriter]

Would also be helpful to look at the schema cache.

Nice idea! Sounds like semantically worth a separate endpoint, though. What do you think?

[wolfgangwalther]

Sounds like semantically worth a separate endpoint, though.

Absolutely!

[steve-chavez]

Closed on #3193. Tracking Admin API for Schema cache on #3210