![]() To fix this disable the extra login security of phpPgAdmin. You may face some issue with the login on phpPgAdmin. Now, your PostgreSQL server is ready for accessing with phpPgAdmin. # Add extra configuration host all all 192.168.1.0/24 md5 Step 4 – Configure phpPgAdmin $ sudo vi /var/lib/pgsql/data/pg_hba.conf $ sud vi /var/lib/pgsql/data/nfĪfter this enable PostgreSQL auth from remote hosts edit pg_hba.conf configuration file and add the last line showing below. First this to access PostgreSQL on all interfaces, update the following settings under nf file. Now, you may need to make some changes in your PostgreSQL server to access via phpPgAdmin. Use the following command to install phpPgAdmin. Now phpPgAdmin packages are also available under default Ubuntu repositories. We are assuming here that you already have PostgreSQL server running on your Ubuntu system. $ sudo apt-get install php-pgsql # Use package name as per php verison Step 2 – Install phpPgAdmin After installing PHP and Apache install the PHP module for postgresql. If you don’t have PHP installed, Use tutorial Install PHP7 or Install PHP5 on system. Also, you will need php-pgsql libraries installed on the system. PhpPgAdmin required PHP and Apache2 must be installed on your system. 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. This article will help you to install phpPgAdmin web interface to manage PostgreSQL server on Ubuntu Systems. It also provides an option for database backup and restores from the web interface. Also, we can execute PL/pgSQL and other stored procedures. ![]() We can easily create new databases, tables in the database, users, stored procedures etc. ![]() PhpPgAdmin is an web interface for accessing and managing PostgreSQL databases in a very easy way.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |