permission denied for schema topology

From: Iain Mott <mott(at)reverberant(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: permission denied for schema topology
Date: 2014-09-11 10:49:51
Message-ID: 1410432591.3562.40.camel@espelho
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rémi Cura 2014-09-11 10:53:13 Re: permission denied for schema topology
Previous Message hari.fuchs 2014-09-11 08:23:51 Re: Aggregating over nodes in hierarchical trees