summaryrefslogtreecommitdiff
path: root/sql/pgq_node
AgeCommit message (Collapse)Author
2014-10-29bumping up schemata's versions in preparation for upcoming releasemartinko
2014-10-29Merge branch 'master' of https://github.com/markokr/skytools into hotfix/3.2.5martinko
2014-10-29fixed subscriber_info_watermark_name_fkey violationmartinko
(introduced in commit 0466144)
2014-10-27pgq_node: avoid concurrency in promote/demoteMarko Kreen
2014-07-25pgq_node.tables: added foreign key and fixed commentsmartinko
2014-04-01bumped up version to 3.2martinko
let's get trendy ... it's no good to be stuck on same minor version for so long ;-) and it actually did not make sense ... quite a few important features appeared
2014-02-20bumping up versions in preparation for upcoming releasemartinko
2013-07-26pgq_node.get_node_info: document node_attrsMarko Kreen
2013-03-05newgrants/pgq_node: another fixMarko Kreen
2013-03-04More newgrants fixes..Marko Kreen
2013-03-03more newgrants fixes.Marko Kreen
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.
2013-01-10Store naturaldocs customizations in tree.Marko Kreen
Now unpatched naturaldocs should work fine.
2012-12-21Sync module versionsMarko Kreen
2012-12-20Bump pgq_node ver to 3.1.3Marko Kreen
2012-09-19Support for extensions upgradeMarko Kreen
Needed for pgq & pgq_coop that have changed. Also move more common code to common-pgxs.mk
2012-09-12pgq_node.demote_root: decrease lock levelMarko Kreen
Otherwise demote can get stuck on pg_dump. Also lock all event tables, not only current as the current one can change.
2012-07-19Bump schema versions.Marko Kreen
Everything is 3.1.0.0 now.
2012-07-13Convert DB modules to extensionsMarko Kreen
Keep installing old module files under contrib/ still.
2012-06-05pgq_node.drop_node: mention node name in info messageMarko Kreen
2012-05-30pgq_node.version(): 3.0.0.18Marko Kreen
2012-05-30pgq_node.drop_node(): forgot to remove raturn when planning fallthruMarko Kreen
2012-05-29pgq_node.version(): 3.0.0.17Marko Kreen
2012-05-25pgq_node.drop_node: drop queue data even if node_info is emptyMarko Kreen
2012-05-24pgq_node.version(): 3.0.0.16Marko Kreen
2012-05-21pgq_node: refresh regtestMarko Kreen
2012-05-21pgq_node.unregister_location: do automatic unsubscribeMarko Kreen
There may be obsolete subscriptions around, do unsubscribe automatically, instead complaining.
2012-05-15pgq_node.create_node: create branch nodes with disable_insert setMarko Kreen
This is the proper approach to avoid any unexpected events in the queue. The flag is ignored if connection is in 'replica' role, thus cascaded queueing continues to work.
2012-05-10pgq_node.version(): 3.0.0.15Marko Kreen
2012-05-10Group-access roles for SQL functions (draft)Marko Kreen
This is attempt for fine-grained access rights for all Skytools SQL schemas. As it still needs review, the rights are not activated by default, instead following sql files are generated: newgrants_<schema>.sql - applies new rights, drop old public access oldgrants_<schema>.sql - restores old rights - public execute privilege to all functions Only thing that is active by default is creation of new groups in upgrade functions. New access roles: pgq_reader Can consume queues (source-side) pgq_writer Can write into queues (source-side / dest-side) Can use pgq_node/pgq_ext schema as regular consumer (dest-side) pgq_admin Admin operations on queues, required for CascadedWorker on dest-side. Member of pgq_reader and pgq_writer. londiste_reader Member of pgq_reader, needs additional read access to tables. (source-side) londiste_writer Member of pgq_admin, needs additional write access to tables. (dest-side)
2012-04-18pgq_node.version(): 3.0.0.14Marko Kreen
2012-03-06Clean up SQL documentationMarko Kreen
By Hannu Krosing, applied with some fixing
2012-02-01pgq_node.version(): 3.0.0.13Marko Kreen
2012-01-31pgq_node: good looking regression diffsMarko Kreen
2012-01-31--sync-watermark: limit watermark to specific nodesMarko Kreen
This will allow specified nodes to sync global watermark with each other, without sending it upwards. This isolates root node from lag on downstream nodes.
2012-01-11pgq_node.set_global_watermark: fix wm=null check for branch nodeMarko Kreen
It was in wrong IF section
2011-12-07pgq_node.version(): 3.0.0.12Marko Kreen
2011-12-07pgq_node.drop_node: fix bugs in recent changesMarko Kreen
Add function to regtests to avoid such problems in future.
2011-11-29sql upgrade cleanupMarko Kreen
- use 'structure/upgrade.sql' to generate X.upgrade.sql - add pgq_ext to upgraded schemas - move non-standard upgrade scripts to extra/ - setup_skytools: build sql files in 'build' target, not always - pgq_ext.version: bump ver to 3.0.0.1
2011-11-22pgq_node.version(): 3.0.0.11Marko Kreen
2011-11-21pgq_node.drop_node: refuse to drop if node is our provider.Marko Kreen
safety check, admin tool should have done change-provider before dropping.
2011-11-18pgq_node.drop_node: cleanupMarko Kreen
- dont catch errors from pgq_node.unregister_subscriber, pgq.unregister_consumer is now silent. - use pgq_node.unregister_location() to drop location, that will also send event on root. - delete all state on pgq_node.subscriber_info when local node is dropped - call pgq_node.unregister_subscriber() only when non-local node is dropped
2011-11-15pgq_node.version(): 3.0.0.10Marko Kreen
2011-11-14sql/pgq_node: doc: describe workflow for cascaded consumerMarko Kreen
2011-11-14pgq_node.register_location: skip insert if location is nullMarko Kreen
This allows tag-dead for non-existing node.
2011-10-13pgq_node.version(): 3.0.0.9Marko Kreen
2011-10-04pgq_node.drop_node: non-existing queue should not be errorMarko Kreen
2011-09-19sql/*/Makefile: stop depending on config.makMarko Kreen
Only vars taken from there were PG_CONFIG and PGXS. Instead let sql/Makefile give PG_CONFIG as param. This makes easier to test across multiple Postgres versions.
2011-09-18gq_node.get_worker_state: avoid convlicting var nameMarko Kreen
2011-09-08pgq_node.upgrade_schema(): magic schema upgradeMarko Kreen
also sync regtest output
2011-09-05pgq_node: use 'install.sql' fileMarko Kreen