I had to submit it to the same node it was applied on. Still getting 
some error and investiguating...

Glyn Astill a écrit :
> I'm not sure why repair config isn't working for you, however if you're looking for the baremetal function it is updatereloid(set, node).
>
>
>
>
>
> ----- Original Message ----
>   
>> From: Cyril Scetbon <cscetbon.ext at orange-ftgroup.com>
>> To: chris <chris at ca.afilias.info>; slony1-general at lists.slony.info
>> Sent: Tuesday, 11 August, 2009 10:48:18
>> Subject: Re: [Slony1-general] Replacing PostgreSQL 8.2 by Pg 8.3 does not work
>>
>> Outch I can't dump the table oid (misunderstand between table oids and column 
>> oids). I'll look at the slonik code for the repair command.
>>
>> Cyril Scetbon a écrit :
>>     
>>> you are right !
>>>
>>> mydb=# select oid,relname from pg_class where relname = 't_512';
>>>  oid  | relname
>>> -------+---------
>>> 69187 | t_512
>>> (1 row)
>>>
>>> mydb=# select * from _pns_slony_voila_preprod_1.sl_table where 
>>>       
>> tab_relname='t_512';
>>     
>>> tab_id | tab_reloid | tab_relname | tab_nspname | tab_set | tab_idxname | 
>>>       
>> tab_altered |             tab_comment            
>> --------+------------+-------------+-------------+---------+-------------+-------------+------------------------------------- 
>>
>>     
>>>    512 |      24638 | t_512       | public      |       1 | t_512_pkey  | t    
>>>       
>>        | Table public.t_512 with primary key
>>     
>>> (1 row)
>>>
>>> But, repair does not work correctly, and I can't debug it (tried by looking in 
>>>       
>> the postgresql query log, but found nothing)
>>     
>>> I'll try by dumping/reloading with oid. Any idea why the repair command does 
>>>       
>> not work correctly ? I don't see updates on the node I want to be repaired. I 
>> used the following script :
>>     
>>> echo > /var/tmp/repair.sql
>>> slonik_print_preamble --config /etc/slony1/slon_tools_mydb.conf >> 
>>>       
>> /var/tmp/repair.sql
>>     
>>> for set in `seq 1 31`
>>> do
>>>  echo "REPAIR CONFIG (SET ID = $set, EVENT NODE = 101, EXECUTE ONLY ON =103);" 
>>>       
>>>> /var/tmp/repair.sql
>>>>         
>>> done
>>> slonik < /var/tmp/repair.sql
>>>
>>> I got no error but nothing seems to be done
>>>
>>> thx
>>>
>>> chris a écrit :
>>>       
>>>> Cyril Scetbon writes:
>>>>  
>>>>         
>>>>> Alan Hodgson a écrit :
>>>>>    
>>>>>           
>>>>>> On Monday 10 August 2009, Cyril Scetbon
>>>>>> wrote:
>>>>>>        
>>>>>>             
>>>>>>> However, when slony is started with pg 8.3 it does not see new events
>>>>>>> from his provider (still in pg8.3).
>>>>>>> If we restart our pg 8.2 with slony it works !
>>>>>>>
>>>>>>> Do you know what we are missing ?
>>>>>>>
>>>>>>> thx
>>>>>>>            
>>>>>>>               
>>>>>> You need to modify all the table and sequence OIDs stored in the
>>>>>> slony configuration tables to reflect the new table and sequence
>>>>>> OIDs.
>>>>>>        
>>>>>>             
>>>>> I don't think oids are used and table id were not modified
>>>>>    
>>>>>           
>>>> No, Alan's quite right.
>>>>
>>>> If you look at sl_table and sl_sequence, you'll find "reloid" columns,
>>>> which are indeed relevant.
>>>>
>>>>  
>>>>         
>>>>>> You need to update the slony functions through the appropriate slon
>>>>>> commands.
>>>>>>        
>>>>>>             
>>>>> really ?
>>>>>    
>>>>>           
>>>> The slonik "repair config" command should be useful.
>>>>
>>>>
>>>>
>>>> "Resets the name-to-oid mapping of tables in a replication set, useful
>>>> for restoring a node after a pg_dump."
>>>>  
>>>>         
>> -- Cyril SCETBON
>> _______________________________________________
>> Slony1-general mailing list
>> Slony1-general at lists.slony.info
>> http://lists.slony.info/mailman/listinfo/slony1-general
>>     
>
>
>
>       
>   

-- 
Cyril SCETBON - Ingénieur bases de données
Cellule bases de données
AUSY pour France Télécom - OPF/PORTAILS/DOP/HEBEX

Tél : +33 (0)4 97 12 87 60
Jabber : cscetbon at jabber.org
France Telecom - Orange
790 Avenue du Docteur Maurice Donat 
Bâtiment Marco Polo C1 - Bureau 202
06250 Mougins
France

***********************************
Ce message et toutes les pieces jointes (ci-apres le 'message') sont
confidentiels et etablis a l'intention exclusive de ses destinataires.
Toute utilisation ou diffusion non autorisee est interdite.
Tout message electronique est susceptible d'alteration. Le Groupe France
Telecom decline toute responsabilite au titre de ce message s'il a ete
altere, deforme ou falsifie.
Si vous n'etes pas destinataire de ce message, merci de le detruire
immediatement et d'avertir l'expediteur.
***********************************
This message and any attachments (the 'message') are confidential and
intended solely for the addressees.
Any unauthorised use or dissemination is prohibited.
Messages are susceptible to alteration. France Telecom Group shall not be
liable for the message if altered, changed or falsified.
If you are not recipient of this message, please cancel it immediately and
inform the sender.
************************************