Thread: Permission problem opening database

Permission problem opening database

From
Dilan A
Date:
Hi, I  have done some RTFMing and come up with little on this one.

I have a database that I had setup in the past that I haven't opened for
a while created under 8.1 running the native Win32 port.

When I started the postgres service and tried connecting using PgAdmin
III I got the following error:
An Error has occurred. FATAL: could not open relation 16627/16628/2701:
Permission Denied.

Any ideas on how this can be fixed.

Thanks.

Re: Permission problem opening database

From
Richard Huxton
Date:
Dilan A wrote:
> When I started the postgres service and tried connecting using PgAdmin
> III I got the following error:
> An Error has occurred. FATAL: could not open relation 16627/16628/2701:
> Permission Denied.
>
> Any ideas on how this can be fixed.

First step is to check the permissions on all your database files. Have
you any reason to think they may have changed? Do you have a new
virus-scanner installed?

--
   Richard Huxton
   Archonet Ltd