Re: Unable to connect DB...?

Thanks for your response...

The directory base is already owned by user postgres only.

On Tue, 16 Jul 2019 at 17:38, Holger Jakobs <holger(at)jakobs(dot)com> wrote:

> 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(at)jakobs(dot)com
> +49 178 9759012 <+491789759012> oder +49 2202 817157 <+492202817157>
>
> --
>
> Holger Jakobs, Bergisch Gladbach
> instant messaging: xmpp:holger(at)jakobs(dot)com
> +49 178 9759012 <+491789759012> oder +49 2202 817157 <+492202817157>
>
--

Thanks & Regards
Venkataramana Aitla