Re: permission denied for schema topology

Iain Mott <mott(at)reverberant(dot)com> writes:
> Here's what happens (the important error messages are in English):

> [~]# pg_dump mydatabase > dump.sql
> pg_dump: comando SQL falhou
> pg_dump: Mensagem de erro do servidor: ERROR: permission denied for schema topology
> pg_dump: O comando foi: LOCK TABLE topology.topology IN ACCESS SHARE MODE

> I am able to perform dumps of the databases via phpPdAdmin in the
> "cpanel" of the server, but this is going very inconvenient - hoping to
> use pg_dump

If it works through phpPgAdmin, then phpPgAdmin must be using some other
(more privileged) user ID than what pg_dump is using by default. A simple
workaround therefore ought to be to use pg_dump's -U switch to use that
other user ID.

From the rest of the thread I gather that you ought to complain to your
service provider that they installed postgis when you didn't ask for it.
But selecting the right user ID to dump as is important anyway; it
generally doesn't work to use an underprivileged ID for pg_dump.

regards, tom lane