pgsync_repro.sh

createdb pgsync_repro1
createdb pgsync_repro2

psql pgsync_repro1 << SQL
CREATE TABLE posts (
  id BIGINT PRIMARY KEY,
  linked_post_id BIGINT,
  FOREIGN KEY (linked_post_id) REFERENCES posts (id)
);
INSERT INTO posts VALUES (1, NULL), (2, 1);
SQL

psql pgsync_repro2 << SQL
CREATE TABLE posts (
  id BIGINT PRIMARY KEY,
  linked_post_id BIGINT,
  FOREIGN KEY (linked_post_id) REFERENCES posts (id)
);
SQL

pgsync --from pgsync_repro1 --to pgsync_repro2