Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r0fxW-0076jQ-TG for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 10:38:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1r0fxV-001vKZ-K6 for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 10:38:53 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r0fuP-001qLu-Cc for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 10:35:41 +0000 Received: from mail-lf1-x12e.google.com ([2a00:1450:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0fuM-004Xzv-Nl for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 10:35:40 +0000 Received: by mail-lf1-x12e.google.com with SMTP id 2adb3069b0e04-507a3b8b113so8536850e87.0 for ; Wed, 08 Nov 2023 02:35:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699439737; x=1700044537; darn=lists.postgresql.org; h=in-reply-to:autocrypt:from:references:to:content-language:subject :user-agent:mime-version:date:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Nllpm4+HdXIT8becAbZHWqS4UjlsLt2O6Rivnz03veI=; b=MqnADpcHT0xqyKd6O4lK8vc5IIYJW646V3Dj4M29XCxhgikff6++QdjV/seA8um0T9 rHAiAEa25ky/urEJf5fTwmBW2yleeAA3+5GF5u00ArWmuw94f+f8KxPDMCG9Gt/jNr5X affZ1vw5soF5CKepsIS1iRt0PDdE03agBvtR6VL/X2QIEgaQKtp1QF2FdNOY2dmcdX3g w/rRRGcBpA+szvt3B/cJDn1PFQPL3KmSAtVHlNs3iP30xbN8eOPf902NqmY4gMf8z79l CODhIJMfSU0LqO88+mfC8QztX86kZsWF/NfwSfWH+aw7cNBwbg7zVYUjJcxXFd1oHOvn /5wA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699439737; x=1700044537; h=in-reply-to:autocrypt:from:references:to:content-language:subject :user-agent:mime-version:date:message-id:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=Nllpm4+HdXIT8becAbZHWqS4UjlsLt2O6Rivnz03veI=; b=pi7JEt07z1qcw1LajO4MYTPe8JxTUgf5HSYazZ+o8/jpGy+GYn//kRKi+ct2M81AHA SIQImhfw88t74q/snwnXgK4TB++ciXY2CzmzUihHBYY+r9XQuw5Z2EZX4vbhr+1rlkLg 0SPtXJI8Fd2GjdWAlIDBrkUVHjU9m3d9B2XoJDlxA15fV75DBMK1tyLZ15aIJT2fgZHR thH9H5GuNChx1t0jBLFt2osMMwrQW0vV+fQSjKt/VZvU/jXA4TytD+0/eC8tGolg2tPg LtsbLGARNKEEEU1h/Mz7CqNNm7TqtLkJM7xeGKIWg+OTzPnX2cnXkOr07zbebBHiRalR 3koA== X-Gm-Message-State: AOJu0YzLhTbhyqAMBwkL//9I5fDyqtfUWUHT7yCKfsUn5F6H8zbcoGQ/ VlYCnQX2ZRHeYG0N4JiSPT6zJhSwC1A= X-Google-Smtp-Source: AGHT+IEtuT4iIp3O4pdaFVl+6jXgadSLqQrbk79/WJ15Ck1YwXQIU5nANSKd5azxDS9wKc+MaUZQ8A== X-Received: by 2002:ac2:4849:0:b0:509:44d5:18e5 with SMTP id 9-20020ac24849000000b0050944d518e5mr922958lfy.63.1699439736792; Wed, 08 Nov 2023 02:35:36 -0800 (PST) Received: from [192.168.1.131] (lmontsouris-658-1-67-217.w80-13.abo.wanadoo.fr. [80.13.16.217]) by smtp.gmail.com with ESMTPSA id w7-20020a5d5447000000b0031980294e9fsm4611010wrv.116.2023.11.08.02.35.36 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Nov 2023 02:35:36 -0800 (PST) Content-Type: multipart/alternative; boundary="------------J0RdUrhdB2gZUqaccpM50yX8" Message-ID: Date: Wed, 8 Nov 2023 11:35:35 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Not able to connect specific database Content-Language: fr, en-US To: pgsql-admin@lists.postgresql.org References: From: SAS Autocrypt: addr=sas.postgresql@gmail.com; keydata= xsFNBF1TwC8BEADzdG8ZReoeRLmPqB5Y8GFlu2Rf9RhUqHz7/aK4V07aC2rIN/AtmHd/MiqO dqXJ695qODcFGWwXZHnlgjZy5adgzviG06DTzqtFm0hLDglgBrfjQWKnhaYARRsNltMYL+eh lzDtkqI7mY6pPWQJ0vRwm/2S8HyWVPpM/kAgZdGqmdmh+ks6bNXPXqF+nIcbmWBQKwEjoSQN s36mIU0ZRLJnFJfMsK006TqwzEGIufrQ9OKNmEbKlFU+PHE4ro9lK19yXl/KwMjFavO5t7qF DT7f7fXOoFulxOHFSY6FdKe33mXVAI/6DSRi3QFtXsME/apaFeFluUCoBFmKzoe4Kat6Wr3L GFMI0uCLGXy9VXAKuhcIVqU3AVfJtJmnM4sty/693FcnfpoRjPkgln0XCw1lj5I9JQOwq+R7 IGdPVVzK3QzFHPRAvVF7pha175AeE2UyfdvCIM8fBp2T3Tit6AfkxyM+6vi5T5O3lE5+XecZ RqrTlnUMGxSMb55/mruhqo4mV1CHQRVBPqxwHcuEQcthsepRgvyVpAoYkI6OitUoYsGIbMql A00egksR0V+6zjWpx+G8gDXuPGxL2JNBg1yb/jvygww1A4VrnwqS5nmKiVIOXYgML+U7rn13 gouTaiwjDCNESVcWhxmQoiAofPauMM5itGAFHIbmSkFNmA7IiwARAQABzR5TQVMgPHNhcy5w b3N0Z3Jlc3FsQGdtYWlsLmNvbT7CwZQEEwEKAD4WIQQYFCr7KOpZp+rWJwjdRfi2pUecIQUC XVPALwIbIwUJCWYBgAULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRDdRfi2pUecITcOEAC7 woia7Z8+OhrqtMfkCwGqVzWGw70Er1uDqifUy4RU15zvkQTkpN6UA9nPZFRT+sGiQxEt3gb+ Oj4d/SY24GUPaK2viEG6Cfd/VyjT0KKs2ScR0c1Oka3R1czhHcCTc4oR/WcAUQW1ld28MSAk zYlrGH4P1FsbMpqH+QAC+KKBaIr+/E9DQbH9lgOViI+AYKoLsbz5HCTmUHZ52/njtFDkvZdv ihdx4kJ9Kt7J5mWxWr2f0wIClCqWouDubdRwRxSGLM1a/ivHtEl3rz2eJoLbj1SS//28Nqw0 rPRd10ZNoWoyWpmbcw83JL8lDkMU9RmrN+PJypCBj3nUOKglcPB0dCfsKtaHbH+qtHTfFm9p m/07IrqTW1gOx4z2wOpuiAh4Fdy8SatoNpm6PF3T/2V2ckXlx6GqDhDeLChsinQK6VXLQbYO e3WPTSrREVdFgv97NlzRIY9vGBUd8EOm2YX3nRDkwLbWsqPXjiUFizR1V8EvdzzLLYmUmIyU HhdYecCZIzY9U6XfkXvLfBttrRSpqQ1ZCFdvuZzRN5R9Vy7O4Rxat8RyH/4D3oena43ypfbk ajIlrRi7ElzXJ3YIC4lq/+q12Q+We6a62nUpI8+xNpDV/qzD8jjWcfDSkrml5QWpYoRZrbJo VqUZDRX8mN3V59Nvw1rncXLPsOMnlt3lcc7BTQRdU8AvARAA0xCon2NJFabIdSaBAG8Qy2cJ MfTY6coSgQbx0EFv+P+SJc5x97QaefMr/bgkf/AYfpREi65spov8uEnn6IXWH+u+Y48/U1xU YsakBr2TzFDKhB8RkMuCVo+BJyahm9WlVLFWNJI7GfGeni772aI310peXBlTCDGKop1QZfAp IVSr7jTqNcYED/P6L2S3agiaY1HyQceGwQeJsDywrUaBzTDFg9nXHLzpdrrxUDsVOoB/4A/r lWtCAGnjDnOaaVkpwRjzdGaU+ed+yz13yvKjuDbDy/3EVQKUkbq6JOUuxnEhQyp1MFhTkolV eIS/MuToWikHzlMFAC6YZDilklnLR0GRJcRiYlLenuYwr8z3gdyuDUQ3bcCdaaIUS2M4CqzR 1v/x9JiAIOyoEK8CXtwn9pSb/AGia0PDXyh09gn7WGyNyCrGK7vJyheLbuxIdv2czRxfvoVT woaXi1jVJP72j/e3OyZku/1FBmvP2x/DZSYN2+WESRxL1/WjdvvXQ8mXDrCJkoA8yQQzN5aR 6StToPaJ4b0iIIrpqy0is2RLYccQN+5QhrG1x17TmpmaDgJK5XWSeTssraDntx5GTM/gz87j hot90StLYQxEcPUGij04WV+iy7r+NG1kruRwkK7ZE0H8hUyVeGBgkmBOWrc1p2v8fKI19oTL bKHbAQCgVz0AEQEAAcLBfAQYAQoAJhYhBBgUKvso6lmn6tYnCN1F+LalR5whBQJdU8AvAhsM BQkJZgGAAAoJEN1F+LalR5whRRQQAIkuq64fKnArkyTp/rWtzAn9uQ9cPVqKcol2lLaaUY97 q0ZSefPliz4qpz4CPfQNDTCngSdBgfDLKTuuKLthHe5IgZwUiw1AA+reF7PP+HKGzVv5pqqz uIQJwY8xTnIuyL78JhN4Z4Mihism/iufT2MleKzUNSGr8RjASdvHTwFnAqQN7FevNK4QoCRm i0da9ZuJh7t0LDFtV+IysaOFvE9//gXATvnBZzQ8/TkAPaJ+Y/yWlSlKtekxhWxMxayID0Zi /Om90DYveRVadck6x52jvt1HEu2v5XtXIUmdjM3qaaKrPIRuMrox5vR9K6EouUndSd1/pw2Y 1mILzogeO133yeqVf4aw9740PT51kMowCt2dj5AegYq3hBXYCv51OO0B1pM+pyDwVbgD2iif /rpyRPWZMk0RxmeUfH+wOIztfdtr1iMcJzYD62EuXE4DH4Bi2x0pwqPvFxbzt0V4qq7Nc8jf ThgKrUbfLrfcMrjdqPLnYj+EDfNrVVYqoz4Q/xjPvCiV42N1CLeUyDwm+TYrKyW+ax16XxjK PMnLozdWEiJ8bz3N8FYax6AfzSGGY2/BCpygnmWQAvDodZQNBnFn37aGiarLEZaUCCDsxQrx SK/28CU01eH1Ws5rCS5FsdNbmYQlHHYPVpXdZcA8hbnZ3BirRV88KlDcgrA2eCO8 In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------J0RdUrhdB2gZUqaccpM50yX8 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Le 05/11/2023 à 14:11, Kumar Rajesh a écrit : > Hi team, > > I am not able to connect to one specific database and receiving error " > PANIC:could not open critical system index 2662" as attached in picture . But > I am able to connect other remaining database in samee instance. > > Kindly help I wonder if you are running your database into a container which also contains your data, making data disappear when restarting the container... S. -- Dr Stéphane Schildknecht Contact régional PostgreSQL pour l'Europe francophone +33 617 11 37 42 --------------J0RdUrhdB2gZUqaccpM50yX8 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Le 05/11/2023 à 14:11, Kumar Rajesh a écrit :
Hi team,

I am not able to connect to one specific database and receiving error " PANIC:could not open critical system index 2662" as attached in picture . But I am able to connect other remaining database in samee instance.

Kindly help 

I wonder if you are running your database into a container which also contains your data, making data disappear when restarting the container...

S.

--
Dr Stéphane Schildknecht
Contact régional PostgreSQL pour l'Europe francophone
+33 617 11 37 42

--------------J0RdUrhdB2gZUqaccpM50yX8--