User Tools

Site Tools


adm:setting_up_postgres_database

Setting up the Postgres database

Modifying the ID counters

Conflicts may arise between the Zibawa and Grafana database. If you find that newly created users cannot log in to Grafana, this may be because the userID of Zibawa is already occupied on the Grafana database. A work around is to move forward the user ID counter of the Zibawa database.

\connect zibawadb
ALTER SEQUENCE auth_user_id_seq RESTART WITH 50;

Installing pgAdmin4

Sooner or later it will probably be useful to have a GUI interface for Postgres.

http://askubuntu.com/questions/788457/how-to-install-pgadmin-4-in-server-mode-on-ubuntu-16-04

Running pgAdmin4

If you followed the steps above:

cd workspace/virtualenv/pgadmin
source bin/activate
python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py

Then access on http://localhost:5050

adm/setting_up_postgres_database.txt · Last modified: 2018/10/08 16:27 by matt