Postgres Pro
Downloads
Home   >   mailing lists

Re: ERROR: could not open file "pg_tblspc - Mailing list pgsql-admin

From Daulat
Subject Re: ERROR: could not open file "pg_tblspc
Date
Msg-id CALfOM6+jCmMKyvGVH14PSrZT73Cgpfgm1zyOga2J90_t7+Okrg@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: could not open file "pg_tblspc  (Daulat <daulat.dba@gmail.com>)
Responses Re: ERROR: could not open file "pg_tblspc  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-admin
Tree view
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.dba@gmail.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


On Tue, Dec 14, 2021 at 10:53 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Tue, 2021-12-14 at 22:47 +0530, Daulat wrote:
> Thanks !
> The output of query is 

Please reply to the mailing list.

Yours,
Laurenz Albe
--
+43-670-6056265
CYBERTEC PostgreSQL International GmbH
Römerstraße 19, 2752 Wöllersdorf
Web: https://www.cybertec-postgresql.com


pgsql-admin by date:

Previous
From: Daulat
Date:
Subject: Re: [EXTERNAL] Re: Limits user connection in pgbouncer
Next
From: Laurenz Albe
Date:
Subject: Re: ERROR: could not open file "pg_tblspc