From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Unable to connect DB...?
Date: Tue, 16 Jul 2019 14:07:48 +0200
Message-ID: <1f5b6b2b-4a1f-6456-dd21-871133b5d883@jakobs.com> (raw)
In-Reply-To: <1fd244fa-1e3c-4f02-01ee-03a1ffd25397@jakobs.com>
References: <CAJi6zqrKhy9AaO-4uXG3cH53Jst1jKfUQwnOQAh_5urb8Vwabw@mail.gmail.com>
<1fd244fa-1e3c-4f02-01ee-03a1ffd25397@jakobs.com>
Since your message says that the file is completely missing, someone
must have deleted the file. There is nothing you can do except restoring
from a backup.
Making sure postgres owns the files and the access rights are restricted
to rw------- prevents this.
Even a file system error won't lead to this situation, as typically the
file remains with length 0.
Am 16.07.19 um 13:44 schrieb Holger Jakobs:
>
> 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 <tel:+491789759012> oder +49 2202 817157
> <tel:+492202817157>
>
--
Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger@jakobs.com
+49 178 9759012 <tel:+491789759012> oder +49 2202 817157
<tel:+492202817157>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: holger@jakobs.com
Subject: Re: Unable to connect DB...?
In-Reply-To: <1f5b6b2b-4a1f-6456-dd21-871133b5d883@jakobs.com>
References: <CAJi6zqrKhy9AaO-4uXG3cH53Jst1jKfUQwnOQAh_5urb8Vwabw@mail.gmail.com> <1fd244fa-1e3c-4f02-01ee-03a1ffd25397@jakobs.com> <1f5b6b2b-4a1f-6456-dd21-871133b5d883@jakobs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox