[documentation] Trying out admin commands using the Docker demo

[andyatkinson]

Thanks for providing a convenient Docker based demo, where I can cd to the root, run docker compose up using the root directory docker-compose.yml, connect via psql, inspect sharded tables and run commands like \dt.

However, I wanted to also try out some admin commands like show pools, but couldn't figure out how to connect to the admin database. I understand its a virtual database like the pgbouncer database. I wanted to run admin commands like show config.

I wasn't able to answer my questions using the documentation for this for the Admin site or for the main README about the main directory demo (not the examples/demo demo, which I also tried booting and seeing if I could connect to an admin database).

I was hoping there was some simple default credentials like these, but I wasn't sure on the default dbname/user/password:
https://github.com/pgdogdev/pgdog/blob/main/pgdog/tests/admin.sh

I tried those above but couldn't connect. I found documentation about the admin database password being generated but I couldn't figure out how to do that of whether I need to do that for the demo. There's also documentation with a hunter2 password.

Is the admin database demo-able via Docker? If so, is it worth adding pointers in the Admin site documentation for anyone that wishes to try out the commands? Thank you.

[levkk]

Ah woops, we should add it to the demo at least. You can add this to demo/pgdog.toml:

[admin]
password = "admin"

and then you'll be able to connect via psql:

PGPASSWORD=admin psql [...] -U admin admin

The admin docs could also use some attention for sure.