Asko Tiidumaa [Wed, 22 Dec 2010 09:29:51 +0000 (09:29 +0000)]
fixes to producer sql filtering
Martin Pihlak [Wed, 22 Dec 2010 08:56:19 +0000 (10:56 +0200)]
change default syslog=1 for pgqd.
Marko Kreen [Tue, 21 Dec 2010 12:39:47 +0000 (14:39 +0200)]
Merge remote branch 'intgit/master'
Asko Tiidumaa [Tue, 21 Dec 2010 12:37:52 +0000 (12:37 +0000)]
lambda vs quite_literal
Asko Tiidumaa [Mon, 20 Dec 2010 18:22:48 +0000 (18:22 +0000)]
fixed local_only functionality, structural changes
Asko Tiidumaa [Mon, 20 Dec 2010 16:57:38 +0000 (16:57 +0000)]
added local_only to londiste config parameter - accepts only events for local tables
Marko Kreen [Thu, 16 Dec 2010 13:46:00 +0000 (15:46 +0200)]
qaadmin: unquote_literal fix
Marko Kreen [Tue, 14 Dec 2010 13:16:48 +0000 (15:16 +0200)]
londiste add: create_flags must be 0 by default
Marko Kreen [Tue, 14 Dec 2010 12:54:51 +0000 (14:54 +0200)]
bump db ver
Marko Kreen [Tue, 14 Dec 2010 12:51:21 +0000 (14:51 +0200)]
pgq_node: workarounds for bandaid casts
Marko Kreen [Tue, 14 Dec 2010 12:48:19 +0000 (14:48 +0200)]
pgq: avoid text||int concet, it breaks if db has bandaid casts installed
Marko Kreen [Tue, 14 Dec 2010 12:24:08 +0000 (14:24 +0200)]
londiste add-table: dont set create_flags prematurely
Marko Kreen [Mon, 13 Dec 2010 08:34:20 +0000 (10:34 +0200)]
bump db ver
Marko Kreen [Mon, 13 Dec 2010 08:02:35 +0000 (10:02 +0200)]
Merge remote branch 'askotm/master'
Martin Pihlak [Sun, 12 Dec 2010 13:34:00 +0000 (15:34 +0200)]
fix pg_autovacuum defaults in pgq.tune_storage()
Previous version used zero value for freeze_max_age, which caused
autovacuum to constantly re-vacuum all of the event tables because
of the wraparound threat. Set this and other values to -1 to indicate
system default.
Asko Tiidumaa [Thu, 9 Dec 2010 16:27:42 +0000 (16:27 +0000)]
fixed two typos
Asko Tiidumaa [Thu, 9 Dec 2010 16:25:33 +0000 (16:25 +0000)]
wrote handle_fkeys to more gp-friendlier version
Marko Kreen [Wed, 8 Dec 2010 14:39:37 +0000 (16:39 +0200)]
dbstruct: use new acl parser
Marko Kreen [Wed, 8 Dec 2010 14:37:28 +0000 (16:37 +0200)]
qadmin: remove exception test
Marko Kreen [Wed, 8 Dec 2010 14:33:22 +0000 (16:33 +0200)]
skytools: parse_acl() func for postgres ACL parsing
Marko Kreen [Wed, 8 Dec 2010 14:11:50 +0000 (16:11 +0200)]
londiste tables: dont show non-local tables
those can be seen with 'missing'
Marko Kreen [Wed, 8 Dec 2010 13:59:04 +0000 (15:59 +0200)]
qadmin: catch and show python exceptions
Marko Kreen [Wed, 8 Dec 2010 13:58:36 +0000 (15:58 +0200)]
londiste do-sync: actually reset the pgq params
Asko Tiidumaa [Wed, 8 Dec 2010 13:42:21 +0000 (13:42 +0000)]
tick logic now respects either lag or max tick count, not just both
Marko Kreen [Wed, 8 Dec 2010 12:47:21 +0000 (14:47 +0200)]
pgq_node.version: 3.0.0.4
Marko Kreen [Wed, 8 Dec 2010 12:45:58 +0000 (14:45 +0200)]
skytools.unquote_ident: dont crash on empty string
Marko Kreen [Wed, 8 Dec 2010 12:44:57 +0000 (14:44 +0200)]
londiste: force small batches for do-sync
Marko Kreen [Wed, 8 Dec 2010 12:44:07 +0000 (14:44 +0200)]
pgq_node.get_consumer_state: missing returns, update regtest
Marko Kreen [Wed, 8 Dec 2010 12:39:32 +0000 (14:39 +0200)]
londiste.playback: unused tablestate method
Asko Tiidumaa [Wed, 8 Dec 2010 11:09:10 +0000 (11:09 +0000)]
split query to avoid gp errors
Marko Kreen [Mon, 6 Dec 2010 12:53:14 +0000 (14:53 +0200)]
londiste: load bulkloader by default
Marko Kreen [Mon, 6 Dec 2010 12:47:50 +0000 (14:47 +0200)]
bulkloader: better error message if wrong event type
Marko Kreen [Mon, 6 Dec 2010 12:47:00 +0000 (14:47 +0200)]
qadmin: sql passthrough, show table/sequence, cleanups
Marko Kreen [Mon, 6 Dec 2010 12:17:52 +0000 (14:17 +0200)]
dbstruct: slightly more readable SQL output
Marko Kreen [Mon, 6 Dec 2010 12:17:19 +0000 (14:17 +0200)]
quote_ident: special-case empty string
Marko Kreen [Mon, 6 Dec 2010 12:14:04 +0000 (14:14 +0200)]
sql_tokenize: various improvements
- drop the use_qident param, wrong place for it
- support multi-symbol operators
- support >2 parts in names
- drop the magic escaping in pynew,pyold. it does not make sense
- let all unknown symbols count as error
Marko Kreen [Fri, 3 Dec 2010 15:27:33 +0000 (17:27 +0200)]
qadmin: parser cleanup
Marko Kreen [Fri, 3 Dec 2010 15:27:12 +0000 (17:27 +0200)]
todo update
Marko Kreen [Fri, 3 Dec 2010 15:26:43 +0000 (17:26 +0200)]
bulkloader doc: show correct londiste switch
Marko Kreen [Fri, 3 Dec 2010 15:26:10 +0000 (17:26 +0200)]
sql_tokenizer: options to returns quoted idents separately
Marko Kreen [Fri, 3 Dec 2010 13:53:51 +0000 (15:53 +0200)]
tests/handler: bulk handler test
Marko Kreen [Fri, 3 Dec 2010 13:50:03 +0000 (15:50 +0200)]
londiste handler: convert bulkloader to handler
Marko Kreen [Fri, 3 Dec 2010 13:49:32 +0000 (15:49 +0200)]
magic_insert: allow pre-quoted table name
Marko Kreen [Fri, 3 Dec 2010 12:22:30 +0000 (14:22 +0200)]
refresh libusual
Marko Kreen [Fri, 3 Dec 2010 12:14:08 +0000 (14:14 +0200)]
londiste playback: fix cursor name
Marko Kreen [Fri, 3 Dec 2010 12:13:26 +0000 (14:13 +0200)]
cascadedworker: missing import
Marko Kreen [Fri, 3 Dec 2010 12:12:59 +0000 (14:12 +0200)]
sql/londiste: actually install the .version function
Marko Kreen [Fri, 3 Dec 2010 09:16:29 +0000 (11:16 +0200)]
londiste.version(): 3.0.0.6
Marko Kreen [Fri, 3 Dec 2010 09:15:37 +0000 (11:15 +0200)]
londiste copy: at do-sync time disable large batches
Marko Kreen [Fri, 3 Dec 2010 09:02:31 +0000 (11:02 +0200)]
londiste.local_add_table: avoid assigning to IN param
Marko Kreen [Thu, 2 Dec 2010 14:39:23 +0000 (16:39 +0200)]
londiste.version(): 3.0.0.5
Marko Kreen [Thu, 2 Dec 2010 14:29:50 +0000 (16:29 +0200)]
doc: ignore rsync errors
Marko Kreen [Thu, 2 Dec 2010 13:46:19 +0000 (15:46 +0200)]
qadmin: fancier lodiste add_table
Marko Kreen [Thu, 2 Dec 2010 13:45:15 +0000 (15:45 +0200)]
londiste: --no-triggers arg
Marko Kreen [Thu, 2 Dec 2010 13:39:50 +0000 (15:39 +0200)]
londiste.local_add_table: no_triggers and expect_sync magic args
Marko Kreen [Wed, 1 Dec 2010 13:25:13 +0000 (15:25 +0200)]
londiste.version(): 3.0.0.4
Marko Kreen [Wed, 1 Dec 2010 13:21:01 +0000 (15:21 +0200)]
tests/londiste: test table-remove on subscribers
Marko Kreen [Wed, 1 Dec 2010 13:20:38 +0000 (15:20 +0200)]
londiste: show table counts in 'status'
Marko Kreen [Wed, 1 Dec 2010 13:19:34 +0000 (15:19 +0200)]
sql/londiste: create deny-trigger on leaf
Marko Kreen [Wed, 1 Dec 2010 13:19:00 +0000 (15:19 +0200)]
londiste tests: sync with trigger fmt changes
Marko Kreen [Wed, 1 Dec 2010 13:06:12 +0000 (15:06 +0200)]
pgq/triggers: 'deny' argument to logutriga/sqltriga
Needed for deny trigger on leafs.
Marko Kreen [Tue, 30 Nov 2010 13:28:42 +0000 (15:28 +0200)]
londiste.drop_table_triggers: check whether trigger has args
Marko Kreen [Tue, 30 Nov 2010 13:28:17 +0000 (15:28 +0200)]
londiste.local_add_table: typo fix in 8.3 branch
Marko Kreen [Tue, 30 Nov 2010 13:03:01 +0000 (15:03 +0200)]
refresh libusual
Marko Kreen [Tue, 30 Nov 2010 13:00:02 +0000 (15:00 +0200)]
londiste.local_add_table: avoid array_length(), its 8.4+
Marko Kreen [Mon, 29 Nov 2010 14:39:49 +0000 (16:39 +0200)]
tests/merge: make sync faster
Marko Kreen [Mon, 29 Nov 2010 14:33:21 +0000 (16:33 +0200)]
londiste: use pgq.logutriga() as default trigger function
Marko Kreen [Mon, 29 Nov 2010 14:29:14 +0000 (16:29 +0200)]
tests/merge: wait for sync on combined-root
Marko Kreen [Mon, 29 Nov 2010 14:28:28 +0000 (16:28 +0200)]
londiste.local_add_table: use --expect-sync on leaf to combined-branch
Marko Kreen [Mon, 29 Nov 2010 13:02:25 +0000 (15:02 +0200)]
set db ver for 3.0.0.3
Marko Kreen [Mon, 29 Nov 2010 12:44:31 +0000 (14:44 +0200)]
Allow optional use of libevent
Marko Kreen [Mon, 29 Nov 2010 12:44:19 +0000 (14:44 +0200)]
refresh libevent
Marko Kreen [Mon, 29 Nov 2010 12:43:43 +0000 (14:43 +0200)]
CascadedWorker: merge-leaf must not write to db on branch
Asko Tiidumaa [Fri, 26 Nov 2010 12:33:33 +0000 (12:33 +0000)]
sql/*: Simplify queries to be able to run greenplum as leaf
execute:
Move session_replication_role setting out of db functions.
Marko Kreen [Fri, 26 Nov 2010 13:05:25 +0000 (15:05 +0200)]
pgq.consumer: rename next_batch_custom result fields
fields names are out-of-sync with get_batch_info()..
Marko Kreen [Fri, 26 Nov 2010 11:51:59 +0000 (13:51 +0200)]
londiste.local_add_table: skip empty arg array
Marko Kreen [Fri, 26 Nov 2010 11:32:34 +0000 (13:32 +0200)]
remove duplicate batch_info setting
Marko Kreen [Fri, 19 Nov 2010 13:19:05 +0000 (15:19 +0200)]
londiste.handlers: separate package for handlers
Marko Kreen [Fri, 19 Nov 2010 13:17:51 +0000 (15:17 +0200)]
londiste: call handler at add-table time
Marko Kreen [Fri, 19 Nov 2010 13:17:27 +0000 (15:17 +0200)]
londiste: some handler fixes
Marko Kreen [Fri, 19 Nov 2010 13:23:27 +0000 (15:23 +0200)]
gitignore: add debian crap
Marko Kreen [Fri, 12 Nov 2010 14:20:40 +0000 (16:20 +0200)]
londiste: trigger flags to control trigger creation
Marko Kreen [Fri, 19 Nov 2010 14:13:32 +0000 (16:13 +0200)]
magic_insert: allow shorter rows
Marko Kreen [Fri, 19 Nov 2010 13:14:32 +0000 (15:14 +0200)]
dbstruct: separate handling for column DEFAULTs
Marko Kreen [Fri, 12 Nov 2010 14:18:13 +0000 (16:18 +0200)]
sql/pgq: sanity check against incorrect db state
Marko Kreen [Fri, 26 Nov 2010 11:02:10 +0000 (13:02 +0200)]
qadmin: advanced syntax for londiste cmds, fix more quoting problems
Marko Kreen [Fri, 26 Nov 2010 10:04:07 +0000 (12:04 +0200)]
londiste add-table --create: fix flag handling
Marko Kreen [Fri, 26 Nov 2010 10:01:40 +0000 (12:01 +0200)]
fix var name in last commit
Marko Kreen [Fri, 26 Nov 2010 09:59:45 +0000 (11:59 +0200)]
cascadedconsumer: dont use .finish_remote_batch() in --reset
Marko Kreen [Thu, 25 Nov 2010 15:47:10 +0000 (17:47 +0200)]
londiste: play with session_replication_role only on 8.3+
Marko Kreen [Thu, 25 Nov 2010 15:44:54 +0000 (17:44 +0200)]
londiste worker --reset fixes
Marko Kreen [Thu, 25 Nov 2010 13:07:48 +0000 (15:07 +0200)]
pgq.version: 3.0.0.2
Marko Kreen [Thu, 25 Nov 2010 13:07:05 +0000 (15:07 +0200)]
tests/merge: some improvements
Marko Kreen [Thu, 25 Nov 2010 13:06:28 +0000 (15:06 +0200)]
pgq.drop_queue: make force drop old consumers
Marko Kreen [Thu, 25 Nov 2010 12:19:18 +0000 (14:19 +0200)]
qadmin; better quoting support
Marko Kreen [Thu, 25 Nov 2010 12:10:13 +0000 (14:10 +0200)]
unquote_ident: lowercase the non-quoted value
Otherwise the value will later be quoted incorrectly.
Marko Kreen [Thu, 25 Nov 2010 12:04:43 +0000 (14:04 +0200)]
skytools.sql_tokenizer: optionally return token position
Marko Kreen [Thu, 25 Nov 2010 12:03:52 +0000 (14:03 +0200)]
skytools.unquote_(fq)ident: tests, relax fq
unquote_fqident does not require both parts anymore
Marko Kreen [Thu, 25 Nov 2010 11:58:06 +0000 (13:58 +0200)]
londiste setup: only set replica role for EXECUTE transaction
otherwise cleanup triggers wont launch
Marko Kreen [Thu, 25 Nov 2010 09:53:17 +0000 (11:53 +0200)]
qadmin: londiste commands
add_table, remove_table, tables,
add_seq, remove_seq, seqs,
missing