Debian – How to install PhpPgAdmin

Mimetypes-text-x-sql-iconAlways handy with a web based database tool. Here is how to install and access PhpPgAdmin on a Debian variant.

First to install the package.
apt-get install phppgadmin

Now your web panel is installed. Then you need to access it. If you are on a different computer than you install the PhpPgAdmin you will need to edit the config file to be able to access it. Here is what you need to do.

Comment out the line 127.0.0.0/255.0.0.0 allow from :: 1/128
And uncomment the line allow from all

Now you need to set a password for the root user. PostgreeSQL call the root user for postgres.
So no need to either su or sudo the postgres user.
sudo -u postgres psql (or su postgres, then start psql)

Inside the postgree database type this to set a password
\password
Enter the password twice as usual
\q
To quit.

Now you have set a password for the root user and made it accessible from everywhere.
I have installed it on 192.168.1.86, so I would need to type into my web browser
192.168.1.86/phppgadmin

Now use the postgres as user, and enter with your password. You might want to consider to restrict access to your database once everything is set up.

That´s it really.

Happy databasing!

About Author

Related Posts

php8 gd

PHP8 gd Activate after installation

PHP8 GD activate after installation. GD doesn’t get activated by default. Not even a reboot after installation will activate it. So how do we do it? In…

Debian 12: linux-image-6.1.0-10amd64

Troubleshooting dependency issues in Debian 12: Resolving linux-image-6.1.0-10amd64 package dependency problems. If you installed the Debian 12 from the live image the issue is the raspi-firmware. Even…

4 Best Free Nas Software That Is Open Source

Free NAS software or operating systems that are free to use and will turn a computer into a NAS more advanced than the dedicated boxes sold. What…

Raspbian default password

Raspbian default password

Looking for the Raspbian default password? It is the most essential username and password that you will need for your raspberry. At least if you are running…

OpenMediaVault default password

OpenMediaVault default password

OpenMediaVault default password is printed in the documentation. I did not see it the first time I installed it either. So I had to do some detective…

Debian change dns

Debian change DNS settings to a new DNS

Debian change DNS settings for speed improvement or privacy. It is really easy to do. So let us see how it’s done and get to it. The…

Leave a Reply