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 listSlony1-general at gborg.postgresql.orghttp://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.                                  #
#================================================== JanWieck at Yahoo.com #