Re: [PERFORM] Can one Dump schema without index/constraints?

2014-02-14 Thread Tory M Blue
On Fri, Feb 14, 2014 at 5:55 PM, Michael Paquier wrote: > On Sat, Feb 15, 2014 at 6:06 AM, Tory M Blue 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, sessio

Re: [PERFORM] Can one Dump schema without index/constraints?

2014-02-14 Thread Michael Paquier
On Sat, Feb 15, 2014 at 6:06 AM, Tory M Blue 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 t

[PERFORM] Can one Dump schema without index/constraints?

2014-02-14 Thread Tory M Blue
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 slav