Help:PGAdmin4 with python - Revision history

Luisamesty at 10:24, 8 April 2018

2018-04-08T10:24:28Z

Luisamesty at 10:15, 8 April 2018

2018-04-08T10:15:04Z

Luisamesty at 10:08, 8 April 2018

2018-04-08T10:08:30Z

Luisamesty at 10:01, 8 April 2018

2018-04-08T10:01:16Z

Luisamesty at 09:48, 8 April 2018

2018-04-08T09:48:08Z

Show changes

Luisamesty at 09:36, 8 April 2018

2018-04-08T09:36:26Z

Luisamesty at 09:35, 8 April 2018

2018-04-08T09:35:00Z

Luisamesty at 09:34, 8 April 2018

2018-04-08T09:34:28Z

Show changes

Luisamesty at 09:30, 8 April 2018

2018-04-08T09:30:39Z

Show changes

Luisamesty at 09:27, 8 April 2018

2018-04-08T09:27:57Z

@@ Line 160: / Line 160: @@
-<big>2.	REMOTE ACCESS (For CLOUD Install)</big>
+'''<big>2.	REMOTE ACCESS (For CLOUD Install)</big>'''
 PGAdmin4 Folder:
@@ Line 185: / Line 185: @@
 PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4
-(Replace 3.X with your Python Version)
+'''(Replace 3.X with your Python Version)'''
-Before we start let’s exit the virtual enviroment using the follwoing command:
+'''Before we start let’s exit the virtual enviroment using the follwoing command:'''
 ''# deactivate''
-– To make PgAdmin 4 we need to make some extra modification, Open the pgAdmin4.py file and insert the following line in the begin of the file:
+To make PgAdmin 4 we need to make some extra modification, Open the '''pgAdmin4.py''' file and insert the following line in the begin of the file:
 ''# vi ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py''
@@ Line 199: / Line 199: @@
 [...]
-– Make it executable by doing:
+''' Make it executable by doing:'''
 ''# chmod +x  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py''
-– Now create a /etc/systemd/system/pgadmin4.service service file containing:
+ '''Now create a /etc/systemd/system/pgadmin4.service service file containing:'''
 ''# vi /etc/systemd/system/pgadmin4.service''
-[Unit]
+'''pgadmin4.service Content:'''
-Description=Pgadmin4 Service
+''After=network.target''
-After=network.target
+''[Service]''
-[Service]
+''User=root''
-User=root
+''# Point to the virtual environment directory''
-Group=root
+''WorkingDirectory=/root/pgadmin4''
-# Point to the virtual environment directory
+''# Point to the bin folder of your virtual environment''
-WorkingDirectory=/root/pgadmin4
+''# Environment="PATH=/home/qgis/Downloads/pgadmin4/bin"''
-# Point to the bin folder of your virtual environment
+''Environment="PATH=/root/pgadmin4/bin"''
-# Environment="PATH=/home/qgis/Downloads/pgadmin4/bin"
+''# ExecStart=/home/qgis/Downloads/pgadmin4/bin/python /home/web/Downloads/pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py''
-Environment="PATH=/root/pgadmin4/bin"
+''ExecStart="/root/pgadmin4/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py"''
-# ExecStart=/home/qgis/Downloads/pgadmin4/bin/python /home/web/Downloads/pgadmin4/lib/python3.6/site-packages/pgadmin4/pgAdmin4.py
+''PrivateTmp=true''
-ExecStart="/root/pgadmin4/lib/python3.5/site-packages/pgadmin4/pgAdmin4.py"
+''[Install]''
-PrivateTmp=true
+''WantedBy=multi-user.target''
-[Install]
+'''pgadmin4.service end of Content:'''
-– Enable and start PgAdmin Service at system boot:
+<big>'''Enable and start PgAdmin Service at system boot:'''</big>
-# sudo systemctl daemon-reload
+''# sudo systemctl daemon-reload''
-# sudo systemctl enable pgadmin4
+''# sudo systemctl enable pgadmin4''
-# sudo systemctl start pgadmin4
+''# sudo systemctl start pgadmin4''
-# sudo systemctl status  pgadmin4
+''# sudo systemctl status  pgadmin4''

@@ Line 125: / Line 125: @@
 Write:
-'#!/bin/bash'
+''#!/bin/bash''
-'cd ~/pgadmin4'
+''cd ~/pgadmin4''
-'source bin/activate'
+''source bin/activate''
-'python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py'
+''python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py''
@@ Line 138: / Line 138: @@
 Write:
-#!/bin/bash
+''#!/bin/bash''
-cd ~/pgadmin4
+''cd ~/pgadmin4''
-source bin/activate
+''source bin/activate''
 Now you can just run it with a simpler command:
@@ Line 158: / Line 158: @@
 pgAdmin 4 will not start in the environment where pgAdmin 3 was previously installed and used because of incompatible configuration in the .pgadmin directory. The simplest solution is to either clear
 that directory or tweak config_local.py to point to a clean new .pgadmin4directory.
 <big>2.	REMOTE ACCESS (For CLOUD Install)</big>
