Re: Postgresql - Service hangs....

Hello all,
please excuse the late reply.

to the 1st question: Error message
NO, no error message appears in the LOG regarding this.
It looks like the script is waiting for something, but according to "ps -ef" the database server is there and running. According to pgAdmin also....

To question 2: Installation
I installed the "update" via apt upgrade and it also ran through without errors. However, the subsequent steps regarding conversion of the DB to the new release were not purposeful, but the database "main" was subsequently defective and he also "simply" deleted the data structure / storage that I created (ext. Volume, etc.)....

I found out over the weekend that something was bothering him regarding "huge_pages" in connection with the buffersize settings, etc.

On the question of where the script came from:
Well, I use the script to start on postgresql, which is installed together with the package. I don't change anything there either, I just analyze it if something doesn't work.

What can I do now? Because, as I said before, the server does not start via "systemctl start...." when the system is rebooted. After that I can start the script, but have to cancel it with Ctrl-C, so I can continue working on this session.

Best regards

Matthias
-------------------------------------------------------------------------
The diversity of human dignity
"Jede Handlung, die mit gutem Willen und Wirksamkeit
ausgeführt wird, ist eine mystische Handlung"

> On Donnerstag, Aug. 12, 2021 at 9:50 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us (mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us)> wrote:
> "=?utf-8?Q?Zh=C3=A9xu=C3=A9_M._=40Study?=" <study(at)xn--zhxu-cpac(dot)eu> writes:
> > Today, i installed the Release 14 beta 3 on my System and with this version, the Service
> > don't want to start automatic if the system is coming up.
>
> How did you install it exactly --- from source? somebody's packaging
> (whose?) Where did you get the systemd unit file for it from?
>
> What this sounds like is the server isn't acting the way the systemd
> unit file expects it to, thus I suspect a mismatch.
>
> If you built from source and tried to use an existing unit file,
> the most likely bet is you forgot to configure --with-systemd.
>
> regards, tom lane
>