Re: permission denied for schema topology - Mailing list pgsql-general

From Iain Mott
Subject Re: permission denied for schema topology
Date
Msg-id 1410435441.3562.55.camel@espelho
Whole thread Raw
In response to Re: permission denied for schema topology  (Rémi Cura <remi.cura@gmail.com>)
Responses Re: permission denied for schema topology
List pgsql-general
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@reverberant.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@reverberant.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@postgresql.org)
>         >         To make changes to your subscription:
>         >         http://www.postgresql.org/mailpref/pgsql-general
>         >
>         >
>
>
>
>
>




pgsql-general by date:

Previous
From: Rémi Cura
Date:
Subject: Re: permission denied for schema topology
Next
From: Daniel Begin
Date:
Subject: Re: PostgreSQL Portable