From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Marc Millas <marc.millas@mokadb.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Death postgres
Date: Sun, 7 May 2023 09:36:20 -0700
Message-ID: <c41b7d32-ab44-8398-357c-a76e58bc9d11@aklaver.com> (raw)
In-Reply-To: <CADX_1aYGbAY6SPxATizTMpBkhgDLYav_CdWN9KdipSmZpg+oOA@mail.gmail.com>
References: <CADX_1aa=7vXKhsiHQA97yT1+WBcKM4PSfzvxrszC7xqnujZVVQ@mail.gmail.com>
<d5b62160-c61d-8b93-2ac2-e720b0ffc3e7@aklaver.com>
<CADX_1aY1KtOYZaOB8F4KdHgDh7E1bbMkmNciOHc8xt2Y3=hYWg@mail.gmail.com>
<00921f8b-b3a1-b67b-c15d-29c0aaef3a7d@aklaver.com>
<CADX_1aa94hbNqVW7svULh49UK0jZkPk8HbBfok-v7rmxZvkFSQ@mail.gmail.com>
<f3cd34ff-046a-828b-ff97-6408a1cb516b@aklaver.com>
<CADX_1aYGbAY6SPxATizTMpBkhgDLYav_CdWN9KdipSmZpg+oOA@mail.gmail.com>
On 5/7/23 04:46, Marc Millas wrote:
>
>
> Le sam. 6 mai 2023 à 21:46, Adrian Klaver <adrian.klaver@aklaver.com
> <mailto:adrian.klaver@aklaver.com>> a écrit :
>
> On 5/6/23 10:13, Marc Millas wrote:
> >
> >
>
> > When you restarted the server where there any warnings shown?
> >
> > Sadly, I cannot. Will be done next tuesday.
>
> Cannot do what:
>
> 1) Get to the log to see if there are warnings?
>
> 2) Restart the server?
>
> Your original post said the server crashed.
>
> If that was the case how can you do any of the below without
> restarting it?
> Infrastructure is managed by another company. The db is within a
> container.
>
> So.. If I run a pg_ctl restart, the container... Vanished.
> So for each main thing, I must ask... By mail..
1) The question remains, if the container crashes when you run pg_ctl
how can you do?:
Using psql can you \d <the_table>?
Yes, and no pb to check pg_statistic,...
Can you select from any other table in the database?
Yes
2) You need to provide a more detailed explanation of the setup that the
Postgres server is running in.
a) The host OS and version.
b) The container specifications.
1) What container software and version?
2) 'Hardware' specifications.
c) Some indication of the size of the data sets you are querying. Also
the query you used.
>
> >
> >
> > Using psql can you \d <the_table>?
> >
> > Yes, and no pb to check pg_statistic,...
> >
> >
> > Can you select from any other table in the database?
> >
> > Yes
> >
> >
> >
> >
> >
> >
> > --
> > Adrian Klaver
> > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
> >
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: adrian.klaver@aklaver.com, marc.millas@mokadb.com
Subject: Re: Death postgres
In-Reply-To: <c41b7d32-ab44-8398-357c-a76e58bc9d11@aklaver.com>
References: <CADX_1aa=7vXKhsiHQA97yT1+WBcKM4PSfzvxrszC7xqnujZVVQ@mail.gmail.com> <d5b62160-c61d-8b93-2ac2-e720b0ffc3e7@aklaver.com> <CADX_1aY1KtOYZaOB8F4KdHgDh7E1bbMkmNciOHc8xt2Y3=hYWg@mail.gmail.com> <00921f8b-b3a1-b67b-c15d-29c0aaef3a7d@aklaver.com> <CADX_1aa94hbNqVW7svULh49UK0jZkPk8HbBfok-v7rmxZvkFSQ@mail.gmail.com> <f3cd34ff-046a-828b-ff97-6408a1cb516b@aklaver.com> <CADX_1aYGbAY6SPxATizTMpBkhgDLYav_CdWN9KdipSmZpg+oOA@mail.gmail.com> <c41b7d32-ab44-8398-357c-a76e58bc9d11@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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