Bug 243158 – Ebuild for dev-db/skytools

• Product: Gentoo Linux
• Status: RESOLVED WONTFIX

[Description Mike Weissman 2008-10-21 22:49:14 UTC]

Request for ebuild for dev-db/skytools be added to portage.  

Skytools consists of tools for Replication, WAL shipping, and queueing for Postgresql. 

Some of the Tools:

=== Londiste ===

Replication engine written in Python.  It uses PgQ as transport mechanism.
Its main goals are robustness and easy usage.


 * Tables can be added one-by-one into set.
 * Initial COPY for one table does not block event replay for other tables.
 * Can compare tables on both sides.
 * Supports sequences.
 * Easy installation.

=== PgQ ===

Generic queue implementation.  Based on ideas from [http://www.slony1.info/ Slony-I] -
snapshot based event batching.

''' Features '''

 * Generic multi-consumer, multi-producer queue.
 * There can be several consumers on one queue.
 * It is guaranteed that each of them sees a event at least once.
 But it's not guaranteed that it sees it only once.
 * The goal is to provide a clean API as SQL functions.  The frameworks
 on top of that don't need to understand internal details.

=== WalMgr ===

Python script for hot failover.  Tries to make setup
initial copy and later switch easy for admins.

=== txid ===

 Provides 8-byte transaction id-s for external usage.

=== logtriga ===

 Trigger function for table event logging in "partial SQL" format.
 Based on Slony-I logtrigger.  Used in londiste for replication.

=== logutriga ===

 Trigger function for table event logging in urlencoded format.
 Written in PL/Python. For cases where data manipulation is necessary.

== Developement frameworks ==

=== skytools - Python framework for database scripting ===

This collect various utilities for Python scripts for databases.
=== queue_mover ===

Simply copies all events from one queue to another.

=== scriptmgr ===

Allows to start and stop several scripts together.


Reproducible: Always

[Comment 1 Mike Weissman 2008-10-21 22:51:03 UTC]

Created attachment 169354 [details]
ebuild for version 2.1.8

Working on x86, and postgresql-server-8.3.4

[Comment 2 Mike Weissman 2008-10-24 16:38:12 UTC]

Created attachment 169734 [details]
Updated Ebuild

working on ~x86 and ~sparc with Postgresql-8.4.3

[Comment 3 Anatoly Shipitsin 2009-03-16 06:21:36 UTC]

Created attachment 185137 [details]
londiste conf file

[Comment 4 Anatoly Shipitsin 2009-03-16 06:21:58 UTC]

Created attachment 185139 [details]
pgqadm conf.d file

[Comment 5 Anatoly Shipitsin 2009-03-16 06:22:20 UTC]

Created attachment 185140 [details]
londiste init.d file

[Comment 6 Anatoly Shipitsin 2009-03-16 06:22:39 UTC]

Created attachment 185141 [details]
pgqadm init.d file

[Comment 7 Anatoly Shipitsin 2009-03-16 06:23:21 UTC]

Created attachment 185143 [details]
Updated skytools ebuild. Add londiste & pgqadm init files

[Comment 8 Anatoly Shipitsin 2009-03-16 06:24:19 UTC]

I'm add init scripts for londiste & pgqadm.

[Comment 9 Anatoly Shipitsin 2009-03-16 06:25:29 UTC]

Working on amd64, and postgresql-server-8.3.5
Added flag ~amd64.

[Comment 10 Andrey "Zed" Zaikin 2009-03-18 16:42:05 UTC]

You better put all these files into one tgz archive, so anyone who wants to install skytools don't need to move each file manually.

[Comment 11 Jeremy Olexa (darkside) (RETIRED) 2009-04-28 15:35:25 UTC]

(this is an automated message based on filtering criteria that matched this bug)
'EBUILD' is in the KEYWORDS which should mean that there is a ebuild attached 
to this bug.
This bug is assigned to maintainer-wanted which means that it is not in the 
main tree.
Heuristics show that no Gentoo developer has commented on your ebuild.

Hello, The Gentoo Team would like to firstly thank you for your ebuild 
submission. We also apologize for not being able to accommodate you in a timely
manner. There are simply too many new packages.

Allow me to use this opportunity to introduce you to Gentoo Sunrise. The 
sunrise overlay[1] is a overlay for Gentoo which we allow trusted users to 
commit to and all users can have ebuilds reviewed by Gentoo devs for entry 
into the overlay. So, the sunrise team is suggesting that you look into this 
and submit your ebuild to the overlay where even *you* can commit to. =)

Because this is a mass message, we are also asking you to be patient with us. 
We anticipate a large number of requests in a short time. 

Thanks,
On behalf of the Gentoo Sunrise Team,
Jeremy.

[1]: http://www.gentoo.org/proj/en/sunrise/
[2]: http://overlays.gentoo.org/proj/sunrise/wiki/SunriseFaq

[Comment 12 Oleg Gawriloff 2011-10-29 12:39:05 UTC]

Modified version of this ebuild available in my overlay at: http://code.google.com/p/barzog-gentoo-overlay/source/browse/#svn%2Ftrunk%2Fdev-db%2Fskytools

fixes some warnings about old EAPI and byte-compiling of *py.

[Comment 13 Jeroen Roovers (RETIRED) 2011-12-27 21:22:01 UTC]

*** Bug 396197 has been marked as a duplicate of this bug. ***

[Comment 14 Aaron W. Swenson 2017-12-21 17:12:55 UTC]

Upstream dead.