Re: ERROR: could not open file "pg_tblspc

Thanks a lot. It is working after rebuilding the index.

On Wed, Dec 15, 2021 at 1:57 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Tue, 2021-12-14 at 23:12 +0530, Daulat wrote:
> > Will it work if we rebuild that index ? Looks like it is an issue with
> the index.
> >
> > On Tue, Dec 14, 2021 at 10:55 PM Daulat <daulat(dot)dba(at)gmail(dot)com> wrote:
> > > Sorry I missed it !
> > >
> > > The output of query is
> > >
> > > SELECT oid::regclass, relkind FROM pg_class WHERE relfilenode = 876783;
> > > oid | relkind
> > > ----------------------------+---------
> > > grc.masterdata_code_unique | i
>
> Yes, the index file is missing. If you are lucky, REINDEX INDEX will help.
>
> You should figure out who or what goes around deleting files in your
> data directory.
>
> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>