Re: BUG #17276: pg_tblspc Permission denied

From: Zuber Farooqui <zuber(dot)farooqui(at)gmail(dot)com>
To: Zuber Farooqui <zuber(dot)farooqui(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17276: pg_tblspc Permission denied
Date: 2021-11-09 15:22:09
Message-ID: CACLB9g2c=EUpWD1xSAi5qE9Sj2FSByzZ510gtyrUUh+LyDtfJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Any suggestions?

PostgreSQL version: 9.6.7
> Operating system: UNIX
> Description:
>
> Dear Postgresql Users,
>
> Few months back I successfully created tablespace in Postgresql and
> everything was working in terms of creating and accessing the tables.
>
> I had to restart my system and I now I am getting "Permission Denied"
> ERROR.
> I am able to access table which are not in tablespace. Below is the error
> message.
> ERROR: could not open file "pg_tblspc/55729/PG_9.6/12926/55956":
> Permission
> denied
>
> It looks like tablespace is not mounted back to Postgresql after system
> restart.
>
> I appreciate your help in resolving the issue.
>
> Thank you!
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Geoghegan 2021-11-09 17:51:45 Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum
Previous Message Dmitry Dolgov 2021-11-09 15:02:16 Re: BUG #17255: Server crashes in index_delete_sort_cmp() due to race condition with vacuum