On Wed, Jun 15, 2016 at 7:19 PM, Martín Marqués <martin@xxxxxxxxxxxxxxx> wrote: > 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? pg_dump creates the schema first via the CREATE EXTENSION command, then tables dependent on this schema that are not created by the extension are dumped individually. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
