![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PG-DB-zero-1024x518.png\")
<\/figure>\n<\/div>\n\n\nClick the checkbox next to PostgreSQL database. Then click the “Save” button.<\/p>\n\n\n\n
Virtualmin will take you to an error page, telling you that PostgreSQL is not installed. On that page (I forgot to get a screenshot) are the instructions to go to the Virtualmin PostgreSQL module. From there Virtualmin will ask you if you want to install PostgreSQL. Yes, yes you do.<\/p>\n\n\n\n
Go ahead and click on the install button.<\/p>\n\n\n\n
When done, you should be looking at the Virtualmin module for the PostgreSQL database server.<\/p>\n\n\n
![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PG-DB-one-1024x591.png\")
<\/figure>\n<\/div>\n\n\nNotice that line at the bottom.<\/p>\n\n\n\n
Go ahead and click on the “click here” in order to install the necessary Perl module.<\/p>\n\n\n\n
Awesome! Now your Virtualmin server is running PostgreSQL and has all the tools for you to avoid the command line (for the most part.)<\/p>\n\n\n\n
Installing phpPgAdmin2<\/span><\/strong><\/p>\n\n\n\n Let’s start by creating a new virtual server.<\/p>\n\n\n Naturally, if Virtualmin is not handling your DNS records then create those first.<\/p>\n\n\n\n Just like adding any other domain name to the system, we need to enter the FQDM and make any other desired changes\/additions.<\/p>\n\n\n\n So those are the only three checkboxes needed. SAVE THE PASSWORD. Go ahead and click the Create Server button.<\/p>\n\n\n\n Now here’s the thing<\/strong>, up until a few months ago \u2013 or until your preferred Linux distribution upgraded to PHP 8 \u2013 we would install phpPgAdmin as one of the Virtualmin included web applications. But the original version of phpPgAdmin does not support PHP 8. Thankfully an updated version is available. And also thankfully, installation is pretty simple.<\/p>\n\n\n\n So let’s install phpPgAdmin 2.<\/p>\n\n\n\n NOTE: I have the original version of phpPgAdmin loaded via the “web app” process (that’s how I discovered it doesn’t work.)<\/p>\n\n\n\n So in order to keep that version alive while testing another I created a subdirectory off the main directory. You don’t need to do that. But my process goes like this:<\/p>\n\n\n\n Create a new directory off of the \/home\/pgphp\/public_html\/ directory.<\/p>\n\n\n\n Then we’re going to download the application directly from Git.<\/p>\n\n\n\n If you don’t want to create the “git” directory, you can go ahead and run the above command directly in the \/home\/pgphp\/public_html directory.<\/p>\n\n\n\n Now we can direct our favorite web browser to: https:\/\/pgphp.imfbsbn.com\/git\/phpPgAdmin\/ (remove “git\/” from the URL as appropriate.)<\/p>\n\n\n If you click on the “Servers” icon near the top right you should get this:<\/p>\n\n\n If you click on the PostgreSQL in the middle there, you will be taken to a login screen:<\/p>\n\n\n The username is the administrative username for the domain in Virtualmin.<\/p>\n\n\n\n The password is the password when you created the domain in Virtualmin.<\/p>\n\n\n\n When you click login you should get something like this (I’ve been creating and dropping databases all day so your screen will look a little different):<\/p>\n\n\n That’s it!<\/p>\n\n\n\n Now you have loaded PostgreSQL and installed an updated version of phpPgAdmin.<\/p>\n\n\n\n In the next post I’ll show you how to connect to the PostgreSQL server from a docker container.<\/p>\n","protected":false},"excerpt":{"rendered":"![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PG-DB-two-1024x609.png\")
<\/figure>\n<\/div>\n\n\n\n
cd \/home\/pgphp\/public_html\nmkdir git\ncd git<\/code><\/pre>\n\n\n\ngit clone https:\/\/github.com\/ReimuHakurei\/phpPgAdmin.git<\/code><\/pre>\n\n\n\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PG-DB-three-1024x309.png\")
<\/figure>\n<\/div>\n\n\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PG-DB-four.png\")
<\/figure>\n<\/div>\n\n\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PG-DB-five.png\")
<\/figure>\n<\/div>\n\n\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PG-DB-six-1024x317.png\")
<\/figure>\n<\/div>\n\n\n