Running multiple instances of the same application is not very efficient. Further, backing up databases inside containers is\u2026 Well\u2026 Complicated.<\/p>\n\n\n\n
Backing up databases tied to Virtualmin domains is incredibly simple and straightforward.<\/p>\n\n\n\n
So let’s have at it.<\/p>\n\n\n\n
Before going any further this tutorial assumes:<\/p>\n\n\n\n
- \n
- Virtualmin<\/a> has been correctly loaded on your system,<\/li>\n\n\n\n
- Docker<\/a> has been installed on your system,<\/li>\n\n\n\n
- Portainer<\/a> has been installed on your system, and<\/li>\n\n\n\n
- PostgreSQL<\/a> and its Virtualmin module have been properly installed.<\/li>\n<\/ul>\n\n\n\n
If anyone is curious I’m working on the server hosted at Server Cheap (that’s not an endorsement, I have zero relationship with those people.)<\/p>\n\n\n\n
First \u2013 We Add the Domain to Virtualmin<\/strong><\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-one-1024x604.png\")
<\/figure>\n<\/div>\n\n\nHere we are adding the domain name “pgadmin.imfbsbn.com”.<\/p>\n\n\n\n
Because the administration username is going to be set automatically it’s going to be “pgadmin”.<\/p>\n\n\n\n
In terms of features, we only need DNS, Apache, and PostgresSQL. Those are the only boxes that need to be checked.<\/p>\n\n\n\n
Go ahead and create the server.<\/p>\n\n\n\n
Second \u2013 We Create the Reverse Proxy To the Container<\/strong><\/p>\n\n\n\n
Now go to Website Configuration \u2013 \u2013 Edit Proxy Website and make the changes necessary to set up the reverse proxy to the container.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-two-1024x358.png\")
<\/figure>\n<\/div>\n\n\nThird \u2013 We get Our Application Running in the Container<\/strong><\/p>\n\n\n\n
Next were going to log into Portainer and create a new stack.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-three.png\")
<\/figure>\n<\/div>\n\n\nHere’s the code you need to enter in the stack:<\/p>\n\n\n\n
services: \n pgadmin:\n image: dpage\/pgadmin4:latest\n restart: unless-stopped\n environment:\n PGADMIN_DEFAULT_EMAIL: pgadmin@bblaze.xyz\n PGADMIN_DEFAULT_PASSWORD: fshbhhj3fUFZbUIV\n ports:\n - \"5050:80\"\n extra_hosts:\n - \"host.docker.internal:host-gateway\"<\/code><\/pre>\n\n\n\nThen go ahead and deploy the stack.<\/p>\n\n\n\n
Once the container has loaded and is running you should be able to visit the domain name and see the login page for PG Admin 4:<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-four-1024x503.png\")
<\/figure>\n<\/div>\n\n\nAnd if you enter the credentials from the stack you should be allowed to login:<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-five-1024x469.png\")
<\/figure>\n<\/div>\n\n\nFourth \u2013 Configure PostgresSQL To Allow Host Connections<\/strong><\/p>\n\n\n\n
We have to make a few changes to a couple of files before the PostgresSQL server will allow our docker container to connect.<\/p>\n\n\n\n
Let’s do the easiest first.<\/p>\n\n\n\n
On our Debian system, we can use the Virtualmin file manager to navigate to \/etc\/postgresql\/15\/main\u2026<\/p>\n\n\n\n
NOTE: Because our domain is set up as a proxy, Virtualmin might not show us the file manager has a menu option. To use the file manager you may have to select an alternate domain hosted on the system or use Webmin.<\/p>\n\n\n\n
Now you can right-click on the file postgresql.conf and then click edit from the pop-up window.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-six.png\")
<\/figure>\n<\/div>\n\n\nVirtualmin will pop open a window where you can edit this file.<\/p>\n\n\n\n
Scroll down a couple of screens until you get to CONNECTIONS AND AUTHENTICATION.<\/p>\n\n\n\n
In that section you will need to remove the # in front of listen_addresses.<\/p>\n\n\n\n
You also need to delete ‘localhost’ and put in ‘*’ as shown below.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-seven.png\")
<\/figure>\n<\/div>\n\n\nSave the file by clicking on the diskette at the top right of the pop-up window.<\/p>\n\n\n\n
Now comes the tricky part.<\/p>\n\n\n\n
Before continuing, we need to gather and confirm a little bit of information.<\/p>\n\n\n\n
First we need to find out the IP address of our docker container running PGAdmin4. Thankfully, no commands are necessary. Portainer will simply show us the IP on the container page.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-eight-1024x269.png\")
<\/figure>\n<\/div>\n\n\nWe can see that our PGAdmin container has an IP address of 172.19.0.2. We’re gonna need to know that in just a little bit.<\/p>\n\n\n\n
Next we are going to confirm \u2013 in Virtualmin \u2013 our username and database name for Postgres.<\/p>\n\n\n\n
For this we need to navigate over to the “Webmin” side of Virtualmin. To do that either press Alt-W or click on the Webmin tab on the top left side of the menu.<\/p>\n\n\n\n
From there navigate to Servers \u2013 \u2013 Postgres Database Server:<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-nine-1024x555.png\")
<\/figure>\n<\/div>\n\n\nOn this screen (shown above) we need to confirm that Virtualmin has created a database called “pgadmin”.<\/p>\n\n\n\n
Now we are ready to click on the PostgreSQL Users button.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-10.png\")
<\/figure>\n<\/div>\n\n\nOn the users page we want to confirm that Virtualmin has created a user called “pgadmin”.<\/p>\n\n\n\n
Go ahead and click on the user pgadmin.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-11-1024x336.png\")
<\/figure>\n<\/div>\n\n\nHere you want to ABSOLUTELY CHANGE THE PASSWORD and write it down. I’m not exactly sure what is going on here behind-the-scenes. But it appears that Postgres users are not initially assigned a password when created. So setting a password here is absolutely essential for continuing.<\/p>\n\n\n\n
Now that we have confirmed our IP address, database name, username, and password, we are ready to proceed to the next step.<\/p>\n\n\n\n
Click the blue button that says Return to Database List.<\/p>\n\n\n\n
Click the Virtualmin button “Allowed Hosts”.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-11b.png\")
<\/figure>\n<\/div>\n\n\nAt the bottom left, click on that white button that reads Edit Config File.<\/p>\n\n\n\n
Scroll down to the end of that file. You want to make it look something like this:<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-12.png\")
<\/figure>\n<\/div>\n\n\nThe line you want to add the look like this:<\/p>\n\n\n\n
host pgadmin pgadmin 172.19.0.2\/32 scram-sha-256<\/code><\/pre>\n\n\n\nThis is telling PostgeSQL to allow access to the pgadmin database by the pgadmin user from IP 172.19.0.2 using sha-256 password encryption.<\/p>\n\n\n\n
NOTE: if you get stuck you may want to test with lines #98\/99 which I have commented out above.<\/p>\n\n\n\n
After you have made the changes, save the file.<\/p>\n\n\n\n
Again, click the blue “Return to Database List” button.<\/p>\n\n\n\n
Restart the PostgreSQL server by using the “Stop” and “Start” buttons within Virtualmin.<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-13.png\")
<\/figure>\n<\/div>\n\n\nThen\u2026<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-14.png\")
<\/figure>\n<\/div>\n\n\nReturn to the browser tab where you have PG Admin 4 open.<\/p>\n\n\n\n
Click on the button that says “Add New Server”<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-15.png\")
<\/figure>\n<\/div>\n\n\nEnter whatever you want for the name.<\/p>\n\n\n\n
Then click over to the connections tab:<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-16.png\")
<\/figure>\n<\/div>\n\n\nEnter data into the fields like above.<\/p>\n\n\n\n
If everything worked as it should, you should see something like this:<\/p>\n\n\n
\n![\"\"](\"https:\/\/jb03.com\/wp-content\/uploads\/2025\/02\/PGC-17-1024x339.png\")
<\/figure>\n<\/div>\n\n\nCongratulations!<\/p>\n\n\n\n
You just connected a docker container to the PostgreSQL server hosted natively on the OS.<\/p>\n","protected":false},"excerpt":{"rendered":"
- Docker<\/a> has been installed on your system,<\/li>\n\n\n\n