pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgresql - Service hangs....
4+ messages / 3 participants
[nested] [flat]
* Postgresql - Service hangs....
@ 2021-08-12 18:38 Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
2021-08-12 19:42 ` Re: Postgresql - Service hangs.... Dave Cramer <davecramer@postgres.rocks>
2021-08-12 19:50 ` Re: Postgresql - Service hangs.... Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 4+ messages in thread
From: Zhéxué M. @Study @ 2021-08-12 18:38 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
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"
Attachments:
signature.asc (application/pgp-signature, 884B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql - Service hangs....
2021-08-12 18:38 Postgresql - Service hangs.... Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
@ 2021-08-12 19:42 ` Dave Cramer <davecramer@postgres.rocks>
1 sibling, 0 replies; 4+ messages in thread
From: Dave Cramer @ 2021-08-12 19:42 UTC (permalink / raw)
To: Zhéxué M. @Study <study@xn--zhxu-cpac.eu>; +Cc: pgsql-bugs@lists.postgresql.org
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 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
>
Error messages from the logfile would be helpful here
Dave
>
>
> Matthias
>
> -------------------------------------------------------------------------
> *The diversity of human dignity*
> "Jede Handlung, die mit gutem Willen und Wirksamkeit
> ausgeführt wird, ist eine *mystische Handlung*"
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql - Service hangs....
2021-08-12 18:38 Postgresql - Service hangs.... Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
@ 2021-08-12 19:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-08-16 08:40 ` Re: Postgresql - Service hangs.... Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
1 sibling, 1 reply; 4+ messages in thread
From: Tom Lane @ 2021-08-12 19:50 UTC (permalink / raw)
To: Zhéxué M. @Study <study@xn--zhxu-cpac.eu>; +Cc: pgsql-bugs@lists.postgresql.org
"=?utf-8?Q?Zh=C3=A9xu=C3=A9_M._=40Study?=" <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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Postgresql - Service hangs....
2021-08-12 18:38 Postgresql - Service hangs.... Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
2021-08-12 19:50 ` Re: Postgresql - Service hangs.... Tom Lane <tgl@sss.pgh.pa.us>
@ 2021-08-16 08:40 ` Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
0 siblings, 0 replies; 4+ messages in thread
From: Zhéxué M. @Study @ 2021-08-16 08:40 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-bugs@lists.postgresql.org
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 (mailto:tgl@sss.pgh.pa.us)> wrote:
> "=?utf-8?Q?Zh=C3=A9xu=C3=A9_M._=40Study?=" <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
>
Attachments:
signature.asc (application/pgp-signature, 884B) download
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2021-08-16 08:40 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-08-12 18:38 Postgresql - Service hangs.... Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
2021-08-12 19:42 ` Dave Cramer <davecramer@postgres.rocks>
2021-08-12 19:50 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-08-16 08:40 ` Zhéxué M. @Study <study@xn--zhxu-cpac.eu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox