From: | Martín Marqués <martin(at)2ndquadrant(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | PgQ and pg_dump |
Date: | 2016-06-14 16:34:22 |
Message-ID: | d86dd685-1870-cfa0-e5e4-def1f918bec9@2ndquadrant.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Hi,
I was working on a PgQ installation and found something odd which I'd
like to see if others here have bumped into regarding using pg_dump on a
database that has the pgq schema created by the extension.
If PgQ is installed as an extension (by executing CREATE EXTENSION pgq)
all the objects created by the extension will depend on it, and so will
have entries in pg_depend for all of them with deptype e. (these are the
objects that pg_dumps ignores as they will be created by the extension)
The problem is that the pgq.sql creates the pgq schema, and so that
object won't get dumped, same as with all the other objects created in
that shema, including the events tables created by pgq.create_queue().
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.
This happens because PgQ was installed as an extension, as opposed to
just passing the pgqd.sql file to psql, or having the schemata, tables
and functions created by londiste (maybe the most common way nowadays).
Is it sensible to have all the pgq* schemata recreated (and empty) when
restoring a dump or not?
Regards,
--
Martín Marqués http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Buckman | 2016-06-14 18:49:59 | Re: Using a VIEW as a temporary mechanism for renaming a table |
Previous Message | Rupesh Choudhary | 2016-06-14 16:33:38 | Data ingestion failing when using higher Batch size |
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2016-06-14 16:37:06 | Re: parallel.c is not marked as test covered |
Previous Message | Tom Lane | 2016-06-14 16:18:42 | Re: ERROR: ORDER/GROUP BY expression not found in targetlist |