Thom Brown <thom@xxxxxxxxx> writes: > On 28 September 2015 at 22:21, Spencer Gardner <spencergardner@xxxxxxxxx> wrote: >> Actually, yes. That's the reason for backing up. We had been playing with >> BDR on a custom build but have reverted to the stock Ubuntu build for the >> time being. So it sounds like the issue is caused by dumping from our custom >> BDR build. It's not really a big issue - I've already rebuilt the affected >> sequences. > Have you tried dumping the database using the stock pg_dump > executable? The BDR branch isn't compatible with regular PostgreSQL, > at least not yet. Seems like it would be a good idea if BDR's pg_dump were to suppress "USING local" clauses, and only output USING if it's not default, so as not to create gratuitous incompatibilities like this one. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general