Search Postgresql Archives
pg_dump without psql rights
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- To: pgsql-general@xxxxxxxxxxxxxx
- Subject: pg_dump without psql rights
- From: "Robert James" <srobertjames@xxxxxxxxx>
- Date: Wed, 21 Mar 2007 13:47:20 -0400
- Dkim-signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type; b=XVl6GPz/Sbt/jPhMBvQQbfJWr8aVMHZEJRsv+mzr4uBrxRHWCz5u5QXwFR9f0Nd9vuLlQd723ghEavPSi+rZEKjWJtwFhtu5OhAj9B6lHyhIlDkDtgNO5t/qYrwPpWDGnbScTFUGzcL4XeB5uofdDiXc8YHQYgFok+CnKBLxUIs=
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?
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]
[Postgresql Jobs]
[Postgresql Admin]
[Postgresql Performance]
[Linux Clusters]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Postgresql & PHP]
[Yosemite]