From c5282cba51144d98318c8ef11f6563c896bf52bc Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Mon, 30 Jul 2007 22:58:48 +0000 Subject: [PATCH] another todo update --- doc/TODO.txt | 44 +++++++++++++++++++++++++++++++++++--------- 1 file changed, 35 insertions(+), 9 deletions(-) diff --git a/doc/TODO.txt b/doc/TODO.txt index db223274..b34b300c 100644 --- a/doc/TODO.txt +++ b/doc/TODO.txt @@ -3,10 +3,31 @@ = Next release - 2.1.5 = +== Done == + + * londiste fkeys: look also at dependers not only dependencies. + * pgq.consumer: make queue seeking in case of failover more strict. + * scriptmgr: dont die on user error. + * pgq: there was still fallout from reorg - 2 missing indexes. + * Due to historical reasons SerialConsumer (and thus Londiste) + accessed completed tick table directly, not via functions. + Make it use functions again. + * Support psycopg2, preferring it to psycopg1. + * Improved bulk_loader, using temp tables exclusively. + * skytools.config: API change to allow usage without config file. + * quote_ident(), quote_fqident() + * Rewrite pgq.insert_event() in C, thus PgQ core is not + dependant on PL/Python anymore. + * set client_encoding on subscriber same as on provider + * Write PgQ triggers (pgq.logtriga(), pgq.logutriga(), pgq.sqltriga()) in C. + +== To Do == + * londiste: remove tbl should work also if table is already dropped - * install .sql files under share/skytools in addition to contrib/ - * add , remove - * londiste: install --connstr= + * install .sql files under share/skytools in addition to contrib/ [marko] + * add , remove [marko] + * londiste: install --connstr= [dimitri] + * pgq/londiste/pgq_ext: schema upgrade scripts [marko] = High-prority = @@ -14,12 +35,11 @@ == Larger things == - * chained replication, switchover - * Write PgQ triggers (pgq.logtriga(), pgq.logutriga(), pgq.sqltriga()) in C + * cascaded replication, switchover, failover [marko] == Smaller things == - * pgq: RemoteConsumer/SerialConsumer/pgq_ext sanity, too much duplication + * pgq: RemoteConsumer/SerialConsumer/pgq_ext sanity, too much duplication [marko] * backend modules need to be ported to 8.3 * londiste: create tables on subscriber * pgqadm: Utility commands: @@ -34,6 +54,7 @@ * check if copy is running (lag?) * count of tables done, count of unsynced * table in the middle of copy + * londiste: provider add/remove --all [hans] = Low-priority = @@ -41,11 +62,13 @@ * londiste: denytriggers on subscriber * londiste: Quote SQL identifiers, keep combined name, rule will be "Split schema as first dot" - * londiste: good fkey support: store them in subscriber db and apply when both tables are in sync. + * londiste: good fkey support: store them in subscriber db and apply when both tables are in sync. [erik] * skylog: publish sample logdb schema, with some tools * londiste: allow table redirection on subscriber side - * londiste: trigger handling - switches to "subscriber add" - * londiste: "triggers" command that prints create/drop sql + * londiste: trigger handling + * `copy` drops triggers uncontitionally (except maybe disabled triggers in 8.3) + * there are "show-triggers" and "restore-triggers" commands that help + admin to review them, take manual action if needed and restore the trigger == Smaller things == @@ -64,12 +87,15 @@ * several consumer can be done in one go if spread out to separate columns * inexact method: take ev_id near xmax and compare with value from sequence * broken by retry events, rollbacked transactions and use of force_tick() + * automatic "repair" - after reaching sync point, the "replay" must be killed, then fixes can be applied = Just ideas = * skytools: config-less operation? * skytools: config from database? * skytools: partial sql parser for log processing + * londiste: EXECUTE SCRIPT + * londiste: somehow automatic sync of table structure/functions/...? = walmgr = -- 2.39.5