Re: access is denied completely from postgresql!!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: access is denied completely from postgresql!!
Дата
Msg-id 25812.1016903208@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: access is denied completely from postgresql!!  ("David" <iaredavey@hotmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jean-Michel POURE
Дата:
Сообщение: Re: access is denied completely from postgresql!!
Следующее
От: Lucas Rockwell
Дата:
Сообщение: no drop column?!