User Tools

Site Tools


doc:appunti:linux:sa:mediawiki_upgrade_dblist_filter
#!/bin/sh
#
# Read from input a list of database objects from a MediaWiki PostgreSQL 8.2 dump.
# Write in output the list to be restored in PostgreSQL 8.3 (remove tsearch2 objects). 
#
# MediaWiki functions ts2_page_title() and ts2_page_text() are obsolete and
# filtered-out, they must be recreated separately.
#
cat \
    | grep -v 'ACL - public' \
    | grep -v 'AGGREGATE public .*tsquery' \
    | grep -v 'COMMENT public .*tsvector' \
    | grep -v 'COMMENT - SCHEMA public' \
    | grep -v 'FUNCTION public dex_' \
    | grep -v 'FUNCTION public _get_parser' \
    | grep -v 'FUNCTION public gin_' \
    | grep -v 'FUNCTION public gts' \
    | grep -v 'FUNCTION public lex' \
    | grep -v 'FUNCTION public numnode' \
    | grep -v 'FUNCTION public parse' \
    | grep -v 'FUNCTION public plainto_' \
    | grep -v 'FUNCTION public prsd_' \
    | grep -v 'FUNCTION public set_cur' \
    | grep -v 'FUNCTION public show_curcfg' \
    | grep -v 'FUNCTION public snb_' \
    | grep -v 'FUNCTION public spell_' \
    | grep -v 'FUNCTION public stat' \
    | grep -v 'FUNCTION public syn_' \
    | grep -v 'FUNCTION public thesaurus_' \
    | grep -v 'FUNCTION public token_' \
    | grep -v 'FUNCTION public ts' \
    | grep -v 'FUNCTION public .*tsearch' \
    | grep -v 'FUNCTION public .*tsquery' \
    | grep -v 'FUNCTION public .*tsvector' \
    | grep -v 'OPERATOR CLASS public gin_' \
    | grep -v 'OPERATOR CLASS public gist_' \
    | grep -v 'OPERATOR CLASS public ts' \
    | grep -v 'OPERATOR public .* postgres' \
    | grep -v 'PROCEDURAL LANGUAGE - plpgsql' \
    | grep -v 'SCHEMA - public' \
    | grep -v 'SHELL TYPE public gts' \
    | grep -v 'SHELL TYPE public ts' \
    | grep -v 'SHELL TYPE public tsquery' \
    | grep -v 'TABLE DATA public pg_ts_' \
    | grep -v 'TYPE public gts' \
    | grep -v 'TYPE public statinfo' \
    | grep -v 'TYPE public token' \
    | grep -v 'TYPE public ts'
doc/appunti/linux/sa/mediawiki_upgrade_dblist_filter.txt · Last modified: 2008/08/29 19:42 by 127.0.0.1