Thread: Postgresql - Service hangs....
Hello together,
i have a small question about automatic start from Postgresql on LINUX.
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.
But if i try "systemctl start postgresql" it start the server, but it hangs -> it doesn't come back to the shell. After "Control C" the server is running....
So, how can i solve this problem?
best regards
Matthias
-------------------------------------------------------------------------
The diversity of human dignity
"Jede Handlung, die mit gutem Willen und Wirksamkeit
ausgeführt wird, ist eine mystische Handlung"
Attachment
On Thu, 12 Aug 2021 at 15:13, Zhéxué M. @Study <study@zhéxué.eu> wrote:
Hello together,i have a small question about automatic start from Postgresql on LINUX.Today, i installed the Release 14 beta 3 on my System and with this version, the Servicedon't want to start automatic if the system is coming up.But if i try "systemctl start postgresql" it start the server, but it hangs -> it doesn't come back to the shell. After "Control C" the server is running....So, how can i solve this problem?best regards
Error messages from the logfile would be helpful here
Dave
Matthias-------------------------------------------------------------------------The diversity of human dignity"Jede Handlung, die mit gutem Willen und Wirksamkeitausgeführt wird, ist eine mystische Handlung"
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@sss.pgh.pa.us> wrote:"Zhéxué M. @Study" <study@xn--zhxu-cpac.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