Re: Slony

Estimados, seguramente para vosotros esto es coser y cantar pero soy novato
y seguro meto la para

Veo que hay 135 funciones en el catálogo Slony Cluster de la base de datos

¿Como se comprueba que nadie las use? ¿Funciones de la base de datos?

En esta relación veo que todas tienen un comentario excepto las que
comienzan por xxid...

add_empty_table_to_replication(integer, integer, text, text, text, text)
postgres Verify that a table is empty, and add it to replication. ...
add_missing_table_field(text, text, text, text) postgres Add a column of a
given type to a table if it is missing
addpartiallogindices() postgres Add partial indexes, if possible, to the
unused sl_log_? table for...
altertableforreplication(integer) postgres
alterTableForReplication(tab_id)...
altertablerestore(integer) postgres alterTableRestore (tab_id)...
btxxidcmp(_slony_questionity.xxid, _slony_questionity.xxid) postgres
checkmoduleversion() postgres Inline test function that verifies that
slonik request for STORE...
cleanupevent() postgres cleaning old data out of sl_confirm, sl_event.
Removes all but the...
cleanupnodelock() postgres Clean up stale entries when restarting slon
copyfields(integer) postgres Return a string consisting of what should be
appended to a COPY statement...
createevent(name, text, text, text, text, text, text, text, text)
postgres FUNCTION
createEvent (cluster_name, ev_type [, ev_data [...]])...
createevent(name, text, text, text) postgres FUNCTION createEvent
(cluster_name, ev_type [, ev_data [...]])...
createevent(name, text, text, text, text) postgres FUNCTION createEvent
(cluster_name, ev_type [, ev_data [...]])...
createevent(name, text, text, text, text, text) postgres FUNCTION
createEvent (cluster_name, ev_type [, ev_data [...]])...
createevent(name, text, text, text, text, text, text) postgres FUNCTION
createEvent (cluster_name, ev_type [, ev_data [...]])...
createevent(name, text, text, text, text, text, text, text) postgres FUNCTION
createEvent (cluster_name, ev_type [, ev_data [...]])...
createevent(name, text, text, text, text, text, text, text, text, text)
postgres FUNCTION createEvent (cluster_name, ev_type [, ev_data [...]])...
createevent(name, text) postgres FUNCTION createEvent (cluster_name,
ev_type [, ev_data [...]])...
createevent(name, text, text) postgres FUNCTION createEvent (cluster_name,
ev_type [, ev_data [...]])...
ddlscript_complete(integer, text, integer) postgres ddlScript_complete(set_id,
script, only_on_node)...
ddlscript_complete_int(integer, integer) postgres
ddlScript_complete_int(set_id,
script, only_on_node)...
ddlscript_prepare(integer, integer) postgres Prepare for DDL script
execution on origin
ddlscript_prepare_int(integer, integer) postgres ddlScript_prepare_int
(set_id, only_on_node)...
determineattkindserial(text) postgres determineAttKindSerial (tab_fqname)...
determineattkindunique(text, name) postgres determineAttKindUnique
(tab_fqname, indexname)...
determineidxnameserial(text) postgres determineIdxnameSerial (tab_fqname)...
determineidxnameunique(text, name) postgres FUNCTION determineIdxnameUnique
(tab_fqname, indexname)...
disablenode(integer) postgres process DISABLE_NODE event for node no_id...
disablenode_int(integer) postgres
drop_if_exists(text, text) postgres Emulate DROP FUNCTION IF EXISTS, which
does not exist in 7.4, 8.0, 8.1
droplisten(integer, integer, integer) postgres dropListen (li_origin,
li_provider, li_receiver)...
droplisten_int(integer, integer, integer) postgres dropListen (li_origin,
li_provider, li_receiver)...
dropnode(integer) postgres generate DROP_NODE event to drop node node_id
from replication
dropnode_int(integer) postgres internal function to process DROP_NODE event
to drop node node_id from replication
droppath(integer, integer) postgres Generate DROP_PATH event to drop path
from pa_server to pa_client
droppath_int(integer, integer) postgres Process DROP_PATH event to drop
path from pa_server to pa_client
dropset(integer) postgres Process DROP_SET event to drop replication of set
set_id. This involves:...
dropset_int(integer) postgres
droptrigger(integer, name) postgres dropTrigger (trig_tabid, trig_tgname)...
droptrigger_int(integer, name) postgres dropTrigger_int (trig_tabid,
trig_tgname)...
enablenode(integer) postgres no_id - Node ID #...
enablenode_int(integer) postgres no_id - Node ID #...
enablesubscription(integer, integer, integer) postgres enableSubscription
(sub_set, sub_provider, sub_receiver)...
enablesubscription_int(integer, integer, integer) postgres
enableSubscription_int
(sub_set, sub_provider, sub_receiver)...
failednode(integer, integer) postgres Initiate failover from failed_node to
backup_node. This function must be called on all nodes, ...
failednode2(integer, integer, integer, bigint, bigint) postgres FUNCTION
failedNode2 (failed_node, backup_node, set_id, ev_seqno, ev_seqfake)...
failoverset_int(integer, integer, integer, bigint) postgres FUNCTION
failoverSet_int (failed_node, backup_node, set_id, wait_seqno)...
finishtableaftercopy(integer) postgres Reenable index maintenance and
reindex the table
forwardconfirm(integer, integer, bigint, timestamp without time zone)
postgres forwardConfirm (p_con_origin, p_con_received, p_con_seqno,
p_con_timestamp)...
generate_sync_event(interval) postgres Generate a sync event if there has
not been one in the requested interval.
getcurrentxid() postgres
getlocalnodeid(name) postgres Returns the node ID of the node being
serviced on the local database
getmaxxid() postgres
getminxid() postgres
getmoduleversion() postgres Returns the compiled-in version number of the
Slony-I shared object
getsessionrole(name) postgres not yet documented
initializelocalnode(integer, text) postgres no_id - Node ID #...
killbackend(integer, text) postgres Send a signal to a postgres process.
Requires superuser rights
lockset(integer) postgres lockSet(set_id)...
logswitch_finish() postgres logswitch_finish()...
logswitch_start() postgres logswitch_start()...
logswitch_weekly() postgres logswitch_weekly()...
make_function_strict(text, text) postgres Equivalent to 8.1+ ALTER FUNCTION
... STRICT
mergeset(integer, integer) postgres Generate MERGE_SET event to request
that sets be merged together....
mergeset_int(integer, integer) postgres mergeSet_int(set_id, add_id) -
Perform MERGE_SET event, merging all objects from ...
moveset(integer, integer) postgres moveSet(set_id, new_origin)...
moveset_int(integer, integer, integer, bigint) postgres moveSet(set_id,
old_origin, new_origin, wait_seqno)...
pre74() postgres Returns 1/0 based on whether or not the DB is running a...
preparetableforcopy(integer) postgres Delete all data and suppress index
maintenance
reachablefromnode(integer, integer[]) postgres ReachableFromNode(receiver,
blacklist)...
rebuildlistenentries() postgres RebuildListenEntries()...
registernodeconnection(integer) postgres Register (uniquely) the node
connection so that only one slon can service the node
registry_get_int4(text, integer) postgres registry_get_int4(key, value)...
registry_get_text(text, text) postgres registry_get_text(key, value)...
registry_get_timestamp(text, timestamp without time zone) postgres
registry_get_timestamp(key,
value)...
registry_set_int4(text, integer) postgres registry_set_int4(key, value)...
registry_set_text(text, text) postgres registry_set_text(key, value)...
registry_set_timestamp(text, timestamp without time zone) postgres
registry_set_timestamp(key,
value)...
replicate_partition(integer, text, text, text, text) postgres Add a
partition table to replication....
sequencelastvalue(text) postgres sequenceLastValue(p_seqname)...
sequencesetvalue(integer, integer, bigint, bigint) postgres sequenceSetValue
(seq_id, seq_origin, ev_seqno, last_value)...
setaddsequence(integer, integer, text, text) postgres setAddSequence
(set_id, seq_id, seq_fqname, seq_comment)...
setaddsequence_int(integer, integer, text, text) postgres setAddSequence_int
(set_id, seq_id, seq_fqname, seq_comment)...
setaddtable(integer, integer, text, name, text) postgres setAddTable
(set_id, tab_id, tab_fqname, tab_idxname, tab_comment)...
setaddtable_int(integer, integer, text, name, text) postgres setAddTable_int
(set_id, tab_id, tab_fqname, tab_idxname, tab_comment)...
setdropsequence(integer) postgres setDropSequence (seq_id)...
setdropsequence_int(integer) postgres setDropSequence_int (seq_id)...
setdroptable(integer) postgres setDropTable (tab_id)...
setdroptable_int(integer) postgres setDropTable_int (tab_id)...
setmovesequence(integer, integer) postgres setMoveSequence(p_seq_id,
p_new_set_id) - This generates the...
setmovesequence_int(integer, integer) postgres setMoveSequence_int(p_seq_id,
p_new_set_id) - processes the...
setmovetable(integer, integer) postgres This processes the SET_MOVE_TABLE
event. The table is moved ...
setmovetable_int(integer, integer) postgres
setsessionrole(name, text) postgres setSessionRole(username, role) - set
role for session....
slon_quote_brute(text) postgres Brutally quote the given text
slon_quote_input(text) postgres quote all words that aren't quoted yet
slonyversion() postgres Returns the version number of the slony schema
slonyversionmajor() postgres Returns the major version number of the slony
schema
slonyversionminor() postgres Returns the minor version number of the slony
schema
slonyversionpatchlevel() postgres Returns the version patch level of the
slony schema
storelisten(integer, integer, integer) postgres FUNCTION storeListen
(li_origin, li_provider, li_receiver)...
storelisten_int(integer, integer, integer) postgres FUNCTION
storeListen_int (li_origin, li_provider, li_receiver)...
storenode(integer, text, boolean) postgres no_id - Node ID #...
storenode_int(integer, text, boolean) postgres no_id - Node ID #...
storepath(integer, integer, text, integer) postgres FUNCTION storePath
(pa_server, pa_client, pa_conninfo, pa_connretry)...
storepath_int(integer, integer, text, integer) postgres FUNCTION storePath
(pa_server, pa_client, pa_conninfo, pa_connretry)...
storeset(integer, text) postgres Generate STORE_SET event for set set_id
with human readable comment set_comment
storeset_int(integer, integer, text) postgres storeSet_int (set_id,
set_origin, set_comment)...
storetrigger(integer, name) postgres storeTrigger (trig_tabid,
trig_tgname)...
storetrigger_int(integer, name) postgres storeTrigger_int (trig_tabid,
trig_tgname)...
subscribeset(integer, integer, integer, boolean) postgres subscribeSet
(sub_set, sub_provider, sub_receiver, sub_forward)...
subscribeset_int(integer, integer, integer, boolean) postgres subscribeSet_int
(sub_set, sub_provider, sub_receiver, sub_forward)...
tableaddkey(text) postgres tableAddKey (tab_fqname) - if the table has not
got a column of the...
tabledropkey(integer) postgres tableDropKey (tab_id)...
tablehasserialkey(text) postgres tableHasSerialKey (tab_fqname)...
terminatenodeconnections(integer) postgres terminates all backends that
have registered to be from the given node
uninstallnode() postgres Reset the whole database to standalone by removing
the whole...
unlockset(integer) postgres Remove the special trigger from all tables of a
set that disables access to it.
unsubscribeset(integer, integer) postgres unsubscribeSet (sub_set,
sub_receiver) ...
unsubscribeset_int(integer, integer) postgres unsubscribeSet_int (sub_set,
sub_receiver)...
updaterelname(integer, integer) postgres updateRelname(set_id, only_on_node)
updatereloid(integer, integer) postgres updateReloid(set_id,
only_on_node)...
upgradeschema(text) postgres Called during "update functions" by slonik to
perform schema changes
xxid_ge_snapshot(_slony_questionity.xxid, _slony_questionity.xxid_snapshot)
postgres
xxid_lt_snapshot(_slony_questionity.xxid, _slony_questionity.xxid_snapshot)
postgres
xxid_snapshot_in(cstring) postgres
xxid_snapshot_out(_slony_questionity.xxid_snapshot) postgres
xxideq(_slony_questionity.xxid, _slony_questionity.xxid) postgres
xxidge(_slony_questionity.xxid, _slony_questionity.xxid) postgres
xxidgt(_slony_questionity.xxid, _slony_questionity.xxid) postgres
xxidin(cstring) postgres
xxidle(_slony_questionity.xxid, _slony_questionity.xxid) postgres
xxidlt(_slony_questionity.xxid, _slony_questionity.xxid) postgres
xxidne(_slony_questionity.xxid, _slony_questionity.xxid) postgres
xxidout(_slony_questionity.xxid) postgres

2011/11/22 Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>

>
> Excerpts from felipe fernandez's message of mar nov 22 18:45:44 -0300 2011:
> > select * from pg_proc where proname like '%xxid%'
> >
> > *resultado *
> > "xxidgt"
> > "xxidge"
> > "btxxidcmp"
> > "getmaxxid"
> > "xxid_snapshot_in"
> > "xxidin"
> > "xxidout"
> > "xxideq"
> > "xxidne"
> > "xxid_snapshot_out"
> > "xxidlt"
> > "xxidle"
> > "xxid_lt_snapshot"
> > "xxid_ge_snapshot"
>
> Podrías partir borrando todas esas funciones ... pero asegúrate que
> nadie las usa.
>
> --
> Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
>

--
Salu2

Felipe Fernández Rguez
"Uno se alegra de resultar útil" Andrew Martin "El hombre bicentenario"
Isaac Asimov.
"Documentation is like sex: when it is good, it is very, very good; and
when it is bad, it is better than nothing."