Re: PgQ and pg_dump

Hi Michael,

2016-06-15 5:00 GMT-03:00 Michael Paquier <michael.paquier@gmail.com>:
> 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..

How would the recovery process work? We expect the schema to be there
when restoring the tables?

That seems sensible.

I'll file a bug report later and maybe move this thread to -hackers.

Regards,

--
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services