Re: access is denied completely from postgresql!!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David" <iaredavey(at)hotmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: access is denied completely from postgresql!!
Date: 2002-03-23 17:06:48
Message-ID: 25812.1016903208@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"David" <iaredavey(at)hotmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lucas Rockwell 2002-03-25 04:34:46 no drop column?!
Previous Message Jean-Michel POURE 2002-03-23 13:18:25 Re: access is denied completely from postgresql!!