[Slony1-general] Switching Slave VM

2020-07-22 Thread Sung Hsin Lei via Slony1-general
Hello, I have a slave machine who's database I want to restore on a different machine with a different ip. Since the backup process takes several hours, I disconnect the master, backup the slave db and restore it on the new slave machine. Then I shutdown the slave machine and reconnect the master

[Slony1-general] Replication interruption

2021-10-22 Thread Sung Hsin Lei via Slony1-general
This question may have been asked already. I have noticed that if it takes 10 days for the initial data transfer to complete, if the transfer is interrupted after 9 days, the transfer resumes from day 1. In other words, I need 10 days of uninterrupted connection between the master and slave

[Slony1-general] Order of "set add table" on speed

2022-01-26 Thread Sung Hsin Lei via Slony1-general
Hi, Does the order of the "set add table" matter for the speed of the initial replication? If I have tables "emails" which depends on "partitions" which depends on "accounts", is there a difference between: set add table (set id=1, origin=1, id=1, fully qualified name = 'public.emails ',

Re: [Slony1-general] Slony website is down

2024-06-03 Thread Sung Hsin Lei via Slony1-general
Hi, Since the site is down and the project is ending, is there a place where people with legacy development can go to get documentation such as, for example, performing a switchover, performing a repair, adding tables to a set... etc. Thanks On Mon, May 13, 2024 at 9:26 AM Jan Wieck via