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