-PGAdmin4 Folder: ~/pgadmin4/lib/python3.X/site-packages/pgadmin4
+PGAdmin4 Folder:
 (Replace 3.X with your Python Version)
@@ Line 176: / Line 179: @@
-.	RUN as a Service
+<big>'''3.	RUN as a Service'''</big>
 Python file:  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
@@ Line 186: / Line 189: @@
 Before we start let’s exit the virtual enviroment using the follwoing command:
-# deactivate
+''# deactivate''
 – To make PgAdmin 4 we need to make some extra modification, Open the pgAdmin4.py file and insert the following line in the begin of the file:
-# vi ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
+''# vi ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py''
-#!/usr/bin/env python3
+''#!/usr/bin/env python3''
 [...]
@@ Line 198: / Line 201: @@
 – Make it executable by doing:
-# chmod +x  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
+''# chmod +x  ~/pgadmin4/lib/python3.x/site-packages/pgadmin4/pgAdmin4.py''
 – Now create a /etc/systemd/system/pgadmin4.service service file containing:
-# vi /etc/systemd/system/pgadmin4.service
+''# vi /etc/systemd/system/pgadmin4.service''
 [Unit]
 Description=Pgadmin4 Service
@@ Line 245: / Line 249: @@
 # sudo systemctl status  pgadmin4
 .	Access PGAdmin 4
 – Open http://Server_ip:5050 and logon to the PgAdmin using your credentials.
-.	Enable Postgresql Remote Access.
+<big>'''5.	Enable Postgresql Remote Access.'''</big>
 .1. Permitir conexiones de clientes desde un determinado rango

@@ Line 104: / Line 104: @@
 '''(Using Python3.x)'''
 $ cd ~/pgadmin4
@@ Line 115: / Line 113: @@
 '''Make a shortcut'''
 $ touch ~/pgadmin4/pgadmin4
@@ Line 128: / Line 125: @@
 Write:
-#!/bin/bash
+'#!/bin/bash'
-cd ~/pgadmin4
+'cd ~/pgadmin4'
-source bin/activate
+'source bin/activate'
-python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
+'python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py'

@@ Line 1: / Line 1: @@
 == PGADMIN4 ON UBUNTU 16.04 ==
-.	Install
+'''1.	Install'''
-.	Allow Remote Access
+'''3.	Run as a Service'''
-.	Run as a Service
+'''4.	Access PGAdmin 4'''
-.	Access PGAdmin 4
+'''5.	Enable Postgresql remote Access'''
+<big>'''1.	Install'''</big>
 Install dependencies, create a virtual environment, download, install & configure
-(Using Python2.x)
+'''(Using Python2.x)'''
 $ sudo apt-get install virtualenv python-pip libpq-dev python-dev
@@ Line 30: / Line 30: @@
 $ pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
-Using Python3.x (Preferred to avoid encoding related issues)
+'''(Using Python3.x - Preferred to avoid encoding related issues)'''
 $ sudo apt-get install virtualenv python3-pip libpq-dev python3-dev
@@ Line 44: / Line 44: @@
 $ pip3 install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v2.1/pip/pgadmin4-2.1-py2.py3-none-any.whl
 Configure
 Override default paths and set it to single-user mode in the local configuration file:
-(Using Python2.x)
+'''(Using Python2.x) :'''
 $ nano lib/python2.7/site-packages/pgadmin4/config_local.py
-For Python3.x:
+'''(Using Python3.x) :'''
 $ nano lib/python3.x/site-packages/pgadmin4/config_local.py
-Write:
+'''Write:'''
 import os
@@ Line 72: / Line 73: @@
 SERVER_MODE = False
-(Using Python2.x)
+'''Run'''
 $ python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
-For Python3.x:
+'''(Using Python3.x) :'''
 $ python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
 Access
 Access at http://localhost:5050
-Exit
+'''Exit'''
 Exit with Ctrl-C
-Run again
+'''Run again'''
-(Using Python2.x)
+'''(Using Python2.x)'''
 $ cd ~/pgadmin4
@@ Line 100: / Line 103: @@
 $ python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
-For Python3.x
+'''(Using Python3.x)'''
 #!/bin/bash
@@ Line 110: / Line 113: @@
 $ python3 lib/python3.x/site-packages/pgadmin4/pgAdmin4.py
 Make a shortcut
 $ touch ~/pgadmin4/pgadmin4
@@ Line 118: / Line 123: @@
 $ nano ~/pgadmin4/pgadmin4
 (Using Python2.x)
 Write:
@@ Line 130: / Line 136: @@
 python lib/python2.7/site-packages/pgadmin4/pgAdmin4.py
-For Python3.x
 Write:
@@ Line 146: / Line 153: @@
 ~/pgadmin4/pgadmin4
 Python3 users    -  Replace [x] in Python3.x with your respective version.
 Conflict with pgAdmin 3 configuration

@@ Line 1: / Line 1: @@
 == PGADMIN4 ON UBUNTU 16.04 ==
 .	Install
 .	Allow Remote Access