Re: Death postgres

On 5/7/23 04:46, Marc Millas wrote:
>
>
> Le sam. 6 mai 2023 à 21:46, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com