MIME-Version: 1.0
References: <web-6314609@arcict.com>
In-Reply-To: <web-6314609@arcict.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Tue, 25 Feb 2025 09:07:40 -0500
Message-ID: <CAKAnmmLzTpJz9AiTtURfNwL0VH5m3TURSkJeUB+sGQ1kZSui1Q@mail.gmail.com>
Subject: Re: Postgres 16 unexpected shutdown
To: postgres@arcict.com
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000134e02062ef7fdf0"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLzTpJz9AiTtURfNwL0VH5m3TURSkJeUB%2BsGQ1kZSui1Q%40mail.gmail.com>
Precedence: bulk

--000000000000134e02062ef7fdf0
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Feb 25, 2025 at 8:51=E2=80=AFAM <postgres@arcict.com> wrote:

> Does this sound familiar anyone? Any ideas what might prompt Postgres to
> stop?
>

Postgres needs full read and write access to its own data directory. If it
doesn't, it will eventually PANIC, as your logs show.

See if you can figure out what else happened around 2025-02-22 08:05:49.427
CET, which seems to be when the problem started according to your logs.

Cheers,
Greg

--
Crunchy Data - https://www.crunchydata.com
Enterprise Postgres Software Products & Tech Support

--000000000000134e02062ef7fdf0
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Tue, Feb 25, 2025 at 8:51=E2=80=AFAM &=
lt;<a href=3D"mailto:postgres@arcict.com">postgres@arcict.com</a>&gt; wrote=
:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex">Does this sound familiar anyone? Any ideas=
 what might prompt Postgres to stop?<br></blockquote><div><br></div><div>Po=
stgres needs full read and write access to its own data directory. If it do=
esn&#39;t, it will eventually PANIC, as your logs show.</div><div><br></div=
><div>See if you can figure out what else happened around 2025-02-22 08:05:=
49.427 CET, which seems to be when the problem started according to your lo=
gs.</div><div><br></div><div>Cheers,</div></div><div dir=3D"ltr" class=3D"g=
mail_signature"><div dir=3D"ltr"><div>Greg</div><div><br></div><div>--</div=
><div>Crunchy Data - <a href=3D"https://www.crunchydata.com" target=3D"_bla=
nk">https://www.crunchydata.com</a></div><div>Enterprise Postgres Software =
Products &amp; Tech Support</div><div><br></div></div></div></div>

--000000000000134e02062ef7fdf0--