Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pvhOC-0001xg-67 for pgsql-general@arkaria.postgresql.org; Sun, 07 May 2023 16:37:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pvhNB-0007yk-Ut for pgsql-general@arkaria.postgresql.org; Sun, 07 May 2023 16:36:33 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pvhN9-0007st-Ts for pgsql-general@lists.postgresql.org; Sun, 07 May 2023 16:36:33 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pvhN2-0013OH-5U for pgsql-general@lists.postgresql.org; Sun, 07 May 2023 16:36:30 +0000 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.nyi.internal (Postfix) with ESMTP id B9E955C0066; Sun, 7 May 2023 12:36:21 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute1.internal (MEProxy); Sun, 07 May 2023 12:36:21 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to; s=fm2; t= 1683477381; x=1683563781; bh=iB50i1K5wclhBrFXLYCdnI2VRSNYTSScEbv 93l5w9LQ=; b=bwLa1GRq+H9nWwQI2IKOODELjbs1hAsiwYwFlc4StKHGWCD6srS rLC8R6pLOeipxr3igly8myaWUo0YKG/9KrURtzJkkfHz29hjGeeyVcAn0Y5w91dn NTU3RnNoeE8pbuNloLEkTTHulXX7w7t74jcEDzIrOP+tWrk2zjDgmJyjb0/OFdZN uGcnB6VJR3oZK6RGLrI4WDuCTG+IrEoZ4FMxTvOf1bhc6H9XvfgYRe5SO0XKp9SQ FAc5glPZkcBhDPJWELsXn7fP+z+yTKXwRX8+2zxdAzvJ+7HNmS5nv8a0QoA1Dv6P nicGesgHGYx+hGha+DE/g7AwwCMVPJlaaaA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:sender:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1683477381; x=1683563781; bh=iB50i1K5wclhBrFXLYCdnI2VRSNYTSScEbv 93l5w9LQ=; b=CsiGqVxuKRjs4w0y4FBq0EJxI5kkDBR5ZzeGnN2UFb+I3twwF+0 RagJnPha5S3nvxKFXCjHCfJcG+nJ7NMXuycWPXbBzTaWLPRKTssqwOSqca2kVgPh a3miYkxnAjCddw5TyRy8LhWgdSJmYgN5MK8QAWMRFNAbVDzM3cTMh7lFvSJOM78T 3On2lmeoCWzPgneKr0miojQ21acKExwXprb0GlSmpVKYNwxVpJVg9/jYHnvROeB0 doD7luj8GT46yvUvNxxk6xfKAAG9YT3TuD5cTiX1KqaImmrYfQYjyDew0NFrtiX9 Y6VAvF66woIa82S0rZLDRmX4b58jia+yiCA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeefiedguddtvdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefkffggfgfuvfevfhfhjggtgfesthekredttdefjeenucfhrhhomheptegu rhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrd gtohhmqeenucggtffrrghtthgvrhhnpeehudfgtefhtedtheeiveetueektdejvdfhveek gfdufeegveetuddvuedvgeeggeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmh epmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 7 May 2023 12:36:20 -0400 (EDT) Message-ID: Date: Sun, 7 May 2023 09:36:20 -0700 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.10.1 Subject: Re: Death postgres To: Marc Millas Cc: "pgsql-general@lists.postgresql.org" References: <00921f8b-b3a1-b67b-c15d-29c0aaef3a7d@aklaver.com> Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 5/7/23 04:46, Marc Millas wrote: > > > Le sam. 6 mai 2023 à 21:46, Adrian Klaver > 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 ? 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 ? > > > > 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 > > > > > > -- > Adrian Klaver > adrian.klaver@aklaver.com > -- Adrian Klaver adrian.klaver@aklaver.com