Re: permission denied for schema topology

Yep,
this means you are using postgis.
I don't know if you use postgis topology.
If you have a schema topology containing a topology table, then you also
have postgis_topology installed.

You can check this with this query : "SELECT postgis_full_version();"

Maybe the extensions have been created with another user id than your's,
hence the trouble.
Another trouble could come from the fact that postgis and postgis_topology
may have been installed without using postgres CREAtE EXTENSION (old
version of postgis).

Cheers,
Rémi-C

2014-09-11 13:12 GMT+02:00 Iain Mott <mott(at)reverberant(dot)com>:

> Thanks Rémi-C for the quick reply. By coincidence my site does involve
> mapping, however I wasn't aware that the server might be using postgis
> and postgis_topology. In psql when I type "\d" i get the following:
>
> public | comentarios | tabela | myusername
> public | featuredata | tabela | myusername
> public | geography_columns | visão | myusername
> public | geometry_columns | visão | myusername
> public | raster_columns | visão | myusername
> public | raster_overviews | visão | myusername
> public | rss | tabela | myusername
> public | spatial_ref_sys | tabela | myusername
>
> geography_columns, geometry_columns, raster_columns, raster_overviews
> and spatial_ref_sys are all recent changes to my database (I didn't
> create them and I wasn't aware of their existence until the switch to
> the new server). Do these and the errors I'm receiving indicate the use
> of postgis and postgis_topology by the server?
>
> Just googled for doing a dump of a postgis database and encountered this
> command:
>
> pg_dump --no-acl --no-owner $DATABASE > dump.sql
>
> I tried it, but it results in the same error messages
>
> Cheers,
>
>
>
>
>
>
>
>
>
> Em Qui, 2014-09-11 às 12:53 +0200, Rémi Cura escreveu:
> > Hey,
> >
> > if you are using postgis and postgis_topology,
> > there are specific backup/restore process.
> > Cheers,
> > Rémi-C
> >
> >
> > 2014-09-11 12:49 GMT+02:00 Iain Mott <mott(at)reverberant(dot)com>:
> > Hello,
> >
> > The server for my websites was recently changed and upgraded.
> > I have ssh
> > access to the server and since the upgrade I am no longer able
> > to use
> > "pg_dump" to perform scripted backups. I've written to the
> > site's
> > support services, but until now, they've not been able to help
> > (they've
> > responded saying they will likely need to refer the case on to
> > a
> > developer - I don't have any guarantees that it will be
> > resolved).
> >
> > I've googled for this - but didn't come up with any relevant
> > solutions.
> > Can someone on this list please make suggestions that I can
> > pass on to
> > the technical support?
> >
> > Here's what happens (the important error messages are in
> > English):
> >
> >
> > [~]# pg_dump mydatabase > dump.sql
> > Senha:
> > 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
> >
> > Thanks,
> >
> >
> >
> > --
> > Sent via pgsql-general mailing list
> > (pgsql-general(at)postgresql(dot)org)
> > To make changes to your subscription:
> > http://www.postgresql.org/mailpref/pgsql-general
> >
> >
>
>
>