Page 1 of 1
install pgAdmin4 manually
Posted: 12 May 2020, 17:08
by brid.surapol
Code: Select all
sudo apt-get install build-essential libssl-dev libffi-dev libgmp3-dev virtualenv python-pip libpq-dev python-dev
Code: Select all
mkdir pgadmin4
cd pgadmin4
virtualenv pgadmin4
cd pgadmin4
source bin/activate
download (version 4.21 หรือ version ใหม่กว่า)
https://ftp.postgresql.org/pub/pgadmin/ ... ne-any.whl
copy pgadmin4-4.21-py2.py3-none-any.whl ไปยัง folder pgadmin4
Code: Select all
pip install pgadmin4-4.21-py2.py3-none-any.whl
Code: Select all
vim lib/python2.7/site-packages/pgadmin4/config_local.py
ใส่ content ข้างล่าง เข้าไปใน config_local.py
Code: Select all
import os
DATA_DIR = os.path.realpath(os.path.expanduser(u'~/.pgadmin/'))
LOG_FILE = os.path.join(DATA_DIR, 'pgadmin4.log')
SQLITE_PATH = os.path.join(DATA_DIR, 'pgadmin4.db')
SESSION_DB_PATH = os.path.join(DATA_DIR, 'sessions')
STORAGE_DIR = os.path.join(DATA_DIR, 'storage')
SERVER_MODE = False
run pgAdmin4 ด้วยคำสั่ง
Code: Select all
python lib/python3.8/site-packages/pgadmin4/pgAdmin4.py
pgadmin4 bash script
Posted: 12 May 2020, 17:13
by brid.surapol
Code: Select all
source /installed_folder/pgadmin4/bin/activate
python /installed_folder/pgadmin4/lib/python3.8/site-packages/pgadmin4/pgAdmin4.py
ตัวอย่าง
Code: Select all
source /data/brid_dev/apps.bin/pgadmin4/bin/activate
python /data/brid_dev/apps.bin/pgadmin4/lib/python3.8/site-packages/pgadmin4/pgAdmin4.py
Re: install pgAdmin4 manually
Posted: 16 Jul 2020, 17:38
by brid.surapol
Code: Select all
sudo vim /etc/apt/sources.list.d/pgdg.list
add this line to the above "file"
Code: Select all
deb http://apt.postgresql.org/pub/repos/apt/ focal-pgdg main
Code: Select all
wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
Code: Select all
sudo apt-get update
sudo apt install pgadmin4 pgadmin4-apache2
Code: Select all
sudo a2enmod rewrite
sudo systemctl restart apache2
in browser
Code: Select all
http://localhost/pgadmin4/
http://your-server/pgadmin4/