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?