SkyTools Changelog
What's new in SkyTools 2.1.10
Jan 18, 2011- Features:
- Support Postgres 9.0. (Devrim Gündüz, Jason Buberel, Sébastien Lardière)
- walmgr: Introduce a 'slave_pg_xlog' configuration variable. This allows master and slave pg_xlog files to be in different locations. During restore this directory is symlinked to slave pg_xlog. (Steve Singer)
- walmgr: Introduce a 'backup_datadir' configuration variable to control whether the slave data directory is kept or overwritten during restore. (Steve Singer)
- walmgr: consider wal_level during setup/stop (Martin Pihlak)
- skytools.dbstruct: support version-dependant sql.
- psycopgwrapper: always set db.server_version
- Fixes:
- londiste copy: restore index clustering info. (André Malo)
- londiste repair: use subprocess module instead os.popen4, where available. (Shoaib Mir)
- pgqadm: Remove unnecessary JOIN in refresh_queues(). (Artyom Nosov)
- londiste add: dont send new table/seq list into queue, not useful, only can cause surprise removal in case of several 'provider add'+ 'subscriber add' pairs.
- londiste launcher: don't interpret file 'londiste' as module. Needed for 3.0 compatibility.
- walmgr: "sync" now omits unneeded WAL segments if the database has been cleanly shut down. This greatly reduces sync time during planned switchovers as usually there is only a single WAL file to be synched to slave.
- londiste.link: Add missing quoting. The functions are unused, thus missed the last round of fixes.
- Building from CVS/GIT assumes --with-asciidoc automatically.
- Newer asciidoc/docbook do not need fixman.py hack. Remove it.
New in SkyTools 2.1.10 (Oct 22, 2009)
- pgqadm: rename 'as' function argument as it's keyword in Python 2.6
- londiste provider add-seq:
- Detect existing sequences.
- Make --all ignore pgq, londiste and temp schemas.
- Proper quoting was missing in few places.
- walmgr: Create pg_xlog/archive_status directory for slave restore.
- (Mark Kirkwood)
- londiste provider add: detect and warn about user AFTER triggers
- that run before Londiste one.
- docs:
- Documentation for log_size, log_count and use_skylog options.
- Refresh dependency list, add rsync
- Mention --with-asciidoc in INSTALL.
- --with-asciidoc: make it tolerate missing asciidoc and/or xmlto.
- deb84 Makefile target.
New in SkyTools 2.1.9 (May 13, 2009)
- WalMgr improvements:
- walmgr.py: WAL files purge procedure now pays attention to recovery restart points. (%r patch by Omar Kilani, Mark Kirkwood)
- walmgr.py: archive_mode GUC is now set during setup. Followed by an optional restart if master_restart_cmd is specified (Mark Kirkwood)
- walmgr.py: PostgreSQL configuration files are backed up to "config_backup" and restored to "slave_config_dir". (Mark Kirkwood)
- walmgr.py: Backups taken from slave now generate backup_label and history files.
- walmgr.py Configuration files now default to PostgreSQL 8.3
- Fixes:
- londiste copy: Add missing identifier quoting for TRUNCATE and ADD CONSTRAINT. (Luc Van Hoeylandt)
- Quote identifiers starting with numeric. (Andrew Dunstan)
- Fix crash with pgq.sqltrigq/pgq.logutriga, which automatically detect table structure. Problem was handling table invalidation event during internal query. (Götz Lange, André Malo)
- Fix 'uninitialized variable' warning and potentially bad code in pgq.sqltriga(). (Götz Lange, André Malo)
- skytools._cquoting: Fix crash with Decimal type. (May affects users who have compiled psycopg2 to use Decimal() instead of float for NUMERIC)
- skytools.DBStruct: The DEFAULT keyword was missing when creating table columns with default value. Table creation functionality is unused in 2.1.x thus no users should be affected.
- skytools.magic_insert: be more flexible about whats dict. In particular, now accept DictRow.
- configure.ac: don't detect xmlto and asciidoc version if --with-asciidoc is not used. Otherwise unnecessary error message was printed.
- Add few headers for Postgres 8.4 that are not included automatically anymore. (Devrim Gündüz)