Fri Mar 4 22:31:01 PST 2005
- Previous message: [Slony1-general] backing up/restoring cluster members
- Next message: [Slony1-general] curious size difference in dumps from origin or replica
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Fri, Mar 04, 2005 at 02:28:39PM -0800, Darcy Buskermolen wrote: > no, nothing native in 1.0.5 I did post an email to -general some 3 months > back or so about a method to do this. > Basicly you create a table that has oid -> realname mappings you dump that > with your data, then you update the reloids in the sl_* tables based on the > reverse select (where you get the new reloids for the old relnames). Yeah I only have 25 tables replicated, getting the new oid's is np. The triggers were the problem. I will try Jan's method this weekend. Thanks for the help. -- "The only freedom which deserves the name, is that of pursuing our own good in our own way, so long as we do not attempt to deprive others of theirs, or impede their efforts to obtain it." -- John Stuart Mill, 1859
- Previous message: [Slony1-general] backing up/restoring cluster members
- Next message: [Slony1-general] curious size difference in dumps from origin or replica
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list