Обсуждение: Server status

Поиск

Список

Период

Сортировка

Server status

От

"Little, Douglas"

Дата:

10 августа 2010 г., 21:00:56

Hi,

We’re getting to change the status on our Greenplum/Postgres data warehouse to a production environment,

As part of that I’ve lost my superuser privileges. So I’m no longer able to see the details of the workload on the server,

But it’s very helpful. I want it.

1. What permissions are required to use the server status

2. Is there any workaround if that permission is superuser.

Thanks

Doug Little

Sr. Data Warehouse Architect | Enterprise Data Management | Orbitz Worldwide

500 W. Madison, Suite 1000 Chicago IL 60661| Office 312.260.2588 | Fax 312.894.5164 | Cell 847-997-5741

Douglas.Little@orbitz.com

Re: Server status

От

Josh Berkus

Дата:

10 августа 2010 г., 21:05:09

Doug,

First off, have you considered the greenplum forums for these sorts of
questions?

> 1.        What permissions are required to use the server status

Superuser.  Since you get to see other people's queries.

> 2.       Is there any workaround if that permission is superuser.

Have a superuser create a SECURITY DEFINER function on the master.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: Server status

Server status

Re: Server status