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@reverberant.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
>
>