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 <[email protected]> > > 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 <[email protected]> > -- 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."
