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 CALfOM6KCntD9EgK4f_qm=PeosJ1Q4O_0n3OVzMWmqdsjjmhOKw@mail.gmail.com
Whole thread Raw
In response to ERROR: could not open file "pg_tblspc  (Daulat <daulat.dba@gmail.com>)
List pgsql-admin
Tree view
There is no error while performing  select/create/drop the table on that database from psql.

On Tue, Dec 14, 2021 at 10:26 PM Daulat <daulat.dba@gmail.com> wrote:

Hi Team

I am getting the below error while opening some tab/menus options in the application for a specific database.

 
Caused by: org.postgresql.util.PSQLException: ERROR: could not open file "pg_tblspc/859888/PG_10_201707211/859890/876783": No such file or directory


I see, this directory exists till  pg_tblspc/859888/PG_10_201707211/859890/
Also I am able to select/create/drop the table on that database from psql.

Any suggestions? Is that database corrupt?
Postgres version is 10.

Thanks


pgsql-admin by date:

Previous
From: Daulat
Date:
Subject: ERROR: could not open file "pg_tblspc
Next
From: Laurenz Albe
Date:
Subject: Re: ERROR: could not open file "pg_tblspc