Hi Michael, 2016-06-15 5:00 GMT-03:00 Michael Paquier <michael.paquier@xxxxxxxxx>: > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general