On Tue, Aug 20, 2013 at 4:03 PM, Tom Lane <t...@sss.pgh.pa.us> 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 mo...@neadwerx.com | www.neadwerx.com "Quality is not an act, it is a habit." -- Aristotle
