Thanks Tom and everyone that replied. Since my last email my service provider managed to solve the problem on my main database. I looked at the schemas listed in phpPgAdmin on this database before it was fixed and there were two main schemas listed, "public" and "topology", both owned by postgres. Now when I look, topology is no longer there. The problem was fixed on that database however not on others and when I create a new datbase via cpanel (the only way the system allows) - the problem reoccurs and I can't do a dump of the new db. Thanks again for your input - I think it will help me communicate with them to resolve the problem now fully. Cheers, Iain Em Qui, 2014-09-11 às 10:05 -0400, Tom Lane escreveu: > 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
