summaryrefslogtreecommitdiff
path: root/python/walmgr.py
AgeCommit message (Collapse)Author
2014-10-06walmgr: ignore .history files when removing PG_RECEIVEXLOG fileTarvi Pillessaar
PG_RECEIVEXLOG got removed too early due to .history files that were not present
2013-07-09walmgr: new command createslave and new option --synch-standbyTarvi Pillessaar
2013-03-05Merge branch 'master' of https://github.com/markokr/skytoolsTarvi Pillessaar
2013-03-05walmgr: small loglevel changesTarvi Pillessaar
2013-02-23walmgr: sweeping change to postpone log string formattingmartinko
2012-11-02Merge remote-tracking branch 'intgit/master'Marko Kreen
2012-10-24remove a stray tab.Martin Pihlak
2012-10-24Move set_last_complete AFTER rsync.Martin Pihlak
Previously .walshipping.last was updated before the rsync succeeded, it turns out that this was too optimistic -- occasionally the rsync fails and the .last file contains wrong information. This results in skipped files during "master sync".
2012-10-18walmgr: drop reference to traceback objectMarko Kreen
2012-08-16Merge branch 'master' of internal-git:/git/dba/skytools-3Martin Pihlak
2012-08-16Don't complain if a nonexistent WAL file is encountered during cleanup.Martin Pihlak
This is to avoid crashes when some cleanup command (such as pg_archivecleanup) has already removed the wal files.
2012-05-11Merge branch 'master' of internal-git:/git/dba/skytools-3Tarvi Pillessaar
2012-05-10walmgr: fix backup from slaveSergey Burladyan
Current version improperly remove needed WAL files when creating backup from slave. The minimum WAL file is file with REDO record, not with latest checkpoint itself.
2012-05-05walmgr: add option for init-slave to add password from file to .pgpassTarvi Pillessaar
walmgr: add command synch-standby
2011-11-25python/walmngr.py: update help and usageCédric Villemain
Add the xpartialsync command description and remove the -n switch from usage (it is already present in --help)
2011-11-10Master xarchive now runs "sync" on slave.Martin Pihlak
This is an attempt at minimizing the chance of WAL file corruption on slave server crash -- master xarchive command does not return success until the the buffers on slave have been flushed to disk.
2011-10-14reset synchronous_standby_names on walmgr "stop".Martin Pihlak
2011-10-14add "pg_archivecleanup" to recovery.conf.Martin Pihlak
2011-10-14add "primary_conninfo" option to --init-slaveMartin Pihlak
2011-10-14added init.d script guessing.Martin Pihlak
2011-10-13Fix invalid reference to os.path.mkdirMartin Pihlak
2011-09-21Fix a bug introduced by a bugfix b08445.Martin Pihlak
2011-04-27fixed failed sync exit codeTarvi Pillessaar
2011-04-04Added "compression" to master config template.Martin Pihlak
2011-04-01ignore missing authorized_keys file on wal slave cleanup.Martin Pihlak
2011-03-24fix pid writing in slave xlock.Martin Pihlak
Slave xlock should not attempt to write pid to BACKUPLOCK if none was specified on command line.
2011-03-18fix --ssh-add-key with missing authorized_keys fileMartin Pihlak
2011-03-17Couple of bugfixes for stale backup lock handling.Martin Pihlak
2011-03-17Move the pg_stop_backup() into a finally: block.Steve Singer
Some instances were reported where the base backup failed with some issue but pg_stop_backup() hadn't been called and had to be called manually. This should make that less likely
2011-03-17Add support for detecting stale locks and releasing them instead of abortingSteve Singer
2011-03-16walmgr.py: add "cleanup" commandMartin Pihlak
2011-02-09SSH batch mode and no strict host checking for remote_walmgrMartin Pihlak
2011-02-09Create log,pid,conf directories during --initMartin Pihlak
2011-01-22Tweaking --init to work on custom postgres setupMartin Pihlak
2011-01-21Added --init-X commands to simplify walmgr setup.Martin Pihlak
- Both wal-master and slave now use [walmgr] configuration section. - Added --init-master and --init-slave command to set up configuration files. - Various path are guessed from PGDATA, optionally override with --set X=Y - "slave" config key in wal-master.ini now only contains hostname - "slave" config key in wal-slave.ini has been replaced with walmgr_data - ssh-keygen option to init-master, ssh-add-key option to init-slave - most of the cf.get() calls for directories have been replaced with cf.getfile()
2011-01-18Ignore pgsql_tmp directory while creating base backup.Martin Pihlak
bug reported by Guillaume Smet
2011-01-13Fix "walmgr stop" not to disable archive_mode.Martin Pihlak
That is, unless master_restart_cmd is defined.
2010-12-09Allow "primary_conninfo" to be specified in wal-slave.iniMartin Pihlak
Based on a patch by Mark Kirkwood.
2010-12-09Some adjustments for 9.0, wal_level GUC is also modified during setup/stop.Martin Pihlak
2010-07-27Introduce a 'slave_pg_xlog' configuration variable. ThisMartin Pihlak
allows master and slave pg_xlog files to be in different locations. During restore this directory is symlinked to slave pg_xlog. Patch from Steve Singer.
2010-07-27Introduce a 'backup_datadir' configuration variable toMartin Pihlak
control whether the slave data directory is kept or overwritten during restore. Patch from Steve Singer.
2010-07-27walmgr.py: add --version optionMartin Pihlak
2010-07-27Simplify the cleanup logic for partial wals.Martin Pihlak
2010-07-27"walmgr.py sync" now omits unneeded WAL segments if theMartin Pihlak
database has been cleanly shut down. This greatly reduces sync time during planned swithcovers as usually there is only a single WAL file to be synched to slave.
2010-02-05Fix slave_cleanup() so that partial files are not prematurely removed.Martin Pihlak
2009-12-29Redundant pg_auth file synch removed. By Mark Kirkwood.Martin Pihlak
2009-11-04walmgr: remove double importMarko Kreen
2009-10-06Fix the pg_[x]log rsyncing code to leave out directory contents.Martin Pihlak
2009-09-15Disable archive_command in restored postgresql.confMartin Pihlak
archive_command is set to /bin/true instead of disabling archive_mode This avoids the extra reconfiguration restart when the slave is actually booted and promoted to master. Based on patch by Mark Kirkwoord.
2009-07-21Remove unused --overwrite option.Martin Pihlak