Re: Unable to connect DB...? - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: Unable to connect DB...?
Date
Msg-id 1fd244fa-1e3c-4f02-01ee-03a1ffd25397@jakobs.com
Whole thread Raw
In response to Unable to connect DB...?  (Venkataramana Aitla <avr1984@gmail.com>)
Responses Re: Unable to connect DB...?  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin

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

pgsql-admin by date:

Previous
From: Venkataramana Aitla
Date:
Subject: Unable to connect DB...?
Next
From: Holger Jakobs
Date:
Subject: Re: Unable to connect DB...?