I'm working with slon and the index portion for at least 3 of my tables take hours to complete and thus with this instance of slony being a wide area replica, sessions time out and slon fails to complete.
So I'm looking at dumping the schema without index information, install that on the slon slave and replicate that way, once replication of the data is done, I can run commands to create the indexes.
So I'm looking at dumping the schema without index information, install that on the slon slave and replicate that way, once replication of the data is done, I can run commands to create the indexes.
But I'm not 100% if there are tools or private scripts written to pull indexes from a schema only dump and then allow for an easy recreation of the indexes at the end of the slon replication process (once all sets are replicated)?
Thanks
Tory
Thanks
Tory
