How to edit grafana.ini when I use docker option? I try to search, but not found.
Please suggest to me.

How to edit grafana.ini when I use docker option? I try to search, but not found.
Please suggest to me.

Hi, Grafana config is in /etc/grafana/grafana.ini (mostly all at defaults)...so something like that

vim /etc/grafana/grafana.ini
/etc/init.d/grafana-server restart

I use docker if I did like you mention. It will disappear after run docker next time, right?

@ALTELMA it will persist on normal stop / restart...but when you want it to be really persistent, also when updating to a newer pgwatch2 Docker image, then yes you should declare an explicit volume yourself for the config file or set up Grafana without Docker.

OK, thank you :)

Just want to note that /etc/init.d/grafana-server restart didn't work for me and I had to run supervisorctl restart grafana instead to get grafana to restart correctly

When installing with Config DB, I had to add some other environments to the pgwatch2-webui.service to make it work:

[Service]
Environment="PW2_WEBPORT=8081"
Environment="PW2_PGHOST=localhost"
Environment="PW2_DATASTORE=postgres"
Environment="PW2_PG_METRIC_STORE_CONN_STR= dbname=pgwatch2_metrics user=pgwatch2"
Environment="PW2_PGPASSWORD=yourpass"

Beside that, there is no documentation about parameters like PW2_PGPASSWORD. I had to look in the code for this param.

I didn't find any documentation for PGBouncer configuration.

@rostamiani Thanks for the input! It's sadly impossible to configure or document all possible different input parameter configurations as it's specific to used environment. But PW2_PGPASSWORD is actually listed in the ENV file - https://github.com/cybertec-postgresql/pgwatch2/blob/master/ENV_VARIABLES.md#web-ui

PgBouncer usage has some documentation lines here: https://pgwatch2.readthedocs.io/en/latest/advanced_features.html#pgbouncer-support