Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 243158

Summary: Ebuild for dev-db/skytools
Product: Gentoo Linux Reporter: Mike Weissman <mike>
Component: New packagesAssignee: Default Assignee for New Packages <maintainer-wanted>
Status: RESOLVED WONTFIX    
Severity: enhancement CC: i.andriyanov, pgsql-bugs
Priority: High Keywords: EBUILD
Version: unspecified   
Hardware: x86   
OS: Linux   
URL: http://pgfoundry.org/projects/skytools/
Whiteboard: sunrise suggested
Package list:
Runtime testing required: ---
Attachments: ebuild for version 2.1.8
Updated Ebuild
londiste conf file
pgqadm conf.d file
londiste init.d file
pgqadm init.d file
Updated skytools ebuild. Add londiste & pgqadm init files

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) archtester gentoo-dev Security 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) gentoo-dev 2011-12-27 21:22:01 UTC
*** Bug 396197 has been marked as a duplicate of this bug. ***
Comment 14 Aaron W. Swenson gentoo-dev 2017-12-21 17:12:55 UTC
Upstream dead.