pgadmin3 can be installed using following command
sudo apt-get install pgadmin3
You can invoke pgadmin3 GUI from main menu as well as by typing following command.
$ pgadmin3
From file menu, please use ‘add server’ and enter data as below:
If you facing authentication issue, please use following commands to reset the password.
$sudo -u postgres psql postgres
psql (9.6.3)
Type "help" for help.
postgres=# password postgres
Enter new password:
Enter it again: