Split postgres dump
split_postgres_dump is a small Perl script that breaks a --schema-only dump file into pre and post sections. The pre section contains everything needed to import the data, while the post section contains those actions that should be done after the data is loaded, namely the creation of indexes, constraints, and triggers.
The latest version (1.3.3) can be downloaded at:
Everyone is encouraged to look over and make improvements to the code. The latest development version can be obtained by running:
There is also a GitHub mirror for easy patch contribution by the general public.