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 1pvNrj-0007js-9i for pgsql-general@arkaria.postgresql.org; Sat, 06 May 2023 19:46:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pvNrg-0000o5-PF for pgsql-general@arkaria.postgresql.org; Sat, 06 May 2023 19:46:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pvNrf-0000i9-7L for pgsql-general@lists.postgresql.org; Sat, 06 May 2023 19:46:44 +0000 Received: from wout1-smtp.messagingengine.com ([64.147.123.24]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1pvNrV-000zjg-BB for pgsql-general@lists.postgresql.org; Sat, 06 May 2023 19:46:42 +0000 Received: from compute5.internal (compute5.nyi.internal [10.202.2.45]) by mailout.west.internal (Postfix) with ESMTP id AE8B3320091B; Sat, 6 May 2023 15:46:29 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute5.internal (MEProxy); Sat, 06 May 2023 15:46:29 -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= 1683402389; x=1683488789; bh=+FTFTfclOpgqH+jtBWGfFkQDlJGN6s7+20w QjPwlDkE=; b=b+UEZ1Zp+6K/MsYa9x49+Sypws2S7RYHn6boit/doMygoHFcnjW cH/tNe32n3DTAx2vBbPNEylM9AnKrUZK7Gzz53P3PwnEYm4v4Ma8rJA2+0dM4nWi hKGzOUj2CYm5lJwLxwbIoBjQQTsfGlIv92yTWsjfFkzu0YTyR/GTKc/+sL+y0pge ZoHLmcdBbEj9QzAK+JLjtUQkClrDqZR5YAhU18j7yFJwY2C2M77zvxLulgw2gaff d5nilK5R/ko9JtOy3RlYbqaQSSvAyd0DFciP6OPkoDVgQ9jpxkLE9+1bQm5cywgV TIE5MpwvCf76XmxvoNegDu0MPf8HlIi5OMQ== 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= 1683402389; x=1683488789; bh=+FTFTfclOpgqH+jtBWGfFkQDlJGN6s7+20w QjPwlDkE=; b=csT/Jjq+bcTR8FKv/aKfVrxqowcqzdaxaXyOUr07/QHBptfsmEl Vv856EmykZ9hRoepkzEZcE5jqawZEhUqB+AQhxJ2Az7m4poqkpkzNpfoxWhMKJhF J1qBLIC1JYzdqF0NxBSz4I4ui/oOW7s27FyjRlDCK8FJH8Mi/xRFMg1NBpFCNjyA T3crJWSJBo0SL/6jS83Y3EPFNYWNE9+dmATtLy/6FgDFVSdWmgwvaUuWitoSaHnd envZmdVFciNVICUp82xxC9DzAEdiTcPmMTkH9VFucy0h6dzIVLnnXNKRNkHd3S4x ZMFCoy4jiFUVyPB9Yip/G2OlWcZUr/KsumA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvhedrfeefgedguddulecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfgh necuuegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmd enucfjughrpefkffggfgfuvfevfhfhjggtgfesthejredttdefjeenucfhrhhomheptegu rhhirghnucfmlhgrvhgvrhcuoegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrd gtohhmqeenucggtffrrghtthgvrhhnpeejgedthfeuhfetgfffvdehudelteegjeduveff keetgeejieehueduleelgfffffenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmh epmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghrsegrkhhlrghvvghrrdgtohhm X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sat, 6 May 2023 15:46:28 -0400 (EDT) Message-ID: Date: Sat, 6 May 2023 12:46:27 -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: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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 ? > > 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