Iain Mott <mott@xxxxxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
