Last active
January 2, 2016 03:39
-
-
Save davidfetter/8245220 to your computer and use it in GitHub Desktop.
Parallel partial replica workflow
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. Set up DDL if needed e.g. using the pg_restore --section=pre-data machinery. | |
2. Open a pool of connections to the destination server. | |
3. Save out a snapshot on the source server as usual in pg_dump -j. | |
4. Open j connections to the source server. | |
5. For each source connection, dump table data as specified (possibly via COPY BINARY) directly to | |
an open target connection, or buffer if no open target connections are available. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment