Обсуждение: Unable to connect DB...?

--

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

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

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.

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

--

Once, our developers had the bright idea of deleting files to quickly purge data.  Naturally, it corrupted everything, and points to the danger of developers having the postgres password...

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.

Deleting files isn't really faster than drop table. But it can easily lead to a corrupt database.

No developer should ever have the password of the operating system account postgres on a productive machine. Actually, not even any postgresql superuser password.



--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -