Glyn Astill glynastill at yahoo.co.uk
Tue Sep 30 13:17:33 PDT 2008
> <stdin>:7: PGRES_FATAL_ERROR select
> "_mycluster".moveSet(1, 2);  -
> ERROR:  Slony-I: alterTableRestore(): Table with id 84 not
> found
> CONTEXT:  SQL statement "SELECT 
> "_mycluster".alterTableRestore( $1 )"
> PL/pgSQL function "moveset_int" line 33 at
> perform
> SQL statement "SELECT 
> "_mycluster".moveSet_int( $1 ,  $2 ,  $3 ,
> 0)"
> PL/pgSQL function "moveset" line 61 at perform
> 
> Someone deleted that table at some point and now I
> can't move the set
> and I can't unsubscribe the set.  It didn't seem
> like I could do
> anything at this point besides manually strip out the
> cluster schema and
> start over.  So my first question is if there are any other
> options at
> this point?
> 

You could give REPAIR CONFIG a try

http://slony.info/documentation/stmtrepairconfig.html


      


More information about the Slony1-general mailing list