Photon OS 5 and PostgreSQL 15 installation is not complete

[jakekn354]

Describe the bug

If you install PostgreSQL 15 from default repository systemctl scripts are not available.

Reproduction steps

1. Install Photon OS 5 GA OVA
2. Install PostgreSQL 15 from default repository
3. Try enable service with systemctl command
   ...

Expected behavior

There is no systemctl scripts for postgresql

Additional context

No response

[dcasota]

Hi @jakekn354 ,

Well, for security purposes, the Photon OS postgresql packages do not configure any default instance.
This isn't the same like e.g. in Debian with a systemd unit generator.

In a very easy way, create an instance by specifying a local user, data directory, your postgres configuration and your /etc/systemd/system/postgresql.service file, see docs.

Postgresql version migration is documented here.

For remote configuration, monitoring, etc., have a look to pmd-nextgen overview.

Keep in mind security hardening & database maintenance tasks, see vcsa example files.

Hope this helps.
Daniel

[jakekn354]

Thanks. That explains, we will try manual configuration

[sshedi]

I'm working on it.

[sshedi]

This is done on Ph4 and above branches. Please close this issue.

[dcasota]

@sshedi fdbd05b is out awhile, but Postgresql14 - 14.11.2 - is missing on https://packages.vmware.com/photon/5.0/photon_updates_5.0_x86_64/x86_64/.
In addition, packages list in https://packages.vmware.com/photon/5.0/photon_5.0_x86_64/x86_64/ stops at libpcap-1.10.1-1.ph5.x86_64.rpm
?