Thread: ERROR: incompatible library
<div class="Section1"><p class="MsoNormal">Hello lists,<p class="MsoNormal"> <p class="MsoNormal">I am trying to run Slonyon a Master Postgres 8.1.11 replicating to a Slave same version and 2<sup>nd</sup> Slave Postgres 8.3.4.<p class="MsoNormal">Thepurpose is to update Postgres in production by steps, first slaves then switchover to upgrade the masterthat will not be master when upgraded.<p class="MsoNormal"> <p class="MsoNormal">I am getting the following error:<pclass="MsoNormal"> <p class="MsoNormal"><span style="font-family:"Courier New""><stdin>:14: PGRES_FATAL_ERRORload '$libdir/xxid'; - ERROR: incompatible library "/usr/lib/pgsql/xxid.so": missing magic block</span><pclass="MsoNormal"><span style="font-family:"Courier New"">HINT: Extension libraries are required to use thePG_MODULE_MAGIC macro.</span><p class="MsoNormal"><span style="font-family:"Courier New""><stdin>:14: Error: theextension for the xxid data type cannot be loaded in database 'dbname=hdap host=10.0.100.234 port=6543 user=myuser password=mp’</span><pclass="MsoNormal"><span style="font-family:"Courier New""> </span><p class="MsoNormal"><span style="font-family:"CourierNew""> </span><p class="MsoNormal"><span style="font-family:"Courier New"">Is this mean that Slonycan not replicate into a newer postgres version?</span><p class="MsoNormal"><span style="font-family:"Courier New"">Ifit does, then how do I fix this problem?</span><p class="MsoNormal"><span style="font-family:"Courier New""> </span><pclass="MsoNormal"><span style="font-family:"Courier New"">Thanks for your help,</span><p class="MsoNormal"><spanstyle="font-family:"Courier New""> </span><p class="MsoNormal"><span style="font-family:"Courier New"">TonyFernandez</span></div>
--- On Wed, 12/11/08, Tony Fernandez <Tony.Fernandez@vocalocity.com> wrote: > Date: Wednesday, 12 November, 2008, 10:52 PM > Hello lists, > > > > I am trying to run Slony on a Master Postgres 8.1.11 > replicating to a > Slave same version and 2nd Slave Postgres 8.3.4. > > I am getting the following error: > > > > <stdin>:14: PGRES_FATAL_ERROR load > '$libdir/xxid'; - ERROR: > incompatible library "/usr/lib/pgsql/xxid.so": > missing magic block > > HINT: Extension libraries are required to use the > PG_MODULE_MAGIC > macro. > > <stdin>:14: Error: the extension for the xxid data > type cannot be loaded > in database 'dbname=hdap host=10.0.100.234 port=6543 > user=myuser > password=mp' I think you've proabably built slony against one version of postgres and then tried to use it with another. You must buildagainst 8.1.11 and then separately for 8.3.4, using the same version of slony ofcourse.