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@jakobs.com
+49 178 9759012 oder +49 2202 817157

--

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