Re: Death postgres

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Death postgres
Date: 2023-05-06 19:46:27
Message-ID: f3cd34ff-046a-828b-ff97-6408a1cb516b@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

>
>
> 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>
>

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2023-05-06 21:13:20 Re: "PANIC: could not open critical system index 2662" - twice
Previous Message Gabriel Furstenheim Milerud 2023-05-06 18:46:19 Check that numeric is zero