martinko [Thu, 18 Apr 2013 13:55:38 +0000 (15:55 +0200)]
scripts/data_maintainer.py: added suffix "3" to service name
martinko [Mon, 15 Apr 2013 15:54:32 +0000 (17:54 +0200)]
python: text fixes
martinko [Mon, 15 Apr 2013 15:54:04 +0000 (17:54 +0200)]
londiste: inform about no tables passed on cmd line (thus nothing to do)
Marko Kreen [Tue, 2 Apr 2013 19:36:56 +0000 (22:36 +0300)]
Merge branch 'master' of git://github.com/markokr/skytools
Marko Kreen [Tue, 2 Apr 2013 19:34:56 +0000 (22:34 +0300)]
cascadeadmin: downgrade missing host= error.
It's not 100% certain that user does not want such
connect strings, so erroring out is not right.
Marko Kreen [Tue, 2 Apr 2013 11:21:56 +0000 (04:21 -0700)]
Merge pull request #27 from kitsemets/master
libtool added as build dependency into installation instructions
kaarel [Mon, 1 Apr 2013 17:00:55 +0000 (10:00 -0700)]
libtool added as build dependency
Marko Kreen [Tue, 26 Mar 2013 09:53:11 +0000 (11:53 +0200)]
londiste: bump version to 3.1.4
Marko Kreen [Sat, 23 Mar 2013 12:13:51 +0000 (14:13 +0200)]
timeutil.datetime_to_timestamp: new function
converts datetime() to posix timestamp.
Marko Kreen [Sat, 23 Mar 2013 12:09:57 +0000 (14:09 +0200)]
Update AUTHORS
Marko Kreen [Fri, 22 Mar 2013 16:00:55 +0000 (18:00 +0200)]
DBScript.add_connect_string_profile: single place for profile logic
Marko Kreen [Fri, 22 Mar 2013 15:43:47 +0000 (17:43 +0200)]
status: forgot to drop cstr_extra argument
Marko Kreen [Fri, 22 Mar 2013 15:25:26 +0000 (17:25 +0200)]
cascadeadmin: cleanup of profile hack in status command
Marko Kreen [Thu, 21 Mar 2013 21:16:07 +0000 (23:16 +0200)]
londiste: connection profiles
Way to add extra connect string parameters for non-config
connection strings (public node locations).
Marko Kreen [Thu, 21 Mar 2013 21:39:04 +0000 (23:39 +0200)]
tests/londiste/regen.sh: test various combination of options
Marko Kreen [Thu, 21 Mar 2013 21:20:24 +0000 (23:20 +0200)]
cascadeadmin: forgot to make node_name optional everywhere
Marko Kreen [Thu, 21 Mar 2013 16:59:14 +0000 (18:59 +0200)]
Merge remote-tracking branch 'gamato/master'
Marko Kreen [Wed, 20 Mar 2013 17:37:06 +0000 (19:37 +0200)]
cascadeadmin: avoid hardwired db name
Marko Kreen [Wed, 20 Mar 2013 15:54:39 +0000 (17:54 +0200)]
londiste create: load node name and initial provider also from config
Marko Kreen [Wed, 20 Mar 2013 15:17:15 +0000 (17:17 +0200)]
adminscripts: make info commands not use pidfile
otherwise they conflict with change operations.
martinko [Tue, 19 Mar 2013 15:04:49 +0000 (16:04 +0100)]
londiste.create_trigger: added check for after-trigger being overshadowed by skip-trigger
martinko [Tue, 19 Mar 2013 14:43:12 +0000 (15:43 +0100)]
londiste.create_trigger: fixed compatibility with postgres 9+
martinko [Wed, 6 Mar 2013 16:47:36 +0000 (17:47 +0100)]
python: text fixes
Tarvi Pillessaar [Tue, 5 Mar 2013 14:02:46 +0000 (16:02 +0200)]
Merge branch 'master' of https://github.com/markokr/skytools
Marko Kreen [Tue, 5 Mar 2013 13:34:49 +0000 (15:34 +0200)]
Merge remote-tracking branch 'gamato/master'
Marko Kreen [Tue, 5 Mar 2013 13:31:35 +0000 (15:31 +0200)]
newgrants/pgq_node: another fix
martinko [Tue, 5 Mar 2013 13:26:14 +0000 (14:26 +0100)]
Merge branch 'master' of https://github.com/markokr/skytools
martinko [Tue, 5 Mar 2013 13:25:50 +0000 (14:25 +0100)]
docs
Tarvi Pillessaar [Tue, 5 Mar 2013 07:44:08 +0000 (09:44 +0200)]
walmgr: small loglevel changes
Marko Kreen [Mon, 4 Mar 2013 13:37:13 +0000 (15:37 +0200)]
data_maintainer: better way to handle .looping and .loop_delay
Marko Kreen [Mon, 4 Mar 2013 12:55:36 +0000 (14:55 +0200)]
loop_delay: let class variable set default
This way it's easier to change default in subclass.
martinko [Mon, 4 Mar 2013 09:55:03 +0000 (10:55 +0100)]
Merge branch 'master' of https://github.com/markokr/skytools
martinko [Mon, 4 Mar 2013 09:48:02 +0000 (10:48 +0100)]
scripts/data_maintainer.py: fixes
Marko Kreen [Mon, 4 Mar 2013 09:35:06 +0000 (11:35 +0200)]
Merge remote-tracking branch 'petr/master'
Marko Kreen [Mon, 4 Mar 2013 09:33:09 +0000 (11:33 +0200)]
Revert "setup_skytools: install grant files under /usr/share/skytools"
This reverts commit
c63236f11753c06a10dee125f2dc1cd241e92714.
setup_skytools.py wants ability to regenerate the fixes in pure-Python,
which is pain for grant files. Will look into it later.
Marko Kreen [Mon, 4 Mar 2013 09:23:29 +0000 (11:23 +0200)]
More newgrants fixes..
Petr Jelinek [Sun, 3 Mar 2013 23:58:55 +0000 (00:58 +0100)]
londiste: actually execute the ENABLE/DISABLE RULE query in londiste.create_partition
Marko Kreen [Sun, 3 Mar 2013 19:00:50 +0000 (21:00 +0200)]
cascadeadmin status: wait for threads
Instead Queue.join(), call Thread.join() for each
thread. Otherwise the thread can be active during
process shutdown and throw weird errors.
After that, calling Queue.join() seems useless; it can
even allow additional failure situations.
Also clarify thread count logic.
Marko Kreen [Sun, 3 Mar 2013 18:53:21 +0000 (20:53 +0200)]
more newgrants fixes.
mostly works now.
only problem is that londiste_writer needs to be
superuser because of session_replication_role.
That can be fixed with secdef function, but that
means code needs to be installed separately.
Marko Kreen [Sun, 3 Mar 2013 18:52:05 +0000 (20:52 +0200)]
setup_skytools: install grant files under /usr/share/skytools
Marko Kreen [Fri, 1 Mar 2013 21:35:00 +0000 (23:35 +0200)]
create-node: validate, accept public location from config
Marko Kreen [Fri, 1 Mar 2013 21:33:23 +0000 (23:33 +0200)]
configure.ac: check for -lrt
Needed when pgqd is built against libevent (--with-libevent)
Marko Kreen [Fri, 1 Mar 2013 21:02:18 +0000 (23:02 +0200)]
Parse & merge Postgres connect strings
martinko [Thu, 28 Feb 2013 14:14:43 +0000 (15:14 +0100)]
scripts: sweeping change to postpone log string formatting
martinko [Thu, 28 Feb 2013 14:14:03 +0000 (15:14 +0100)]
setup_skytools.py: added data_maintainer.py
martinko [Thu, 28 Feb 2013 14:03:42 +0000 (15:03 +0100)]
scripts/data_maintainer.py: updated
martinko [Thu, 28 Feb 2013 14:02:07 +0000 (15:02 +0100)]
scripts/data_maintainer.py: imported from skytools 2.0
martinko [Wed, 27 Feb 2013 15:54:17 +0000 (16:54 +0100)]
Merge branch 'master' of https://github.com/markokr/skytools
martinko [Wed, 27 Feb 2013 15:52:36 +0000 (16:52 +0100)]
Merge branch 'master' of https://github.com/markokr/skytools
Marko Kreen [Wed, 27 Feb 2013 15:48:30 +0000 (17:48 +0200)]
Merge remote-tracking branch 'gamato/master'
martinko [Wed, 27 Feb 2013 13:50:35 +0000 (14:50 +0100)]
scripts: fixed shebang line
martinko [Wed, 27 Feb 2013 13:23:22 +0000 (14:23 +0100)]
pgq.cascade.admin: amended threading
martinko [Wed, 27 Feb 2013 11:18:18 +0000 (12:18 +0100)]
thread safety catchup
martinko [Wed, 27 Feb 2013 09:44:55 +0000 (10:44 +0100)]
pgq/cascade: significant speed up of getting status on big cascades
e.g.: 1000 node cascade status went from minutes to seconds
Marko Kreen [Sat, 23 Feb 2013 13:17:00 +0000 (15:17 +0200)]
Merge remote-tracking branch 'gamato/master'
martinko [Sat, 23 Feb 2013 08:11:16 +0000 (09:11 +0100)]
walmgr: sweeping change to postpone log string formatting
Marko Kreen [Fri, 22 Feb 2013 15:08:44 +0000 (17:08 +0200)]
Merge remote-tracking branch 'gamato/master'
martinko [Fri, 22 Feb 2013 13:29:44 +0000 (14:29 +0100)]
noise
martinko [Fri, 22 Feb 2013 13:28:56 +0000 (14:28 +0100)]
pgq: sweeping change to postpone log string formatting
martinko [Thu, 21 Feb 2013 15:09:47 +0000 (16:09 +0100)]
londiste: sweeping change to postpone log string formatting
martinko [Thu, 21 Feb 2013 14:17:46 +0000 (15:17 +0100)]
londiste: moved drop_obsolete_partitions() call to check_part()
Note that current behaviour is that dispatcher would crash if events older than retention period arrived.
Perhaps it is better than quietly recreating and redropping tables for too old events..?
martinko [Thu, 21 Feb 2013 14:07:01 +0000 (15:07 +0100)]
londiste.drop_obsolete_partitions: changed back to return (and log) names of dropped tables
martinko [Thu, 21 Feb 2013 12:44:00 +0000 (13:44 +0100)]
londiste.create_partition: properly quote owner in ddl
martinko [Thu, 21 Feb 2013 12:36:01 +0000 (13:36 +0100)]
londiste.drop_obsolete_partitions: reformatted
Marko Kreen [Wed, 20 Feb 2013 20:23:43 +0000 (22:23 +0200)]
kwcheck.py: compare postgres keywords table
Marko Kreen [Wed, 20 Feb 2013 20:21:20 +0000 (22:21 +0200)]
skytools.quoting: add more keywords
Automatically compare pg-git kwlist.h with our list.
New words:
cross current_catalog current_schema fetch freeze
full ilike inner is isnull join lateral left like
natural notnull outer over overlaps right similar
variadic verbose window with
Marko Kreen [Wed, 20 Feb 2013 19:30:27 +0000 (11:30 -0800)]
Merge pull request #23 from reinteractive-open/
146bdc280056fcc4cd9bc0385601f03c8c62e01d
adding 'authorizations' as a keyword
Marko Kreen [Wed, 20 Feb 2013 18:43:36 +0000 (20:43 +0200)]
make debclean: make it less broken
seems it has not been used for a long time.
Marko Kreen [Wed, 20 Feb 2013 18:38:49 +0000 (20:38 +0200)]
londiste.create_trigger: use decode for _new_args[1]
Marko Kreen [Wed, 20 Feb 2013 18:36:27 +0000 (20:36 +0200)]
Merge remote-tracking branch 'petr/master'
martinko [Wed, 20 Feb 2013 16:10:55 +0000 (17:10 +0100)]
londiste: added dispatch handler arg retention_period
It controls how long to keep partitions around. Examples: '3 months', '1 year'
martinko [Wed, 20 Feb 2013 16:07:04 +0000 (17:07 +0100)]
noise
martinko [Tue, 19 Feb 2013 19:55:23 +0000 (20:55 +0100)]
londiste.drop_obsolete_partitions: changed to raise notice instead of returning rows; defaults to public schema.
martinko [Tue, 19 Feb 2013 18:46:19 +0000 (19:46 +0100)]
londiste.drop_obsolete_partitions: amended
martinko [Tue, 19 Feb 2013 18:44:09 +0000 (19:44 +0100)]
londiste.drop_obsolete_partitions: added support for different partitioning periods
martinko [Tue, 19 Feb 2013 18:42:10 +0000 (19:42 +0100)]
londiste: reformatted drop_obsolete_partitions() to lower case
martinko [Tue, 19 Feb 2013 18:40:20 +0000 (19:40 +0100)]
londiste: imported drop_obsolete_partitions(2) function
martinko [Fri, 15 Feb 2013 12:47:08 +0000 (13:47 +0100)]
londiste: create_partition now sets owner to match parent table
martinko [Fri, 15 Feb 2013 12:03:16 +0000 (13:03 +0100)]
doc/londiste3: catch up with recent "compare --count-only" commit
Marko Kreen [Thu, 14 Feb 2013 14:37:39 +0000 (16:37 +0200)]
Merge remote-tracking branch 'tarvip/master'
Eero Oja [Wed, 13 Feb 2013 15:23:25 +0000 (15:23 +0000)]
added handling deletes to keep_latest row_mode
martinko [Wed, 13 Feb 2013 09:42:35 +0000 (10:42 +0100)]
noise
martinko [Tue, 12 Feb 2013 07:37:04 +0000 (08:37 +0100)]
londiste: added --count-only to compare command
For quickly checking whether tables have same number of rows,
without comparing tables' contents (data).
Petr Jelinek [Sat, 9 Feb 2013 00:16:36 +0000 (01:16 +0100)]
londiste: quote queue name in trigger args
Marko Kreen [Tue, 29 Jan 2013 14:02:26 +0000 (16:02 +0200)]
londiste newgrants: update group names
Marko Kreen [Tue, 29 Jan 2013 14:00:59 +0000 (16:00 +0200)]
scriptmgr: fix copy-paste error in full_path
Petr Jelinek [Mon, 28 Jan 2013 12:53:31 +0000 (13:53 +0100)]
PGQ: same bug different place...
Petr Jelinek [Mon, 28 Jan 2013 11:42:40 +0000 (12:42 +0100)]
Pgq: fix RetriableBatchWalker initialization
Tarvi Pillessaar [Fri, 25 Jan 2013 12:22:05 +0000 (14:22 +0200)]
skytools_upgrae: make force option work properly
Petr Jelinek [Fri, 25 Jan 2013 09:27:56 +0000 (10:27 +0100)]
Remove typo in Event
Tarvi Pillessaar [Fri, 25 Jan 2013 08:31:18 +0000 (10:31 +0200)]
skytools.Config: fix the case if filename is missing
Petr Jelinek [Thu, 24 Jan 2013 13:04:31 +0000 (14:04 +0100)]
Initialize Event properly in BaseConsumer
Tarvi Pillessaar [Wed, 23 Jan 2013 10:25:51 +0000 (12:25 +0200)]
skytools_upgrade: add force option
Marko Kreen [Mon, 21 Jan 2013 17:54:23 +0000 (19:54 +0200)]
scriptmgr: give -nH args to sudo
Marko Kreen [Sun, 20 Jan 2013 20:55:13 +0000 (22:55 +0200)]
scriptmgr: fix ~ expansion
Marko Kreen [Fri, 18 Jan 2013 21:34:24 +0000 (23:34 +0200)]
Merge remote-tracking branch 'petr/master'
Marko Kreen [Wed, 16 Jan 2013 23:52:43 +0000 (01:52 +0200)]
scriptmgr: user= support
Daemon sections can now have user= option. It makes
scriptmgr launch (and kill) daemons with sudo -u $user.
Petr Jelinek [Thu, 17 Jan 2013 13:33:54 +0000 (14:33 +0100)]
Regression test for previous commit
Petr Jelinek [Thu, 17 Jan 2013 13:11:07 +0000 (14:11 +0100)]
Londiste: fix trigger generation when extra params that are add-table specific are used (introduced in commit
364ade9)
Glenn Davy [Tue, 15 Jan 2013 23:07:06 +0000 (10:07 +1100)]
Added pg keyword 'authorization'