Re: access is denied completely from postgresql!! - Mailing list pgsql-admin

From Tom Lane
Subject Re: access is denied completely from postgresql!!
Date
Msg-id 25812.1016903208@sss.pgh.pa.us
Whole thread Raw
In response to Re: access is denied completely from postgresql!!  ("David" <iaredavey@hotmail.com>)
List pgsql-admin
"David" <iaredavey@hotmail.com> writes:
> If i try to service it with Webmin, which worked before the =
> crash, Webmin now returns the following kind of error..for example, retriev=
> ing a list of users of the system:=20

>   SQL select * from pg_shadow failed : pg_shadow: Permission denied.
>   I can see the current data in the current database, just cant do anything=
>  with that, add users, or give users permission etc.

Apparently Webmin is connecting as a non-superuser Postgres user.  Check
which user you are starting it as.  Perhaps you have forgotten to set
an appropriate PGUSER environment value?

            regards, tom lane

pgsql-admin by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: access is denied completely from postgresql!!
Next
From: Lucas Rockwell
Date:
Subject: no drop column?!