Install postgresql for existing VS

SYSTEM INFORMATION
OS type and version Ubuntu Linux 24.04.4
Webmin version 2.621
Usermin version 2.521
Virtualmin version 8.0.1 GPL
Theme version 26.22
Apache version 2.4.58
Package updates All installed packages are up to date

existing VS wants postgresql installed - now i cannot find how to add it to Edit Features just for this VS

also to enable adding phpPgAdmin in Manage Web Apps without error.

That means you should first enable it on the “Features and Plugins” page. Or, if this is a new installation or one using new repositories, follow our tutorial to learn how to complete the setup:

that is pretty clear for new install of Webmin/Virtualmin however this is an old VM with several VS (including one at least production) all otherwise happy.
I could (with some effort) build a new VM - backup the old VS and transfer it to the new one. - but that just feels clumsy.

I have installed postgresql with
apt install postresql
and run virtualmin-config-system --include PostgreSQL

and validate virtual server but no Postgresql appears in Associate and Disassociate Features

Webmin → Refresh Modules?

Do you have the Webmin PostgreSQL module installed as instructed in the documentation?

no change :man_shrugging:

what documentation? that link you posted only implied for new installations. which is why i installed as described above.

the Webmin module is not listed despite the virtualmin-config-system --include PostgreSQL and refresh modules

postgresql is definitely installed - as shown by apt list postresql*

Try the search in Virtualmin “postresql” and see if anything comes up
Should say:
module

install webmin-postgresql ?

1 Like

no change :man_shrugging:
but was that not what virtualmin-config-system --include PostgreSQL was supposed to do?

After the webmin command refresh moduels?

Need to install webmin module then configure Virtualmin command

Did you try that?

When you ran the webmin command what was the output?

What did you try exactly?

Did you run:

apt-get install webmin-postgresql
1 Like

No. config-system is “config” not “install”.

And, your system already has a command for installing packages. We don’t reinvent the wheel for well-solved problems, and installing software is a well-solved problem on all of our supported distros.

i thought that was pretty clear and confirmed by apt list postgresql*

i did expect the additional command given by @Ilia in that link to fix the missing parts taken out of Webmin/Virtualmin - that is to fix the missing “configuration” following install. (it just seems peculiar they were removed) sure i am aware that postgresql is not as popular as mysql/mariadb but it is still (i think) used by many.

pretty much as expected:

PostgreSQL should never be removed during upgrades, because the latest code explicitly prevents that.

And, on a fresh install, if a user chooses PostgreSQL, they’ll see a short message with simple instructions to re-enable it by running a few commands which takes less than a minute.

Ah, yes, that looks right and expected. The Webmin PostgreSQL module is there.

But look, based on your earlier output, I think you missed what the docs say and didn’t install the postgresql-server package. Once you install it, everything should work again.

Oh, dear—no way, I mixed the packages name. For Debian/Ubuntu it should be postgresql-client and for EL postgresql-server!

I will fix docs right now! Thanks for brining this up!

1 Like

No, not according to apt list


list postgresql-server (2)

but are those all required, or in conflict?