Devops: PostgreSQL - maple-dev-team/docs GitHub Wiki

sudo apt update
sudo apt install postgresql postgresql-contrib
sudo -i -u postgres
createdb nexterp psql
\password postgres
	- type the new password
\q
sudo apt install php-pgsql
sudo apt install php7.4-pdo-pgsql

wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -
echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" |sudo tee  /etc/apt/sources.list.d/pgdg.list
sudo apt update
sudo apt install pgadmin4 pgadmin4-apache2
	- type any email and password
http://localhost/pgadmin4/
tab connection
	host: localhost
	user: postgres
	pass: [you set this when installing postgres locally]

Install pgAdmin4 on Linux Mint 20
sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
sudo apt-get install build-essential libssl-dev libffi-dev libgmp3-dev
sudo apt-get install python3-virtualenv libpq-dev python3-dev

cd ~
mkdir pgAdmin4
cd pgAdmin4
virtualenv pgAdmin4
sudo chmod -R 777 pgAdmin4
cd pgAdmin4/bin
source activate
pip install https://ftp.postgresql.org/pub/pgadmin/pgadmin4/v4.23/pip/pgadmin4-4.23-py3-none-any.whl

nano ./lib/python3.8/site-packages/pgadmin4/config_local.py

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

python ./lib/python3.8/site-packages/pgadmin4/pgAdmin4.py

cd ~ && cd pgAdmin4 && sudo virtualenv pgAdmin4 && cd pgAdmin4/bin && source activate && cd .. && cd lib/python3.8/site-packages/pgadmin4 && python pgAdmin4.py