Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnLtC-0000Gs-K5 for pgsql-admin@arkaria.postgresql.org; Tue, 16 Jul 2019 11:44:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnLt9-0002Vr-LQ for pgsql-admin@arkaria.postgresql.org; Tue, 16 Jul 2019 11:44:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnLt9-0002VV-BX for pgsql-admin@lists.postgresql.org; Tue, 16 Jul 2019 11:44:55 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnLt5-0001IZ-74 for pgsql-admin@lists.postgresql.org; Tue, 16 Jul 2019 11:44:54 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 3E09EBE0BD4 for ; Tue, 16 Jul 2019 13:44:48 +0200 (CEST) X-Virus-Scanned: Debian amavisd-new at rs.plausibolo.de Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id ZM62PCxjeo65; Tue, 16 Jul 2019 13:44:46 +0200 (CEST) Received: from [192.168.104.107] (unknown [145.253.118.26]) by rs.plausibolo.de (Postfix) with ESMTPSA id 37A1EBE04CF; Tue, 16 Jul 2019 13:44:46 +0200 (CEST) Subject: Re: Unable to connect DB...? To: pgsql-admin@lists.postgresql.org References: From: Holger Jakobs Openpgp: preference=signencrypt Autocrypt: addr=holger@jakobs.com; prefer-encrypt=mutual; keydata= mQGiBEG8IA8RBAC6WqUzEPTjest7MvFca5WlI47EgtKzOy1D1X9gSEmPj0sQrilNGEitY/+Q kPnCvI3odz1XXf/MZQtXwlxJA4lPmx8/K7MqBj9vh0J5jRznpE7l+SBDmmDobIqBAgl6BZvH 1C7e2y72h5T1/plrXonLUGzthqBtsvWl0ogoyTJqiwCg6AOhYX+Xbcl8/AXy4F4qbUq4LXsD /j6yCKRkyleN688y9YpuS5J6/ZZ/OBCM74pa2iNge3GmXn1JeUowF693QFCGHkpswmDIoGhL 5iM6GHj9HFB6rTXW5H3sR1y6ta7vXwoNBGkgiM89B1a/KsLT5L6MZgZ5AV0tj6vxwAsuLixS SDiNVNAd8vp2FfqdLlOgThsgVIwKBACsCzZa1VxpdoNSYnkTOSZhEjZkbWApdneQ2bTxXJgW +fWgVeLiojCp6I1AmQqzwHz8UN1nrsQjH8Rnxt2J/C5H/Ek9jlOFakFQXlPMZw3tNeTA1P3B 3zPyq6hKFPZHFklUquE3gHVjnX9qxSW0xvFirf6xAMCMYWRnCQHRgiXoAbQhSG9sZ2VyIEph a29icyA8aG9sZ2VyQGpha29icy5jb20+iGQEExECACQCGwMGCwkIBwMCAxUCAwMWAgECHgEC F4AFAlZ7KnEFCSeLDWIACgkQileck7MZYbpbxgCgxM54+4qx/sfGwq01x93pWr2QghwAoIfD Of6Uoc43y98+xR5/Iu9Z1RH8uQENBEG8IBAQBACiGkoX8HKCocdCwRdMzc9siDs1w0YNayhT PnK9Ii3wzzS2R9NSyWsPQVyx6hkVfSmK6CE5RzfuDUzrYEgyaV/2vT3JD9Gko+RuFnjeQvVo 8hc19bmBSn95ATki+hFy/68MqpMlsG7YyCluRSpXh2qxlhbh2FzTIQmiEQAR4kFCEwADBQP/ Z1Y6nwoXw/5JmLJLFcvZZlFfn4g9TjyMSwH50/AXqOApccy9JSzoTFY87ItmGkhD0qj18PJB St2uqASGrk2/55XK596RWnoeyL9mzj5r6woDqPNRXIbK85foGVIMRrb/EufgSOP5H6VHybvB PD4CppEw4Q0fRsMCaOcvibkjHoqITwQYEQIADwIbDAUCVnsqcQUJJ4sNYQAKCRCKV5yTsxlh urunAJ9avyijdRls7l6XPc2cBMys3xu/sgCeOVJE6DzwBBRUd6S6mtf2eG4FPXg= Message-ID: <1fd244fa-1e3c-4f02-01ee-03a1ffd25397@jakobs.com> Date: Tue, 16 Jul 2019 13:44:45 +0200 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.7.2 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------0A1F489688087468DB2A9666" Content-Language: de-DE List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------0A1F489688087468DB2A9666 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Actually, the directory base and all its descendants must be owned by the user postgres. Check this or correct by issuing this command as root: chown -R postgres:postgres /path/to/directory The /path/to/directory has to be to the directory where base resides in. Regards, Holger Am 16.07.19 um 08:39 schrieb Venkataramana Aitla: > Hi, > > Not able to connect DB... > > psql -d > psql: FATAL:  could not open file "base/32777/14376902”: No such file > or directory > > DB size is in ~1.5TB > > What is the solution for this..? > > -- > > Thanks & Regards > Venkataramana Aitla -- Holger Jakobs, Bergisch Gladbach instant messaging: xmpp:holger@jakobs.com +49 178 9759012 oder +49 2202 817157 --------------0A1F489688087468DB2A9666 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

Actually, the directory base and all its descendants must be owned by the user postgres. Check this or correct by issuing this command as root:

chown -R postgres:postgres /path/to/directory

The /path/to/directory has to be to the directory where base resides in.

Regards,

Holger

Am 16.07.19 um 08:39 schrieb Venkataramana Aitla:
Hi,

Not able to connect DB...

psql -d <DB_name>
psql: FATAL:  could not open file "base/32777/14376902”: No such file or directory

DB size is in ~1.5TB

What is the solution for this..?

--

Thanks & Regards
Venkataramana Aitla
--

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 oder +49 2202 817157

--------------0A1F489688087468DB2A9666--