Postgres Pro
Downloads
Home   >   mailing lists

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

From Daulat
Subject ERROR: could not open file "pg_tblspc
Date
Msg-id CALfOM6+JoapGQOvB1+HjMqWHYSyn5Jy-a8LUm-xTunTK_gRiuA@mail.gmail.com
Whole thread Raw
Responses Re: ERROR: could not open file "pg_tblspc
Re: ERROR: could not open file "pg_tblspc
List pgsql-admin
Tree view

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: "Godfrin, Philippe E"
Date:
Subject: RE: [EXTERNAL] Re: Limits user connection in pgbouncer
Next
From: Daulat
Date:
Subject: Re: ERROR: could not open file "pg_tblspc