Skytools3Todo

Skytools 3 TODO

Currently this page is used for documentation coordination, later for other stuff too.

Documentation

Generic stuff

Skytools package overview

http://skytools.projects.postgresql.org/skytools-3.0/doc/README.html

pgq overview

• db side queue
• producer, consumer, ticker
• batches

londiste overview

• pgq consumer
• trigger-based
• handlers?
• lazy copy?

User howtos: Londiste

How to set up simple replication

• Set up provider and subscriber
• Adding/removing tables
• mention that tables are copied one-by-one, but fkeys will still work

How to set up cascaded replicaiton

• setting up cascaded replication
• change-provider
• takeover
• status

How to set up table partitioning (handlers)

• Usage of existing handlers

How to merge partitioned database

• Set up partitions
• Set up merged database
• Set up replication

Script manpages

londiste

• sub-command reference docs

walmgr

http://skytools.projects.postgresql.org/skytools-3.0/doc/walmgr.html

qadmin

http://skytools.projects.postgresql.org/skytools-3.0/doc/qadmin.html

SQL API docs

Most functions have docstrings, although some of them may be quite light.

Needed is intro for each module, why is it for, and overview of technical design.

pgq SQL API

• pgq

pgq_coop SQL API

• pgq_coop

pgq_node SQL API

• pgq_node

pgq_ext SQL API

• Intro about task it does: pgq-nodupes.html
• Needs docstrings to couple functions

londiste SQL API

• londiste

Python API docs

• skytools, pgq, londiste: http://skytools.projects.postgresql.org/skytools-3.0/api/