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


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?


yeah that’s no problem.

You need to make sure postgres is listening on 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.

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.

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

This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.