Re: permission denied for schema topology - Mailing list pgsql-general
| From | Rémi Cura |
|---|---|
| Subject | Re: permission denied for schema topology |
| Date | |
| Msg-id | CAJvUf_tyoYhhOpyk5nNtwG_vS8unnGy3KNtzJco204JHTaEvhA@mail.gmail.com Whole thread Raw |
| In response to | Re: permission denied for schema topology (Iain Mott <mott@reverberant.com>) |
| Responses |
Re: permission denied for schema topology
|
| List | pgsql-general |
Yep,
this means you are using postgis.You can check this with this query : "SELECT postgis_full_version();"
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).
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: