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

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
>
>