Re: error connecting to the server: fatal :could not open file "base/12029/11801" permission denied - Mailing list pgsql-general

From Adrian Klaver
Subject Re: error connecting to the server: fatal :could not open file "base/12029/11801" permission denied
Date
Msg-id 56439F6C.5030009@aklaver.com
Whole thread Raw
In response to Re: error connecting to the server: fatal :could not open file "base/12029/11801" permission denied  ("Mammarelli, Joanne T" <joanne.t.mammarelli@verizon.com>)
List pgsql-general
On 11/11/2015 11:40 AM, Mammarelli, Joanne T wrote:
> Correct .. this is the windows one.
>
> If  I reload the software, I'm good until the next day.

I should have been clearer. The error you are seeing is Postgres being
denied access to its files by the OS. That is not something that can be
solved on the Postgres end, it needs to be done through the OS.

>
>
>
> -----Original Message-----
> From: Adrian Klaver [mailto:adrian.klaver@aklaver.com]
> Sent: Wednesday, November 11, 2015 2:40 PM
> To: Mammarelli, Joanne T; pgsql-general@postgresql.org
> Subject: Re: [GENERAL] error connecting to the server: fatal :could not open file "base/12029/11801" permission
denied
>
> On 11/11/2015 11:32 AM, Mammarelli, Joanne T wrote:
>> Postgresql 9.3
>>
>> Windows 2008 R2
>>
>> When I install the software, I can access the databases via pgadmin
>> with no problems.
>
> So to be clear the Postgres server is installed on Windows?
> Not talking about the one you installed on RedHat?
>
>>
>> However, after a windows GPO push, I receive the fatal error.
>
> So this?:
> https://en.wikipedia.org/wiki/Group_Policy
>
>>
>> error connecting to the server: fatal :could not open file
>> "base/12029/11801" permission denied
>
> I would say that was a change in permissions policy in the above.
> Probably have to ask whomever created the new policy.
>
>>
>> Any suggestions?
>>
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: error connecting to the server: fatal :could not open file "base/12029/11801" permission denied
Next
From: Nicolas Paris
Date:
Subject: Re: recursive table performance (CTE)