On Fri, Oct 9, 2015 at 9:34 PM, Sung Hsin Lei <sungh....@gmail.com> wrote: > Hello, > > I have a 10gig database on the Master which I backed up and restored on the > Slave. Database activity is low. When I setup Slony replication from the > Master to the Slave, it would take hours before new information from the > Master would be updated into the Slave. Postgres would be also VERY slow for > the first few hours. However, after the initial wait period, the Slave would > update within a second or so and Postgres speed would return to normal. I'm > assuming that Slony is taking time to verify the initial database integrity > between the Master and the Slave. Am i right? I would like to know if > there's a way to have the updates start within the first few minutes of the > original setup.
In a normal slony sub, all you need on the slave is the schema. If there's data there it'll get truncated / deleted, so there's no reason to spend time copying it over. IF and only IF you are willing to take your master offline from your application (i.e. stop writes going to it) you can copy over the data and then subscribe with no copy. If the master is not taken "offline" from an application perspective then a subscribe with no copy will result in your master and slave not having the same data (which is bad). _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
