Re: pg_dump without psql rights

On Mon, 26 Mar 2007, Tom Lane wrote:

> "Robert James" <srobertjames(at)gmail(dot)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 ...

config tables are like other user created tables, the same access policy.
It's up to user grant access to them.

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83