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