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 <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 > > > > > > > > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general