Re: pg_dump without psql rights

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump without psql rights
Дата
Msg-id 10803.1174965664@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dump without psql rights  ("Robert James" <srobertjames@gmail.com>)
Ответы Re: pg_dump without psql rights  (Oleg Bartunov <oleg@sai.msu.su>)
Список pgsql-general
"Robert James" <srobertjames@gmail.com> writes:
> I'm getting this error:
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR: permission denied for relation
> pg_ts_dict
> pg_dump: The command was: LOCK TABLE public.pg_ts_dict IN ACCESS SHARE MODE

> Is there anyway I can do a pg_dump as non psql?  Perhaps without locks?

No.  However, I am wondering why it is that tsearch2 doesn't make its
config tables publicly readable ...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Kev"
Дата:
Сообщение: database-wide triggers
Следующее
От: "Stuart Cooper"
Дата:
Сообщение: Re: Strange result using transactions