Re: pg_extension_config_dump() with a sequence

[Moshe Jacobson <moshe@xxxxxxxxxxxx>]

On Tue, Aug 20, 2013 at 4:03 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

It's pretty hard to believe that that would work in pg_dump but not

pg_dumpall.  You sure the error references a database that you fixed the
sequence definition in?  (You'd probably have to drop and recreate the
extension to fix it in an existing database.)  If so, what PG version are
we talking about exactly, and what's the whole pg_dumpall command line?

Thanks for the response, Tom.

You're right, pg_dump fails as well:

pg_dump: SQL command failed

pg_dump: Error message from server: ERROR:  cannot copy from sequence "sq_pk_audit_data_type"

pg_dump: The command was: COPY auditlog.sq_pk_audit_data_type  TO stdout;

I can pg_dump our prod database and pg_restore it onto our dev server with zero errors, but once I try to pg_dump the dev copy again, that's when I receive the errors above.

I didn't drop & recreate the extension to fix it on prod -- I just created a new version of it and updated it.

Any ideas?

--

Moshe Jacobson
Nead Werx, Inc. | Manager of Systems Engineering

2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
moshe@xxxxxxxxxxxx | www.neadwerx.com

"Quality is not an act, it is a habit." -- Aristotle