Re: Exclude pg_largeobject form pg_dump

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Exclude pg_largeobject form pg_dump
Date: 2016-03-08 16:13:55
Message-ID: VisenaEmail.59.1a2f3002c4199902.15357011130@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

På tirsdag 08. mars 2016 kl. 17:10:43, skrev Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
<mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>>:
Andreas Joseph Krogh <andreas(at)visena(dot)com> writes:
> P�� tirsdag 08. mars 2016 kl. 16:54:19, skrev Adrian Klaver <
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>:
>  Off hand I would say you are running pg_dump as a user that is not a
>  superuser:

> Yes, since when should I not be able to dump a DB (owned by a non-superuser)
> as that user?

The problem is that -t '*' is being interpreted as matching system
catalogs.  You might be able to get somewhere with

pg_dump -t '*' -N pg_catalog ...

Probably we should fix pg_dump so it doesn't try to dump system catalogs
as tables, even if the switches seem to ask it to.

regards, tom lane
 
That didn't work either:
pg_dump -t '*' -N pg_catalog
pg_dump: [archiver (db)] query failed: ERROR:  permission denied for relation
pg_authid
pg_dump: [archiver (db)] query was: LOCK TABLE pg_catalog.pg_authid IN ACCESS
SHARE MODE

 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

 

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jan de Visser 2016-03-08 16:29:57 Re: Does a call to a language handler provide a context/session, and somewhere to keep session data?
Previous Message Tom Lane 2016-03-08 16:10:43 Re: Exclude pg_largeobject form pg_dump

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2016-03-08 16:16:26 Re: [PROPOSAL] VACUUM Progress Checker.
Previous Message Tom Lane 2016-03-08 16:10:43 Re: Exclude pg_largeobject form pg_dump