Re: pg_dump without psql rights - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump without psql rights
Date
Msg-id 10803.1174965664@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump without psql rights  ("Robert James" <srobertjames@gmail.com>)
Responses Re: pg_dump without psql rights  (Oleg Bartunov <oleg@sai.msu.su>)
List 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 by date:

Previous
From: "Kev"
Date:
Subject: database-wide triggers
Next
From: "Stuart Cooper"
Date:
Subject: Re: Strange result using transactions