How To Install Phppgadmin On Debian Server
phpPgAdmin is an web interface for accessing and managing PostgreSQL databases in a very easy way. We can easily create new databases, tables in the database, users, stored procedures etc. Also, we can execute PL/pgSQL and other stored procedures. It also provides an option for database backup and restores from the web interface.
This article will help you to install phpPgAdmin web interface to manage PostgreSQL server on Ubuntu Systems. We are assuming that you already have installed PostgreSQL in your Ubuntu system, If not first install it using another article Install PostgreSQL on Ubuntu first.
Step 1 – Install Prerequisites
PhpPgAdmin required PHP and Apache2 must be installed on your system. Also, you will need php-pgsql libraries installed on the system. If you don’t have PHP installed, Use tutorial Install PHP7 or Install PHP5 on system. After installing PHP and Apache install the PHP module for postgresql.
Debian Tutorial – Here we will show you how to install PHPMyAdmin on Debian 9 Stretch. PHPMyAdmin is a web based application to manage your MySQL Server. With PHPMyAdmin we can easily perform several administrative tasks to our MySQL or MariaDB Server such as create, edit, delete databases, users and also perform queries, export and import databases and many more. For the phpPgAdmin to work properly, you should also make few changes to the postgresql.conf file. If you are running phpPgAdmin (Apache/PHP) on a server that is different than the server that is running PostgreSQL server, then you should modify the postgresql.conf file on the PostgreSQL server, and change the listen_address.
Step 2 – Install phpPgAdmin
We are assuming here that you already have PostgreSQL server running on your Ubuntu system. If not install it first. Now phpPgAdmin packages are also available under default Ubuntu repositories. Use the following command to install phpPgAdmin.
Step 3 – Configure PostgreSQL
Now, you may need to make some changes in your PostgreSQL server to access via phpPgAdmin. First this to access PostgreSQL on all interfaces, update the following settings under postgresql.conf file.
After this enable PostgreSQL auth from remote hosts edit pg_hba.conf configuration file and add the last line showing below.
Step 4 – Configure phpPgAdmin
Now, your PostgreSQL server is ready for accessing with phpPgAdmin. You may face some issue with the login on phpPgAdmin. To fix this disable the extra login security of phpPgAdmin.
Set extra_login_security value to false.
Step 5 – Access phpPgAdmin
Now phpPgAdmin is available to access from localhost only. To access from local system just type below url in your favorite browser.
Step 6 – Secure phpPgAdmin
Now if you want to access phpPgAdmin web interface from the remote system like your local LAN or remote public network server. We need to make little changes in PostgreSQL Apache configuration file. To do it edit file
Now comment the Require local line and add other lines in configuration file to allow specific ip ranges.
Save you file and restart Apache service using the following command.
To download HP PAVILLION DV9700 RECOVERY DISK, click on the Download button Download Hp Compaq HP Compaq Pavilion dv9700 CTO firewire hardware will need the driver for the Ricoh R5C551 IEEE 1394 controller. Hp pavilion dv9700 recovery disk Hp pavilion dv9700 recovery disk Hallo everyone, The hard drive in my Hp pavilion dv9700 recovery disk dv9700 Notebook recently started to fail. Hp Compaq HP Compaq Pavilion DV9700 human interface hardware will need the driver for the Dell keyboard. Hp pavilion recovery disc free download - HP Pavilion Recovery CD Patch, HP Pavilion Webcam, HP Pavilion Webcam, and many more programs. To download HP PAVILLION DV9700 RECOVERY DISK, click on the Download button. Pavilliob is because the HP Compaq Pavilion dv9700 CTO Windows® operating system will set the computer up with with generic drivers that are designed only to operate at a very basic level.
PostgreSQL is a powerful, highly scalable, open source and cross-platform object-relational database system that runs on Unix-like operating systems including Linux and Windows OS. It is an enterprise level database system which is highly reliable and offers data integrity and correctness to users.
In our earlier article, we’ve explained PostgreSQL 10 installation on CentOS/RHEL and Fedora. In this article, we will explain how to install PostgreSQL 9.6 on Debian, Ubuntu and its derivatives using official PostgreSQL APT repository.
Add PostgreSQL APT Repository
This official PostgreSQL APT repository will combine with your Linux system and offers automatic updates for all supported versions of PostgreSQL on Debian and Ubuntu distributions.
To add the apt repository, first create the file /etc/apt/sources.list.d/pgdg.list, and add a line for the repository as per your distribution.
Debian Server Setup
On Ubuntu Systems
On Debian Systems
Then import the repository signing key, and update the system package lists like this.
Install PostgreSQL Server
How To Install Debian Server
Once you have added the PostgreSQL apt repository in your respective Linux distribution, now install PostgreSQL server and client packages as follows:
How To Install Phppgadmin
Install Postgresql Database Server
Important: Unlike in RHEL/CentOS/Fedora where you have to manually initialize the database system, in Ubuntu/Debian, it is initialized automatically. Therefore simply proceed to start database server as described in the next section.
The PostgreSQL data directory /var/lib/postgresql/9.6/main contains all of the data files for the database.
Start and Enable PostgreSQL Server
With the database server initialized, start PostgreSQL service and enable PostgreSQL service to auto start on system boot like this.
Verify PostgreSQL Installation
After installing PostgreSQL database system on your server, verify its installation by connecting to postgres database server. The PostgreSQL administrator user is named as postgres, type this command to access the user system account.
Verify PostgreSQL Database
To set a password for the postgre database administrator user, use this command:
To secure the postgre user system account, use the password command below.
Set Password for Postgre User
For more information, go to the PostgreSQL Homepage: https://www.postgresql.org/
Lastly, also read through these articles about popular database management systems:
That’s all for now! To share any thoughts with us, make use of the feedback form below. Driver for hp 990c printer. Remember to always stay connected to Tecmint.com for interesting Linux stuff.