Install postgresql for existing VS

[Ilia]

@Stegan

but are those all required, or in conflict?

The command to check to check whether a package installed on the Debian system would be:

dpkg -l postgresql* | grep ii

Or adding the --installed flag to your apt list command works too. And no, you don’t need to install all of them.

[Stegan]

@Ilia

on the Debian system would be:

dpkg -l postgresql* | grep ii

hmm, that’s interesting, not quite the same.

now to try again to install postresql-server but should it be -16 or -18 and should the others be removed/cleaned out?

I am really tempted to use my weekend on the alternative route of a new VM.

[Ilia]

@Stegan

now to try again to install postresql-server but should it be -16 or -18 and should the others be removed/cleaned out?

I cannot give you specific recommendations about which version or packages should be used in your particular case. This is not a decision Virtualmin can make for you.

However, if I were in your position and needed to use PostgreSQL, I would let the system decide which version to install by default and simply run apt-get install postgresql postgresql-client instead of overcomplicating things.

[CTS]

what is the version info?
psql -V or psql --version

I believe 16 is default

[Stegan]

@Ilia

run apt-get install postgresql postgresql-client instead of overcomplicating things.

that seemed like progress

at least as far as “Associate and Disassociate Features” is now listing “PostgreSQL” and can be ticked.

but:

I don’t ever remember having to do this.

[Ilia]

@Stegan

I don’t ever remember having to do this.

Did you run virtualmin-config-system --include PostgreSQL after installing those PostgreSQL packages?

[Stegan]

@CTS

psql --version

18 it seems

[CTS]

ok 18 it is

[CTS]

Did you go to the postgresql module?
Usually it says to initialize it or something like that
I’m on Rocky Linux though so not sure about Debian based

[Stegan]

@Ilia

Did you run virtualmin-config-system --include PostgreSQL after installing those PostgreSQL packages?

re-run, but now shows a perl bug

[Ilia]

It seems like something else is going on in this screenshot:

Not sure why the space between SQL and in was edited, but it seems to have an extra character there. Just make sure you actually run:

virtualmin-config-system --include PostgreSQL

[Stegan]

run again - all appears ok - with a nice green tick

i think i caught a typo/space in the screenshot

at least i get the option of a postgresql database now

but still insisting no database and refusing to create one just as before

surely the owner (given as the owner of the VS)
and the role (also given as the owner of the VS)
should have been created without all this?

[Stegan]

persistent little trying to install phpPgAdmin

it might help if i knew what postgresql database it is expecting and/or why one was not created. or at least a helpful link back to where to create one.

[CTS]

Maybe this can help?

https://forum.virtualmin.com/t/phppgadmin-script-fail/119055/3

[Stegan]

@Joe

I’ll also point out there is a PostgreSQL management GUI in Webmin, which the root user (and any domain owner, assuming you grant them access) can use without having to install any extra software.

ha! but as shown above it no longer seems to do it anymore or i would not be having all this trouble.

@Stegan

surely the owner (given as the owner of the VS)
and the role (also given as the owner of the VS)
should have been created without all this?

the database is obviously not being created.
i am creating the database as root and have also tried as theowner of the domain - makes no difference the database is not crreated.

i have wasted all weekend on this and the client will expect it running tomorrow - so a transfer to a new VM is getting to be the only solution

[CTS]

I’m sure someone with more experience with postgres in Virtualmin will help out

[Stegan]

@CTS

I’m sure someone with more experience with postgres in Virtualmin will help out

thanks, but i fear it will be too late, I think it is really down to the changes in how Webmin/Virtualmin works with postgresql not postgresql itself.
i can work with psql to create a role and a database but that should not be required - they should be automatic and i think they used to be.

[Ilia]

@Stegan

I think it is really down to the changes in how Webmin/Virtualmin works with postgresql not postgresql itself.

Nothing has changed in how Webmin/Virtualmin integrates with PostgreSQL. To confirm this, I performed a clean installation on Ubuntu 24.04, and PostgreSQL installed and ran without any issues.

However, I noticed that running the APT command on my Ubuntu system doesn’t list any development versions of PostgreSQL you listed earlier—only the postgresql-16-* packages are available.

[Stegan]

@Stegan

i have wasted all weekend on this and the client will expect it running tomorrow - so a transfer to a new VM is getting to be the only solution

took the nuclear route with a new VM, changed the external DNS, added the VS, loaded from backup. selected both MariaDb and the now postgesqlDB and the Web App loaded without a hitch. contacted the client this afternoon and I don’t think he realised the grief he has caused.

sometimes it is just easier to and give up!

[CTS]

Greater question is why?
was there customizations done to the Virualmin/Webmin install?
Custom PostreSQL packages installed?
I have never had problems installing PostgreSQL and using it in Virtualmin