Reference

REPAIR_CONFIG(7)

Resets the name-to-oid mapping of tables in a replication set, useful for restoring a node after a pg_dump.

NAME

REPAIR CONFIG - Resets the name-to-oid mapping of tables in a replication set, useful for restoring a node after a pg_dump.

SYNOPSIS

REPAIR CONFIG (options);

DESCRIPTION

Resets name-to-oid mapping.

FCSET ID = ival F[0]

Which set to clean up after.

FCEVENT NODE = ival F[0]

The node ID where this should be submitted.

FCEXECUTE ONLY ON = ival F[0]

The ID of the only node where the mappings are to be updated. If not specified, the default is to execute this on all nodes subscribed to the set.

EXAMPLE

FCREPAIR CONFIG (
  SET ID = 1,
  EVENT NODE = 2
);
    F[0]

LOCKING BEHAVIOUR

No application-visible locking should take place.

VERSION INFORMATION

This command was introduced in Slony-I 1.1

History