Is it possible to connect to the postgresql over a gui?

[cjschratt]

Hi,

I have the newest Zammad version running on an Debian 9. I used the offical installation instructions, and everything runs fine.

However I was wondering if it would be possible to connect to the Postgresql over a gui tool like pgAdmin?

Thanks,
Christian.

[chesty]

yeah that’s no problem.

You need to make sure postgres is listening on 0.0.0.0 edit /etc/postgresql/9.6/main/postgresql.conf
and check listen_addresses = '*'
and edit /etc/postgresql/9.6/main/pg_hba.conf which has lots of comments on what all the fields mean.

I’m not sure what version of postgres debian 9 has, it might not be 9.6 but it’s the same steps with a slightly different directory for the config files, maybe /etc/postgresql/9.5/main/pg_hba.conf for example.

https://www.pgadmin.org/docs/pgadmin3/1.22/connect-error.html#connect-error
https://www.postgresql.org/docs/9.6/static/auth-pg-hba-conf.html

[thorsteneckel]

Please make sure to use the DB readonly! Zammad caches queries and other data which will most likely lead to some unexpected side effects and errors somewhere down the road.

[cjschratt]

Thank you… But in this case I better don’t touch anything.