pg_dump without psql rights

From: "Robert James" <srobertjames(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump without psql rights
Date: 2007-03-21 17:47:20
Message-ID: e09785e00703211047q46fef5d9r2d0e41b9cc57bd28@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'd like to run pg_dump on a database that I have full
read/write/create/drop access to, but am not running as psql.

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

(tried on both Windows and Linux)

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robert James 2007-03-21 17:48:20 VACUUM ANALYZE
Previous Message Magnus Hagander 2007-03-21 17:05:24 Re: to_tsvector in 8.2.3