Jeff Frost wrote:
> On Wed, 2 Apr 2008, Craig James wrote:
> 
>> I have since double checked everything.  There is no Slony schema on 
>> either database:
>>
>> select * from pg_tables where tableowner = 'postgres'
>>
>> shows now sl_* tables at all.  So there is no old version of Slony.  
>> This seems to be coming from the Slony 1.2.13 installation itself.
>>
>> Can anyone shed any light on this?  In case anyone is still awake, I 
>> was hoping to get the thing started tonight.
> 
> Craig,
> 
> Look in your postgresql libdir for xxid.so.  That could be in 
> /usr/lib/pgsql or /usr/lib64/pgsql or /usr/local/pgsql/lib, etc 
> depending on how it was installed.

But what am I looking for?  There are no other slony libraries -- this system has never had any other version of Slony on it.

If I remove xxid.so, and everything else slony-related in /usr/local/pgsql/*, INCLUDING all of the sql files in /usr/local/pgsql/share, and then

  cd slony-1.2.13
  make install

then all the files are restored, including xxid.so.  But the problem persists -- same error.

<stdin>:5: loading of file /usr/local/pgsql/share/slony1_funcs.sql: PGRES_FATAL_ERROR ERROR:  Slonik version: 1.2.13 != Slony-I version in PG build 1.2.9
ERROR:  Slonik version: 1.2.13 != Slony-I version in PG build 1.2.9
<stdin>:5: ERROR: no admin conninfo for node 0


> BTW, if this is a brand new server, 
> why not start with postgresql 8.3.1 instead of 8.3.0?

I'll upgrade soon ... we must have got the system just before the 8.3.1 release last month.  In the mean time ...

Thanks,
Craig