On Sat, Feb 15, 2014 at 6:06 AM, Tory M Blue <tmblue@xxxxxxxxx> wrote: > > > 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. > > 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)? "pg_dump --section" can be used for that. pre-data includes table definitions and everything other than post-data dumps. post-data has contraint, trigger, index and rules. -- Michael -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
