| From: | Daulat <daulat(dot)dba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: ERROR: could not open file "pg_tblspc |
| Date: | 2021-12-14 16:58:10 |
| Message-ID: | CALfOM6KCntD9EgK4f_qm=PeosJ1Q4O_0n3OVzMWmqdsjjmhOKw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(dot)dba(at)gmail(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-12-14 17:10:59 | Re: ERROR: could not open file "pg_tblspc |
| Previous Message | Daulat | 2021-12-14 16:56:47 | ERROR: could not open file "pg_tblspc |