skytools.git
14 years agolondiste.version(): 3.0.0.5
Marko Kreen [Thu, 2 Dec 2010 14:39:23 +0000 (16:39 +0200)]
londiste.version(): 3.0.0.5

14 years agodoc: ignore rsync errors
Marko Kreen [Thu, 2 Dec 2010 14:29:50 +0000 (16:29 +0200)]
doc: ignore rsync errors

14 years agoqadmin: fancier lodiste add_table
Marko Kreen [Thu, 2 Dec 2010 13:46:19 +0000 (15:46 +0200)]
qadmin: fancier lodiste add_table

14 years agolondiste: --no-triggers arg
Marko Kreen [Thu, 2 Dec 2010 13:45:15 +0000 (15:45 +0200)]
londiste: --no-triggers arg

14 years agolondiste.local_add_table: no_triggers and expect_sync magic args
Marko Kreen [Thu, 2 Dec 2010 13:39:50 +0000 (15:39 +0200)]
londiste.local_add_table: no_triggers and expect_sync magic args

14 years agolondiste.version(): 3.0.0.4
Marko Kreen [Wed, 1 Dec 2010 13:25:13 +0000 (15:25 +0200)]
londiste.version(): 3.0.0.4

14 years agotests/londiste: test table-remove on subscribers
Marko Kreen [Wed, 1 Dec 2010 13:21:01 +0000 (15:21 +0200)]
tests/londiste: test table-remove on subscribers

14 years agolondiste: show table counts in 'status'
Marko Kreen [Wed, 1 Dec 2010 13:20:38 +0000 (15:20 +0200)]
londiste: show table counts in 'status'

14 years agosql/londiste: create deny-trigger on leaf
Marko Kreen [Wed, 1 Dec 2010 13:19:34 +0000 (15:19 +0200)]
sql/londiste: create deny-trigger on leaf

14 years agolondiste tests: sync with trigger fmt changes
Marko Kreen [Wed, 1 Dec 2010 13:19:00 +0000 (15:19 +0200)]
londiste tests: sync with trigger fmt changes

14 years agopgq/triggers: 'deny' argument to logutriga/sqltriga
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.

14 years agolondiste.drop_table_triggers: check whether trigger has args
Marko Kreen [Tue, 30 Nov 2010 13:28:42 +0000 (15:28 +0200)]
londiste.drop_table_triggers: check whether trigger has args

14 years agolondiste.local_add_table: typo fix in 8.3 branch
Marko Kreen [Tue, 30 Nov 2010 13:28:17 +0000 (15:28 +0200)]
londiste.local_add_table: typo fix in 8.3 branch

14 years agorefresh libusual
Marko Kreen [Tue, 30 Nov 2010 13:03:01 +0000 (15:03 +0200)]
refresh libusual

14 years agolondiste.local_add_table: avoid array_length(), its 8.4+
Marko Kreen [Tue, 30 Nov 2010 13:00:02 +0000 (15:00 +0200)]
londiste.local_add_table: avoid array_length(), its 8.4+

14 years agotests/merge: make sync faster
Marko Kreen [Mon, 29 Nov 2010 14:39:49 +0000 (16:39 +0200)]
tests/merge: make sync faster

14 years agolondiste: use pgq.logutriga() as default trigger function
Marko Kreen [Mon, 29 Nov 2010 14:33:21 +0000 (16:33 +0200)]
londiste: use pgq.logutriga() as default trigger function

14 years agotests/merge: wait for sync on combined-root
Marko Kreen [Mon, 29 Nov 2010 14:29:14 +0000 (16:29 +0200)]
tests/merge: wait for sync on combined-root

14 years agolondiste.local_add_table: use --expect-sync on leaf to combined-branch
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

14 years agoset db ver for 3.0.0.3
Marko Kreen [Mon, 29 Nov 2010 13:02:25 +0000 (15:02 +0200)]
set db ver for 3.0.0.3

