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