On 3/3/2006 10:07 AM, Yuan HOng wrote: > I have a database on a Postgres 7.4 server with slony-1.0.5replication > enabled. Now I want to the content of the database toanother db-server with > Postgresql 8.1 and no slony. I just want tomove the data, not the replication > information, i.e. without the slonyschema. > There doesn't seem to be an straigtforward to do this. I tried backuponly my > data schema, then restore it on the 8.1 server. But since thetables in data > schema all have slony triggers, the restore doesn'tsucceed. > When I backup the whole database including the slony schema, therestore > complains that the slony shared libraries are not found. > So I tried to install slony-1.1.5 on the 8.1 server and then restorethe > database backup. Now I get the error during restore: > pg_restore: [archiver (db)] could not execute query: ERROR: could notfind > function "_Slony_I_terminateNodeConnections" in > file"/usr/lib/postgresql/8.1/lib/slony1_funcs.so" > It seems that the 1.1.5 library is not downward compatible with 1.0.5 schema. > Can someone kindly points out how to achieve the data migration? Ithink one > solution is to drop the replication on the source 7.4database, and then do > the backup. But since it is a productiondatabase, I can't do that. Any other > ideas? > Best Regards, > --Hong Yuan > 大管家网上建材超市装修装潢建材一站式购物http://www.homemaster.cn_______________________________________________Slony1-general > mailing [EMAIL > PROTECTED]://gborg.postgresql.org/mailman/listinfo/slony1-general
There is a script tools/slony1_extract_schema.sh that will allow you to get schema without the slony part from the current origin. That together with a data-only dump of the database should do. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] # _______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
