Thom Brown darkixion
darkixion
/ gist:5694200
Created
June 2, 2013 17:18
1000 local Postgres instances using one-to-one chained streaming-only cascading replication
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
| Instance | Port | Primary Port | Status | XLog location | Replication lag (bytes) | |
| ------------------------------------------------------------------------------------------ | |
| primary | 5530 | | ONLINE | 0/3000700 | 0 | |
| standby1 | 5531 | 5530 | IN RECOVERY | 0/3000700 | 0 | |
| standby2 | 5532 | 5531 | IN RECOVERY | 0/3000700 | 0 | |
| standby3 | 5533 | 5532 | IN RECOVERY | 0/3000700 | 0 | |
| standby4 | 5534 | 5533 | IN RECOVERY | 0/3000700 | 0 | |
| standby5 | 5535 | 5534 | IN RECOVERY | 0/3000700 | 0 | |
| standby6 | 5536 | 5535 | IN RECOVERY | 0/3000700 | 0 | |
| standby7 | 5537 | 5536 | IN RECOVERY | 0/3000700 | 0 |