Getting started with pgadmin4 Source

July 4, 2016 Markdown source

1---
2title: 'Getting started with pgadmin4'
3date: '2016-07-04'
4published_at: '2016-07-04T09:14:00.000+10:00'
5tags: ['databases', 'linux', 'pgadmin4', 'python']
6author: 'Gavin Jackson'
7excerpt: 'Getting started with pgadmin4 Not sure how many postgres users there are out there - but you may be interested in the latest version of pgadmin (version 4 beta) - this is traditionally a GUI based fro...'
8updated_at: '2016-07-04T09:15:07.964+10:00'
9legacy_url: 'http://www.gavinj.net/2016/07/getting-started-with-pgadmin4-not-sure.html'
10---
11
12##  Getting started with pgadmin4
13
14[![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_IZTT_grk5lZgS_POyMWTXoWmvyrVpl68_O1JSex1gEmX3MEoxJXmoK-Ramy-TAsCmQ8KeB2OWMCUakEdFVbcoC_gBmX2l2mLVKSD1WcqFW2JgxVjNoCWm-tAARsi-G5_FycCiuHjuB8/s640/pgadmin4_1.png)](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_IZTT_grk5lZgS_POyMWTXoWmvyrVpl68_O1JSex1gEmX3MEoxJXmoK-Ramy-TAsCmQ8KeB2OWMCUakEdFVbcoC_gBmX2l2mLVKSD1WcqFW2JgxVjNoCWm-tAARsi-G5_FycCiuHjuB8/s1600/pgadmin4_1.png)
15
16Not sure how many postgres users there are out there - but you may be interested in the latest version of pgadmin (version 4 beta) - this is traditionally a GUI based front end postgresql that provides easy access to manage and explore local and remote postgresql database instances.
17
18The latest iteration is a complete rewrite - it is a web based application written in python flask (using a bootstrap and jquery front end). A native QT wrapper is also available that bundles the python app and basically injects the web interface into the frame.
19
20There is a lot to like about this release - firstly it is web-based meaning you can run it directly on your database server, it provides all of the main features of pgadmin3 - there are a few things missing (like the quick report function for producing html formatted reports - and the ability to quickly insert a record whilst in table mode).
21
22It does introduce sql completion which is kind of handy (just hit ctrl+space and it will provide a list of table or column suggestions). It also has a dashboard view that provides realtime database server metrics.
23
24It also provides tabs - you can write multiple queries in different tabs (allowing you to easily jump between different queries and result sets).
25
26[![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPyM4-cjKCjjyWucnmP6fP0vYSx5YOZhwRYG-T4cM0rHy_fka8mSkBZ7zrrHdfwOM8NuNmhhFpYtzsvoWXFjx-pkWSwSxJO8mOKKcQiX4mMlytPWRytQRXAvZnsQg1PjCIYasN9CTBql8/s640/pgadmin4_2.png)](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPyM4-cjKCjjyWucnmP6fP0vYSx5YOZhwRYG-T4cM0rHy_fka8mSkBZ7zrrHdfwOM8NuNmhhFpYtzsvoWXFjx-pkWSwSxJO8mOKKcQiX4mMlytPWRytQRXAvZnsQg1PjCIYasN9CTBql8/s1600/pgadmin4_2.png)
27
28Here are some installation (and execution) instructions (python 2 only).
29
30###  1. Download
31
32Download pgadmin4-1.0_beta1-py2-none-any.whl from [https://www.pgadmin.org/download/pip4.php](https://www.pgadmin.org/download/pip4.php)
33
34###  2. Install
35
36virtualenv ~/bin/virtualenv_pgadmin
37
38. ~/bin/virtualenv_pgadmin/bin/activate
39
40pip install ~/Downloads/pgadmin4-1.0b2-py2-none-any.whl
41
42cd ~/bin/virtualenv_pgadmin/lib/python2.7/site-packages/pgadmin4
43
44cp config.py config_local.py
45
46###  3. Run!
47
48python./pgadmin4.py
49
50It will ask you to enter an email address (and password to log in to the webapp).
51
52Hit [http://localhost:5050](http://localhost:5050/)
53
54
55

---
title: 'Getting started with pgadmin4'
date: '2016-07-04'
published_at: '2016-07-04T09:14:00.000+10:00'
tags: ['databases', 'linux', 'pgadmin4', 'python']
author: 'Gavin Jackson'
excerpt: 'Getting started with pgadmin4 Not sure how many postgres users there are out there - but you may be interested in the latest version of pgadmin (version 4 beta) - this is traditionally a GUI based fro...'
updated_at: '2016-07-04T09:15:07.964+10:00'
legacy_url: 'http://www.gavinj.net/2016/07/getting-started-with-pgadmin4-not-sure.html'
---

##  Getting started with pgadmin4

[![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_IZTT_grk5lZgS_POyMWTXoWmvyrVpl68_O1JSex1gEmX3MEoxJXmoK-Ramy-TAsCmQ8KeB2OWMCUakEdFVbcoC_gBmX2l2mLVKSD1WcqFW2JgxVjNoCWm-tAARsi-G5_FycCiuHjuB8/s640/pgadmin4_1.png)](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg_IZTT_grk5lZgS_POyMWTXoWmvyrVpl68_O1JSex1gEmX3MEoxJXmoK-Ramy-TAsCmQ8KeB2OWMCUakEdFVbcoC_gBmX2l2mLVKSD1WcqFW2JgxVjNoCWm-tAARsi-G5_FycCiuHjuB8/s1600/pgadmin4_1.png)

Not sure how many postgres users there are out there - but you may be interested in the latest version of pgadmin (version 4 beta) - this is traditionally a GUI based front end postgresql that provides easy access to manage and explore local and remote postgresql database instances.

The latest iteration is a complete rewrite - it is a web based application written in python flask (using a bootstrap and jquery front end). A native QT wrapper is also available that bundles the python app and basically injects the web interface into the frame.

There is a lot to like about this release - firstly it is web-based meaning you can run it directly on your database server, it provides all of the main features of pgadmin3 - there are a few things missing (like the quick report function for producing html formatted reports - and the ability to quickly insert a record whilst in table mode).

It does introduce sql completion which is kind of handy (just hit ctrl+space and it will provide a list of table or column suggestions). It also has a dashboard view that provides realtime database server metrics.

It also provides tabs - you can write multiple queries in different tabs (allowing you to easily jump between different queries and result sets).

[![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPyM4-cjKCjjyWucnmP6fP0vYSx5YOZhwRYG-T4cM0rHy_fka8mSkBZ7zrrHdfwOM8NuNmhhFpYtzsvoWXFjx-pkWSwSxJO8mOKKcQiX4mMlytPWRytQRXAvZnsQg1PjCIYasN9CTBql8/s640/pgadmin4_2.png)](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPyM4-cjKCjjyWucnmP6fP0vYSx5YOZhwRYG-T4cM0rHy_fka8mSkBZ7zrrHdfwOM8NuNmhhFpYtzsvoWXFjx-pkWSwSxJO8mOKKcQiX4mMlytPWRytQRXAvZnsQg1PjCIYasN9CTBql8/s1600/pgadmin4_2.png)

Here are some installation (and execution) instructions (python 2 only).

###  1. Download

Download pgadmin4-1.0_beta1-py2-none-any.whl from [https://www.pgadmin.org/download/pip4.php](https://www.pgadmin.org/download/pip4.php)

###  2. Install

virtualenv ~/bin/virtualenv_pgadmin

. ~/bin/virtualenv_pgadmin/bin/activate

pip install ~/Downloads/pgadmin4-1.0b2-py2-none-any.whl

cd ~/bin/virtualenv_pgadmin/lib/python2.7/site-packages/pgadmin4

cp config.py config_local.py

###  3. Run!

python./pgadmin4.py

It will ask you to enter an email address (and password to log in to the webapp).

Hit [http://localhost:5050](http://localhost:5050/)