Search Postgresql Archives

Re: Death postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 5/7/23 04:46, Marc Millas wrote:


Le sam. 6 mai 2023 à 21:46, Adrian Klaver <adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>> 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
    <mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>
     >

-- Adrian Klaver
    adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux