Re: [GENERAL] permission denied for schema topology

2014-09-12 Thread Iain Mott
- I think it will help me communicate with them to resolve the problem now fully. Cheers, Iain Em Qui, 2014-09-11 às 10:05 -0400, Tom Lane escreveu: > Iain Mott writes: > > Here's what happens (the important error messages are in English): > > > [~]# pg_dump mydat

Re: [GENERAL] permission denied for schema topology

2014-09-11 Thread Iain Mott
y 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 : > Thanks Rémi-C for the quick reply. By coincidence my site does > in

Re: [GENERAL] permission denied for schema topology

2014-09-11 Thread Iain Mott
4-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 : > Hello, > > The server fo

[GENERAL] permission denied for schema topology

2014-09-11 Thread Iain Mott
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