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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Correct .. this is the windows one.

If I reload the software, I'm good until the next day.

-----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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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.

Reload what software, Postgres or the GPO?

In either case you need to have a discussion with the creators of the GPO.

-----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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general