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 <m...@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 <m...@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 > > > > > > >
