Error starting postgres

[gilliard]

I have an error starting postgres 16, alma linux 8

Failed to start postgresql.service: Unit postgresql.service is masked.

[overseer]

Code Select Expand

systemctl is-masked postgresql.service
systemctl unmask postgresql.service
systemctl start postgresql.service
systemctl enable postgresql.service

[gilliard]

Not works


[root@cwp ~]# systemctl is-masked postgresql.service
Unknown operation is-masked.
[root@cwp ~]# systemctl unmask postgresql.service
[root@cwp ~]# systemctl start postgresql.service
Failed to start postgresql.service: Unit postgresql.service is masked.
[root@cwp ~]# systemctl enable postgresql.service
Failed to enable unit: Unit file /usr/lib/systemd/system/postgresql.service is masked.
[root@cwp ~]#

[cyberspace]

Show the output of:

Code Select Expand


ls -l /usr/lib/systemd/system/postgresql.service

cat /usr/lib/systemd/system/postgresql.service

[gilliard]

[root@cwp ~]# ls -l /usr/lib/systemd/system/postgresql.service
-rw-r--r-- 1 root root 0 Oct  9 13:25 /usr/lib/systemd/system/postgresql.service
[root@cwp ~]# ^C
[root@cwp ~]# cat /usr/lib/systemd/system/postgresql.service
[root@cwp ~]# cat /usr/lib/systemd/system/postgresql.service
[root@cwp ~]#

[cyberspace]

Check if the folder:
/usr/lib/systemd/system/
contains other files named like "postgre*.service".

If there is nothing then:

Code Select Expand


rm -f /usr/lib/systemd/system/postgresql.service
systemctl enable postgresql.service
systemctl start postgresql.service


In other case show us the list of other "postgre*.service" files.

[gilliard]

[gilliard]

just one postgresql.service

[cyberspace]

Did you run the following commands ?

Code Select Expand

rm -f /usr/lib/systemd/system/postgresql.service
systemctl enable postgresql.service
systemctl start postgresql.service


[gilliard]

yes...

[root@cwp ~]# rm -f /usr/lib/systemd/system/postgresql.service
[root@cwp ~]# systemctl enable postgresql.service
Failed to enable unit: Unit file postgresql.service does not exist.
[root@cwp ~]# systemctl start postgresql.service
Failed to start postgresql.service: Unit postgresql.service not found.
[root@cwp ~]#

[gilliard]

Now after the remove command, even after reinstalling postgres, it no longer appears to start along with the other services.

[overseer]

Did you install postgres via yum/dnf or via the CWP web admin panel? If via the panel, you would need to call it via the version number you installed. For example, with version 17:

Code Select Expand

systemctl unmask postgresql-17
systemctl start postgresql-17
systemctl enable postgresql-17
(I do not run pgSQL on my servers, so I did a test installation via the CWP GUI to discover this little nuance.)

[gilliard]

Through the cwp panel, however it only shows that the service was not installed, when I try to install it again it does not install