Jaime Casanova jaime at 2ndquadrant.com
Wed May 26 18:26:39 PDT 2010
On Wed, May 26, 2010 at 4:13 PM, "Stéphane A. Schildknecht"
<stephane.schildknecht at postgresql.fr> wrote:
>
> Could you check that this table is in sl_tables, and in which set it is ?
>
> Maybe this set isn't subscribed.
>

or maybe the table has the wrong tab_reloid in the slave. you can
probe that with this simple query (the same for sequences):
select * from _cluster_name.sl_table where tab_reloid <> (tab_nspname
|| '.' || tab_relname)::regclass;

-- 
Jaime Casanova         www.2ndQuadrant.com
Soporte y capacitación de PostgreSQL


More information about the Slony1-general mailing list