Re: Unable to connect DB...?

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(at)jakobs(dot)com
> +49 178 9759012 <tel:+491789759012> oder +49 2202 817157
> <tel:+492202817157>
>
--

Holger Jakobs, Bergisch Gladbach
instant messaging: xmpp:holger(at)jakobs(dot)com
+49 178 9759012 <tel:+491789759012> oder +49 2202 817157
<tel:+492202817157>