Ubuntu 22.04
Sponsored Link

PostgreSQL 14 : Install phpPgAdmin2022/05/13
 
Install phpPgAdmin to operate PostgreSQL on web browser from Client computers.
[1]
Install Apache2, refer to here.
[2]
Install PHP, refer to here.
[3] Install phpPgAdmin.
root@dlp:~#
apt -y install phppgadmin php-pgsql
root@dlp:~#
vi /etc/phppgadmin/config.inc.php
# line 105 : change to [false] if you allow to login with privileged user like postgres, root

$conf['extra_login_security'] = true;
# line 111 : change to [true] if you set config that database owners can look only their own databases

$conf['owned_only'] = false;
root@dlp:~#
vi /etc/apache2/conf-enabled/phppgadmin.conf
# line 12 : set access permission for phpPgAdmin

Require local
Require ip 10.0.0.0/24
root@dlp:~#
systemctl restart apache2

[4] Access to [http://(server's hostname or IP address)/phppgadmin/] with web browser from any Clients which are in the Network you set to allow. Then phpPgAdmin site is shown, Click [PostgreSQL] link on the left pane.
[5] Authenticate as a user and password which is in PostgreSQL.
[6] After successing authentication, phpPgAdmin admin site is shown. It's possible to operate PostgreSQL databases on here.
Matched Content