Re: permission denied for schema topology

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