Tue Aug 11 02:29:06 PDT 2009
- Previous message: [Slony1-general] Replacing PostgreSQL 8.2 by Pg 8.3 does not work
- Next message: [Slony1-general] Replacing PostgreSQL 8.2 by Pg 8.3 does not work
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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 <cscetbon.ext at orange-ftgroup.com> writes: > >> Alan Hodgson a écrit : >> >>> On Monday 10 August 2009, Cyril Scetbon >>> <cscetbon.ext at orange-ftgroup.com> 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. > > <http://main.slony.info/documentation/stmtrepairconfig.html> > > "Resets the name-to-oid mapping of tables in a replication set, useful > for restoring a node after a pg_dump." > -- Cyril SCETBON
- Previous message: [Slony1-general] Replacing PostgreSQL 8.2 by Pg 8.3 does not work
- Next message: [Slony1-general] Replacing PostgreSQL 8.2 by Pg 8.3 does not work
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list