pgAdmin4 installation and PostgreSQL DB connection
pgAdmin is the most popular and feature rich Open Source Administration and Development platform for PostgreSQL, the most advanced Open Source database in the world.
This recording talks about pgAdmin setup on Windows. Below is the running notes used in this video:
***
1) Install pgAdmin4 : Client on Windows
https://www.pgadmin.org/
2) Enable PostgreSQL server for remote connections : Server
RHEL 7.5 (in VMWARE)
netstat -noa
By default, Postgres DB Server is not accessible from outside host
$PGDATA/postgresql.conf
listen_address = 'localhost' == '*'
$PGDATA/pg_hba.conf
host all all 0.0.0.0/0 md5
postgres: as one of the default user databases
postgres: as OS user
postgres: as database user
3) client ==== Server
pgAdmin4 === PostgreSQL 11 DB Server
Hostname: 192.168.40.132
Port Number: 5432
Database Name: postgres
Username: postgres
password: ********
***
Watch video pgAdmin4 installation and PostgreSQL DB connection online without registration, duration hours minute second in high quality. This video was added by user Ravi Nandigam 03 October 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 44,381 once and liked it 277 people.