On 01/04/2015 12:14 AM, John Casey wrote: > We have been trying to load our existing database that contains local > sequences into a BDR-based database with global sequences.
[snip] > There just doesn’t seem to be a good way to accomplish this operation, > at least not a documented way I have been able to find. I think you want default_seqam = bdr . https://wiki.postgresql.org/wiki/BDR_Global_Sequences#Global_sequences_created_by_default You can pass this to psql or pg_restore using a PGOPTIONS setting or an 'options=' entry in a connection dsn, e.g. pg_restore -d "dbname=mydb options='-c default_sequenceam=bdr'" dumpfile -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
