Re: permission denied for schema topology

Thanks a lot. Here is the response to

=> SELECT postgis_full_version();

postgi
s_full_version

--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
---------
POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.8.0, 6 March
2012" G
DAL="GDAL 1.9.1, released 2012/05/15 GDAL_DATA not found" LIBXML="2.7.6"
TOPOLOG
Y RASTER
(1 registro)

Em Qui, 2014-09-11 às 13:21 +0200, Rémi Cura escreveu:
> 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
> >
> >
>
>
>
>
>