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 1r0jed-007UEN-1O for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 14:35:39 +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 1r0jeb-003zmj-Fa for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 14:35:37 +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 1r0jeb-003zmb-02 for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 14:35:37 +0000 Received: from mail-lj1-x22d.google.com ([2a00:1450:4864:20::22d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0jeY-004ZtH-8N for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 14:35:35 +0000 Received: by mail-lj1-x22d.google.com with SMTP id 38308e7fff4ca-2c6b30aca06so91604591fa.3 for ; Wed, 08 Nov 2023 06:35:34 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699454133; x=1700058933; darn=lists.postgresql.org; h=in-reply-to:autocrypt:from:references:cc:to:content-language :subject:user-agent:mime-version:date:message-id:from:to:cc:subject :date:message-id:reply-to; bh=M/LY4HaJy8Pr2TuUahMnV1Nw/45f/pZUP2KhaAv/m7A=; b=GYZaJS5mYiQkidJRDwKHhMI6POdi2CU86FNwoqxi7LTTvGxgNzgyl5VEFr4EY6ZwR9 G3Y53PMFef2Qc5l6GzLLS3cwqflZqFI26+Om3MpJW6ME+1KOv9dbPRiHra7pbJi0HOcV qIXzji2ILnOetUIj0DXvlEbV0syFkyapmMlPbj/jFTYEkUVuJWz3ECzFQEWeONM0f7s8 7ItlRF9uq2Qeq9ET8mUiyzc34KYAhY9ZDRWuKTfBBvC3ak4a6Fx7uar1rrAF7DwKeeXF mEN8jefvGk4z/+ZokE2zSyrFBkaYJipmU+4FZ+cqmMd6l1BSSSI67NUcUVx0DvFxIaZ7 ZaXQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699454133; x=1700058933; h=in-reply-to:autocrypt:from:references:cc: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=M/LY4HaJy8Pr2TuUahMnV1Nw/45f/pZUP2KhaAv/m7A=; b=ipsOQHoSOZC7h4/LuueqzgsBBNIBd0BJ5nfDeWrG1j3RRQ2k2pGlf/en3paW4RcRNr zvQ0+j1zNwCHPpCAV40DcBLbAw2OejeqYhd0YdFm3bUBmPMgUSSRzI6PYg+gyYAeRVYY umMXA2K4FlZLGGSAQ7gHAIHK9Fp2EiGCFMM+q5+hOkcBbLJyFs8CmMjAMe9zD9BaRQ04 dzfb6kBlIoaQ7VT1mWY+/LaAA4O31fVPeFsODXuIT1B3EQfXwBI6Tb3nMprcHWHbrYAX BshKKQfn6w8h+p+J3OBxLJi19PDgnWq6gwJhogftcUxP+akG7fo3g2cAH2sxcY5d5KJC lKjw== X-Gm-Message-State: AOJu0YxHumHlUYilLjvrB9Av6mu2aV4Oj22k42tq/3ncjZEW5CvV68tq 7msDMMTSU6ghglrBDxRa5Fo= X-Google-Smtp-Source: AGHT+IEEX6BdAMfPjFDEgYrmuAVtLGcOHT3tx+ES0WYKZJ9Oem6z7JMeXhy2FaCJTxRqJGrtni/w5A== X-Received: by 2002:a2e:bd02:0:b0:2c5:be8:68ae with SMTP id n2-20020a2ebd02000000b002c50be868aemr2126673ljq.0.1699454132322; Wed, 08 Nov 2023 06:35:32 -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 du15-20020a05600c634f00b00405959bbf4fsm18858929wmb.19.2023.11.08.06.35.31 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Nov 2023 06:35:31 -0800 (PST) Content-Type: multipart/alternative; boundary="------------rPkwS4VsCZB2TFPbM0TEejpc" Message-ID: <8df20bb5-1d28-44bb-8092-4574499f9b7a@gmail.com> Date: Wed, 8 Nov 2023 15:35:31 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Not able to connect specific database Content-Language: fr, en-US To: Rajesh Kumar Cc: Pgsql-admin 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. --------------rPkwS4VsCZB2TFPbM0TEejpc Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Le 08/11/2023 à 11:43, Rajesh Kumar a écrit : > How to solve this then? > > On Wed, 8 Nov, 2023, 4:05 PM SAS, wrote: > > 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. > You don't give enough information to be helped. -- Dr Stéphane Schildknecht Contact régional PostgreSQL pour l'Europe francophone +33 617 11 37 42 --------------rPkwS4VsCZB2TFPbM0TEejpc Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit
Le 08/11/2023 à 11:43, Rajesh Kumar a écrit :
How to solve this then?

On Wed, 8 Nov, 2023, 4:05 PM SAS, <sas.postgresql@gmail.com> wrote:
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.


You don't give enough information to be helped.

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

--------------rPkwS4VsCZB2TFPbM0TEejpc--