Re: PgQ and pg_dump

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Martín Marqués <martin(at)2ndquadrant(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: PgQ and pg_dump
Date: 2016-06-15 08:00:10
Message-ID: CAB7nPqRPZ41VA79GXXChZruhpWCtB-7ZMOYSz9cyu=StssMPtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Martin wrote:
> I wonder if this is the desirable way of handling pgq, or if those
> tables should be dumped. I'm starting to think that this is a PgQ bug,
> or maybe it's not a good idea to install PgQ as an extension.

As I am looking at that I would qualify that as a bug in pg_dump.
Schemas can be part of the extension definition and be linked to it,
and tables created on top of the schema defined in the extension
should really be dumped..
--
Michael

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martín Marqués 2016-06-15 10:19:49 Re: PgQ and pg_dump
Previous Message Albe Laurenz 2016-06-15 07:31:33 Re: Changelog version from 8.1.2 to 9.3.6

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2016-06-15 09:23:39 Re: parallel.c is not marked as test covered
Previous Message Kyotaro HORIGUCHI 2016-06-15 07:52:13 Re: [BUG] pg_basebackup from disconnected standby fails