14 years agoAllow optional use of libevent
Marko Kreen [Mon, 29 Nov 2010 12:44:31 +0000 (14:44 +0200)]
Allow optional use of libevent

14 years agorefresh libevent
Marko Kreen [Mon, 29 Nov 2010 12:44:19 +0000 (14:44 +0200)]
refresh libevent

14 years agoCascadedWorker: merge-leaf must not write to db on branch
Marko Kreen [Mon, 29 Nov 2010 12:43:43 +0000 (14:43 +0200)]
CascadedWorker: merge-leaf must not write to db on branch

14 years agosql/*: Simplify queries to be able to run greenplum as leaf
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.

14 years agopgq.consumer: rename next_batch_custom result fields
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()..

14 years agolondiste.local_add_table: skip empty arg array
Marko Kreen [Fri, 26 Nov 2010 11:51:59 +0000 (13:51 +0200)]
londiste.local_add_table: skip empty arg array

14 years agoremove duplicate batch_info setting
Marko Kreen [Fri, 26 Nov 2010 11:32:34 +0000 (13:32 +0200)]
remove duplicate batch_info setting

14 years agolondiste.handlers: separate package for handlers
Marko Kreen [Fri, 19 Nov 2010 13:19:05 +0000 (15:19 +0200)]
londiste.handlers: separate package for handlers

14 years agolondiste: call handler at add-table time
Marko Kreen [Fri, 19 Nov 2010 13:17:51 +0000 (15:17 +0200)]
londiste: call handler at add-table time

14 years agolondiste: some handler fixes
Marko Kreen [Fri, 19 Nov 2010 13:17:27 +0000 (15:17 +0200)]
londiste: some handler fixes

14 years agogitignore: add debian crap
Marko Kreen [Fri, 19 Nov 2010 13:23:27 +0000 (15:23 +0200)]
gitignore: add debian crap

14 years agolondiste: trigger flags to control trigger creation
Marko Kreen [Fri, 12 Nov 2010 14:20:40 +0000 (16:20 +0200)]
londiste: trigger flags to control trigger creation

14 years agomagic_insert: allow shorter rows
Marko Kreen [Fri, 19 Nov 2010 14:13:32 +0000 (16:13 +0200)]
magic_insert: allow shorter rows

14 years agodbstruct: separate handling for column DEFAULTs
Marko Kreen [Fri, 19 Nov 2010 13:14:32 +0000 (15:14 +0200)]
dbstruct: separate handling for column DEFAULTs

14 years agosql/pgq: sanity check against incorrect db state
Marko Kreen [Fri, 12 Nov 2010 14:18:13 +0000 (16:18 +0200)]
sql/pgq: sanity check against incorrect db state

14 years agoqadmin: advanced syntax for londiste cmds, fix more quoting problems
Marko Kreen [Fri, 26 Nov 2010 11:02:10 +0000 (13:02 +0200)]
qadmin: advanced syntax for londiste cmds, fix more quoting problems

14 years agolondiste add-table --create: fix flag handling
Marko Kreen [Fri, 26 Nov 2010 10:04:07 +0000 (12:04 +0200)]
londiste add-table --create: fix flag handling

14 years agofix var name in last commit
Marko Kreen [Fri, 26 Nov 2010 10:01:40 +0000 (12:01 +0200)]
fix var name in last commit

14 years agocascadedconsumer: dont use .finish_remote_batch() in --reset
Marko Kreen [Fri, 26 Nov 2010 09:59:45 +0000 (11:59 +0200)]
cascadedconsumer: dont use .finish_remote_batch() in --reset

14 years agolondiste: play with session_replication_role only on 8.3+
Marko Kreen [Thu, 25 Nov 2010 15:47:10 +0000 (17:47 +0200)]
londiste: play with session_replication_role only on 8.3+

14 years agolondiste worker --reset fixes
Marko Kreen [Thu, 25 Nov 2010 15:44:54 +0000 (17:44 +0200)]
londiste worker --reset fixes

14 years agopgq.version: 3.0.0.2
Marko Kreen [Thu, 25 Nov 2010 13:07:48 +0000 (15:07 +0200)]
pgq.version: 3.0.0.2

14 years agotests/merge: some improvements
Marko Kreen [Thu, 25 Nov 2010 13:07:05 +0000 (15:07 +0200)]
tests/merge: some improvements

14 years agopgq.drop_queue: make force drop old consumers
Marko Kreen [Thu, 25 Nov 2010 13:06:28 +0000 (15:06 +0200)]
pgq.drop_queue: make force drop old consumers

14 years agoqadmin; better quoting support
Marko Kreen [Thu, 25 Nov 2010 12:19:18 +0000 (14:19 +0200)]
qadmin; better quoting support

14 years agounquote_ident: lowercase the non-quoted value
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.

14 years agoskytools.sql_tokenizer: optionally return token position
Marko Kreen [Thu, 25 Nov 2010 12:04:43 +0000 (14:04 +0200)]
skytools.sql_tokenizer: optionally return token position

14 years agoskytools.unquote_(fq)ident: tests, relax fq
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

14 years agolondiste setup: only set replica role for EXECUTE transaction
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

14 years agoqadmin: londiste commands
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

14 years agoskytools.sql_tokenizer: support fully-qualified names
Marko Kreen [Thu, 25 Nov 2010 07:24:25 +0000 (09:24 +0200)]
skytools.sql_tokenizer: support fully-qualified names

It's easier to merge name parts here than to do it in upper layers.

The merging does not support some crazier parts of sql syntax
like comments between name parts, so it defaults to off.

14 years agopgq_node.version() - 3.0.0.2
Marko Kreen [Wed, 24 Nov 2010 20:29:25 +0000 (22:29 +0200)]
pgq_node.version() - 3.0.0.2

14 years agotests/merge: make it work again
Marko Kreen [Wed, 24 Nov 2010 20:27:21 +0000 (22:27 +0200)]
tests/merge: make it work again

14 years agotestlib: nicer psql launcher
Marko Kreen [Wed, 24 Nov 2010 20:19:48 +0000 (22:19 +0200)]
testlib: nicer psql launcher

14 years agopgq_node.set_partition_watermark: finally sync with other pgq_node cleanups
Marko Kreen [Wed, 24 Nov 2010 20:19:02 +0000 (22:19 +0200)]
pgq_node.set_partition_watermark: finally sync with other pgq_node cleanups

14 years agopgq.BatchWalker: relaxed __len__(), ignore out-of-order calls
Marko Kreen [Wed, 24 Nov 2010 20:18:22 +0000 (22:18 +0200)]
pgq.BatchWalker: relaxed __len__(), ignore out-of-order calls

14 years agoCascadedWorker: override is_batch_done
Marko Kreen [Wed, 24 Nov 2010 20:16:51 +0000 (22:16 +0200)]
CascadedWorker: override is_batch_done

To allow combined-branch get more that one batch ahead.

14 years agorefresh libusual
Marko Kreen [Wed, 24 Nov 2010 09:48:51 +0000 (11:48 +0200)]
refresh libusual

14 years agopgqd: report database removal
Marko Kreen [Wed, 24 Nov 2010 09:48:09 +0000 (11:48 +0200)]
pgqd: report database removal

14 years agolondiste copy: survive remove-table
Marko Kreen [Wed, 24 Nov 2010 09:11:34 +0000 (11:11 +0200)]
londiste copy: survive remove-table

14 years agopgq_node: add version() function, bump ver in pgq and londiste schemas.
Marko Kreen [Tue, 23 Nov 2010 12:06:02 +0000 (14:06 +0200)]
pgq_node: add version() function, bump ver in pgq and londiste schemas.

All code has seen various fixes, this will help detect old versions.

14 years agolondiste.get_table_list: allow merge-leafs have different tables
Marko Kreen [Tue, 23 Nov 2010 10:28:57 +0000 (12:28 +0200)]
londiste.get_table_list: allow merge-leafs have different tables

try to account only nodes that have particular table

14 years agopgqd: sync with cfparser changes
Marko Kreen [Mon, 22 Nov 2010 23:03:14 +0000 (01:03 +0200)]
pgqd: sync with cfparser changes

14 years agotestlib cleanup fixes
Marko Kreen [Fri, 19 Nov 2010 13:07:07 +0000 (15:07 +0200)]
testlib  cleanup fixes

14 years agoCleanup for the new querybuilder functions
Marko Kreen [Thu, 11 Nov 2010 11:24:07 +0000 (13:24 +0200)]
Cleanup for the new querybuilder functions

14 years agohelper functions added into querybuilder
Asko Oja [Wed, 10 Nov 2010 23:02:10 +0000 (23:02 +0000)]
helper functions added into querybuilder

14 years agopgqd: tilde expansion for pidfile and logfile
Marko Kreen [Wed, 10 Nov 2010 15:46:46 +0000 (17:46 +0200)]
pgqd: tilde expansion for pidfile and logfile

Patch by Asko Tiidumaa

14 years agoset_tcp_keepalive: check socket.fromfd(), its missing on win32
Marko Kreen [Wed, 10 Nov 2010 12:32:46 +0000 (14:32 +0200)]
set_tcp_keepalive: check socket.fromfd(), its missing on win32

14 years agopgq.maint_rotate_tables: detect and report tick inconsistency
Marko Kreen [Tue, 9 Nov 2010 13:37:12 +0000 (15:37 +0200)]
pgq.maint_rotate_tables: detect and report tick inconsistency

14 years agochanged syslog handler to send service type
Aleksei Plotnikov [Thu, 4 Nov 2010 13:26:55 +0000 (13:26 +0000)]
changed syslog handler to send service type

14 years agorefresh libusual
Marko Kreen [Thu, 4 Nov 2010 12:06:40 +0000 (14:06 +0200)]
refresh libusual

14 years agoRestore old compat package location.
Marko Kreen [Wed, 3 Nov 2010 15:57:33 +0000 (17:57 +0200)]
Restore old compat package location.

Workaround for broken debian broke it, needs bit different owrkaround later.

14 years agopgqd: apply connection lifetime to ticker connection
Marko Kreen [Wed, 3 Nov 2010 15:50:10 +0000 (17:50 +0200)]
pgqd: apply connection lifetime to ticker connection

14 years agorefresh libusual
Marko Kreen [Wed, 3 Nov 2010 15:49:42 +0000 (17:49 +0200)]
refresh libusual

14 years agoadded syslog logging handler with hostname support
Aleksei Plotnikov [Tue, 2 Nov 2010 13:51:22 +0000 (15:51 +0200)]
added syslog logging handler with hostname support

14 years agodbservice: use txid_current() instead of old name
Marko Kreen [Tue, 2 Nov 2010 13:25:51 +0000 (15:25 +0200)]
dbservice: use txid_current() instead of old name

14 years agodbstruct: use adbin instead of adsrc when detecting default
Marko Kreen [Tue, 2 Nov 2010 13:25:06 +0000 (15:25 +0200)]
dbstruct: use adbin instead of adsrc when detecting default

14 years agodeb: fwd-port fix for braindamaged Debian's python
Marko Kreen [Mon, 1 Nov 2010 15:44:21 +0000 (17:44 +0200)]
deb: fwd-port fix for braindamaged Debian's python

They broke distutils install just for fun, thus each
python .deb needs their braindamaged hack to work.

14 years agoskytools.Config: fix bug in has_option()
Marko Kreen [Mon, 1 Nov 2010 15:18:49 +0000 (17:18 +0200)]
skytools.Config: fix bug in has_option()

14 years agopgqd: do reset_logging() in cleanup(), bit cleaner shutdown
Marko Kreen [Mon, 1 Nov 2010 15:16:48 +0000 (17:16 +0200)]
pgqd: do reset_logging() in cleanup(), bit cleaner shutdown

14 years agopgq_node.drop_node: simplify
Marko Kreen [Wed, 27 Oct 2010 15:08:23 +0000 (18:08 +0300)]
pgq_node.drop_node: simplify

- londiste data is removed by cascaded fkey
- use force when dropping queue

14 years agopgq.tune_storage: turn autovac off for queue tables
Marko Kreen [Wed, 27 Oct 2010 14:58:49 +0000 (17:58 +0300)]
pgq.tune_storage: turn autovac off for queue tables

14 years agopgq.drop_queue: add force flag
Marko Kreen [Wed, 27 Oct 2010 14:57:39 +0000 (17:57 +0300)]
pgq.drop_queue: add force flag

14 years agoFix pgq.next_batch_custom()
Marko Kreen [Mon, 25 Oct 2010 10:25:03 +0000 (13:25 +0300)]
Fix pgq.next_batch_custom()

Seems it was broken in some reorg.

14 years agoInstall queue_mover3
Marko Kreen [Mon, 25 Oct 2010 07:52:54 +0000 (10:52 +0300)]
Install queue_mover3

14 years agochecker: compare-repair-apply
Marko Kreen [Wed, 20 Oct 2010 11:35:02 +0000 (14:35 +0300)]
checker: compare-repair-apply

14 years agopgq: fix table reference
Marko Kreen [Wed, 20 Oct 2010 10:04:39 +0000 (13:04 +0300)]
pgq: fix table reference

14 years agocascadedconsumer: missing return in get_consumer_state
Marko Kreen [Tue, 19 Oct 2010 11:56:26 +0000 (14:56 +0300)]
cascadedconsumer: missing return in get_consumer_state

14 years agodbsctruct: fix reorg
Marko Kreen [Tue, 19 Oct 2010 08:54:50 +0000 (11:54 +0300)]
dbsctruct: fix reorg

14 years agolondiste: trigger-cleanup trigger on londiste.table_info
Marko Kreen [Wed, 13 Oct 2010 13:58:53 +0000 (16:58 +0300)]
londiste: trigger-cleanup trigger on londiste.table_info

14 years agoskytools.checker: fix, add repair-apply mode
Marko Kreen [Wed, 13 Oct 2010 13:57:37 +0000 (16:57 +0300)]
skytools.checker: fix, add repair-apply mode

15 years agolondiste: automatic db upgrade
Marko Kreen [Tue, 12 Oct 2010 13:26:43 +0000 (16:26 +0300)]
londiste: automatic db upgrade

this is an experiment...

15 years agolondiste: "on delete cascade" fkeys for tables
Marko Kreen [Tue, 12 Oct 2010 13:26:04 +0000 (16:26 +0300)]
londiste: "on delete cascade" fkeys for tables

this avoids need to write cleanup code

15 years agohack: cascadedconsumer send standby info
Marko Kreen [Tue, 12 Oct 2010 12:50:12 +0000 (15:50 +0300)]
hack: cascadedconsumer send standby info

15 years agolondiste.root_check_seqs: lock node row
Marko Kreen [Tue, 12 Oct 2010 12:32:23 +0000 (15:32 +0300)]
londiste.root_check_seqs: lock node row

15 years agorefresh libusual
Marko Kreen [Tue, 12 Oct 2010 12:16:39 +0000 (15:16 +0300)]
refresh libusual

15 years agodoc: fix make rules
Marko Kreen [Tue, 12 Oct 2010 12:15:57 +0000 (15:15 +0300)]
doc: fix make rules

15 years agotodo update, move existing stuff to NEWS
Marko Kreen [Tue, 12 Oct 2010 12:13:30 +0000 (15:13 +0300)]
todo update, move existing stuff to NEWS

15 years agocascadeadmin: remove obsolete entries from help text
Marko Kreen [Tue, 12 Oct 2010 12:09:20 +0000 (15:09 +0300)]
cascadeadmin: remove obsolete entries from help text

15 years agoskytools.checker: generalize more
Marko Kreen [Tue, 12 Oct 2010 12:08:18 +0000 (15:08 +0300)]
skytools.checker: generalize more