--- pgagent-3.3.0.orig/debian/README.Debian +++ pgagent-3.3.0/debian/README.Debian @@ -0,0 +1,31 @@ +Here is an abstract from the pgAdmin III documentation detailing steps +to get pgAgent up and running: + +pgAgent stores its configuration in the "postgres" database in your +cluster. This database exists by default in PostgreSQL 8.1 versions; +for earlier versions you need to create the database yourself. The +database must have the PL/pgSQL procedural language installed -- +PostgreSQL's 'createlang' program can do this if required. + +On Debian you can create the postgres database like this: + + Connect as the 'postgres' operating system user and execute the + following commands in a shell: + + postgres@anaconda:~$ createdb postgres + postgres@anaconda:~$ createlang plpgsql postgres + +Once created, connect to the new database and load the +/usr/share/pgadmin3/pgagent.sql file to the database. You can do this +with psql if you don't have pgAdmin III installed: + + postgres@anaconda:~$ psql postgres + + Launch the following command at the psql prompt: + + \i /usr/share/pgadmin3/pgagent.sql + +For more information, install pgadmin3 package and take a look at the +pgAdmin III online documentation. + + -- Raphael Enrici Fri, 14 Jul 2006 14:51:09 +0000 --- pgagent-3.3.0.orig/debian/README.source +++ pgagent-3.3.0/debian/README.source @@ -0,0 +1,2 @@ +This package uses quilt for its patch management, see +/usr/share/doc/quilt/README.source if you are unfamiliar with it. --- pgagent-3.3.0.orig/debian/changelog +++ pgagent-3.3.0/debian/changelog @@ -0,0 +1,32 @@ +pgagent (3.3.0-1) unstable; urgency=low + + * New upstream release. + * Update watch file to point to http://ftp.postgresql.org/pub/ + * Add myself to Uploaders. + + -- Christoph Berg Tue, 22 Oct 2013 12:00:42 +0200 + +pgagent (3.2.1-1) unstable; urgency=low + + * New upstream release. + * Relicense packaging under WTFPLv2. + * Add recommended targets build-{arch,indep} to debian/rules. + + -- Gerfried Fuchs Mon, 30 Apr 2012 20:04:50 +0200 + +pgagent (3.0.1-1) unstable; urgency=low + + * New upstream release, relicensed from Artistic License to BSD License, no + other changes. + * Switched Priority from extra to optional which is in the overrides file + anyway. + * Bumped Standards-Version to 3.8.3. + * Add README.source referencing quilt's one. + + -- Gerfried Fuchs Thu, 10 Sep 2009 21:45:42 +0200 + +pgagent (3.0.0-1) unstable; urgency=low + + * Initial release of pgagent in split source from pgadmin3. + + -- Gerfried Fuchs Sun, 05 Jul 2009 18:40:01 +0200 --- pgagent-3.3.0.orig/debian/compat +++ pgagent-3.3.0/debian/compat @@ -0,0 +1 @@ +7 --- pgagent-3.3.0.orig/debian/control +++ pgagent-3.3.0/debian/control @@ -0,0 +1,19 @@ +Source: pgagent +Section: database +Priority: optional +Maintainer: Gerfried Fuchs +Uploaders: Christoph Berg +Build-Depends: debhelper (>= 7), quilt, cmake, libwxgtk2.8-dev, libpq-dev (>= 8.1) +Standards-Version: 3.9.4 +Homepage: http://www.pgadmin.org/ +Vcs-Svn: svn://svn.debian.org/svn/pkg-postgresql/trunk/pgagent/ +Vcs-Browser: http://svn.debian.org/wsvn/pkg-postgresql/trunk/pgagent/?op=log + +Package: pgagent +Architecture: any +Depends: ${shlibs:Depends}, ${misc:Depends} +Suggests: pgadmin3 +Description: job scheduler for PostgreSQL + Introduced in pgAdmin III v1.4, pgAgent is a job scheduling agent for + PostgreSQL, capable of running multi-step batch/shell and SQL tasks on + complex schedules. --- pgagent-3.3.0.orig/debian/copyright +++ pgagent-3.3.0/debian/copyright @@ -0,0 +1,68 @@ +This package was debianized by Gerfried Fuchs on +Thu, 02 Jul 2009 10:46:46 +0200. + +It was downloaded from http://www.pgadmin.org/ + +Upstream Authors: + + * Dave Page (Project Leader): Project founder & primary developer. + email: + + * Jean-Michel Poure (Core Developer): Works primarily on project + management/IDE features. + email: + + Jean-Michel has decided to step down from the Team from Thursday 8th + May for 6 months in order to concentrate on his fight for freedom from + software patents in the European Union. + + * Mark Yeatman (Core Developer): Works on controls and consults on UI + design. + email: + + * Andreas Pflug (Core Developer): Has written vast amounts of pgAdmin + III code and is responsible for much of it's design. + email: + + * Frank Lupo (Core Developer): Has made countless improvements to the + pgAdmin II code from minor bug fixes to major enhancements. + email: + + +Copyright: + + Copyright (c) 2002 - 2009, The pgAdmin Development Team + +License: + + Permission to use, copy, modify, and distribute this software and its + documentation for any purpose, without fee, and without a written agreement is + hereby granted, provided that the above copyright notice and this paragraph and + the following two paragraphs appear in all copies. + + IN NO EVENT SHALL THE PGADMIN DEVELOPMENT TEAM BE LIABLE TO ANY PARTY FOR + DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST + PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF + THE PGADMIN DEVELOPMENT TEAM HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. + + THE PGADMIN DEVELOPMENT TEAM SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, + BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A + PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND + THE PGADMIN DEVELOPMENT TEAM HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, + UPDATES, ENHANCEMENTS, OR MODIFICATIONS. + +The debianization of the package is licensed under the WTFPLv2: + + DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE + Version 2, December 2004 + + Copyright (C) 2009-2012 Gerfried Fuchs + + Everyone is permitted to copy and distribute verbatim or modified + copies of this license document, and changing it is allowed as long + as the name is changed. + + DO WHAT THE FUCK YOU WANT TO PUBLIC LICENSE + TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION + + 0. You just DO WHAT THE FUCK YOU WANT TO. --- pgagent-3.3.0.orig/debian/patches/01_fix-CMakeLists.txt +++ pgagent-3.3.0/debian/patches/01_fix-CMakeLists.txt @@ -0,0 +1,23 @@ +Author: Gerfried Fuchs vim:ft=diff: +Description: Fix install destinations for sql files + +Index: pgagent-3.0.0/CMakeLists.txt +=================================================================== +--- pgagent-3.0.0.orig/CMakeLists.txt ++++ pgagent-3.0.0/CMakeLists.txt +@@ -130,13 +130,10 @@ IF (WIN32) + INSTALL(FILES ${pgagent_SOURCE_DIR}/pgagent_upgrade.sql DESTINATION .) + ELSE(WIN32) + INSTALL(TARGETS pgagent DESTINATION bin) +- INSTALL(FILES ${pgagent_SOURCE_DIR}/pgagent.sql DESTINATION share) +- INSTALL(FILES ${pgagent_SOURCE_DIR}/pgagent_upgrade.sql DESTINATION share) ++ INSTALL(FILES ${pgagent_SOURCE_DIR}/pgagent.sql DESTINATION share/pgadmin3) ++ INSTALL(FILES ${pgagent_SOURCE_DIR}/pgagent_upgrade.sql DESTINATION share/pgadmin3) + ENDIF(WIN32) + +-INSTALL(FILES ${pgagent_SOURCE_DIR}/README DESTINATION .) +-INSTALL(FILES ${pgagent_SOURCE_DIR}/LICENSE DESTINATION .) +- + ################################################################################ + # pgaevent + ################################################################################ --- pgagent-3.3.0.orig/debian/patches/series +++ pgagent-3.3.0/debian/patches/series @@ -0,0 +1 @@ +01_fix-CMakeLists.txt --- pgagent-3.3.0.orig/debian/pgagent.1 +++ pgagent-3.3.0/debian/pgagent.1 @@ -0,0 +1,47 @@ +.TH pgagent 1 "December 26, 2005" +.SH NAME +pgAgent \- a job scheduler for PostgreSQL. +.SH SYNOPSIS +\fBpgagent\fR [\-f | \-t \fBseconds\fR | \-r \fBseconds\fR | \-l \fBnumber\fR] {} +.SH DESCRIPTION +Introduced in pgAdmin III v1.4, pgAgent is a job scheduling agent +for PostgreSQL, capable of running multi\-step batch/shell and SQL tasks on +complex schedules. +.PP +Full documentation of pgAgent is available in pgAdmin III's online +help. Launch pgAdmin III (simply type pgadmin3 at command prompt) and +select "Help..." from the "Help" menu. Browse through the pgAdmin III +documentation until you find "pgAgent". Both database setup and system +part of the installation are detailed. You will also find instructions +to create jobs and schedules. +.SH OPTIONS +.TP +\fB\-f\fR +run in the foreground (do not detach from the +terminal) +.TP +\fB\-t\fR \fIseconds\fR +poll time interval in seconds (default 10) +.TP +\fB\-r\fR \fIseconds\fR +retry period after connection abort in seconds (>=10, +default 30) +.TP +\fB\-l\fR \fIverbosity\fR +logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default +0) +.TP +\fI\fR +The connect string required is a standard PostgreSQL libpq +connection string (see the PostgreSQL documentation for further +details). For example, the following command line will run pgAgent +against a server listening on the localhost, using a database called +\&'pgadmin', connecting as the user 'postgres': /usr/bin/pgagent +hostaddr=127.0.0.1 dbname=pgadmin user=postgres +.SH "SEE ALSO" +\fBpgadmin3\fR(1) +.SH AUTHORS +The content of this manual page was mostly ripped from documentation +written by the pgAdmin development team. It was built by Rapha\(:el Enrici + for the Debian project (but may be used +by others). --- pgagent-3.3.0.orig/debian/pgagent.manpages +++ pgagent-3.3.0/debian/pgagent.manpages @@ -0,0 +1 @@ +debian/pgagent.1 --- pgagent-3.3.0.orig/debian/pgagent.xml +++ pgagent-3.3.0/debian/pgagent.xml @@ -0,0 +1,128 @@ + + + + + pgagent + + 1 + December 26, 2005 + + + + pgAgent + + a job scheduler for PostgreSQL. + + + + + pgagent + + + -f + + -t seconds + + -r seconds + + -l number + + + <connect string> + + + + + DESCRIPTION + + Introduced in pgAdmin III v1.4, pgAgent is a job scheduling agent + for PostgreSQL, capable of running multi-step batch/shell and SQL tasks on + complex schedules. + + Full documentation of pgAgent is available in pgAdmin III's online + help. Launch pgAdmin III (simply type pgadmin3 at command prompt) and + select "Help..." from the "Help" menu. Browse through the pgAdmin III + documentation until you find "pgAgent". Both database setup and system + part of the installation are detailed. You will also find instructions + to create jobs and schedules. + + + + OPTIONS + + + + + + + run in the foreground (do not detach from the + terminal) + + + + + + + seconds + + + poll time interval in seconds (default 10) + + + + + + + seconds + + + retry period after connection abort in seconds (>=10, + default 30) + + + + + + + verbosity + + + logging verbosity (ERROR=0, WARNING=1, DEBUG=2, default + 0) + + + + + + + <connect string> + + + The connect string required is a standard PostgreSQL libpq + connection string (see the PostgreSQL documentation for further + details). For example, the following command line will run pgAgent + against a server listening on the localhost, using a database called + 'pgadmin', connecting as the user 'postgres': /usr/bin/pgagent + hostaddr=127.0.0.1 dbname=pgadmin user=postgres + + + + + + + SEE ALSO + + pgadmin3(1) + + + + AUTHORS + + The content of this manual page was mostly ripped from documentation + written by the pgAdmin development team. It was built by Raphaël Enrici + <blacknoz@club-internet.fr> for the Debian project (but may be used + by others). + + + --- pgagent-3.3.0.orig/debian/rules +++ pgagent-3.3.0/debian/rules @@ -0,0 +1,82 @@ +#!/usr/bin/make -f +# -*- makefile -*- +# Sample debian/rules that uses debhelper. +# This file was originally written by Joey Hess and Craig Small. +# As a special exception, when this file is copied by dh-make into a +# dh-make output file, you may use that output file without restriction. +# This special exception was added by Craig Small in version 0.37 of dh-make. + +# Uncomment this to turn on verbose mode. +#export DH_VERBOSE=1 + + +include /usr/share/quilt/quilt.make + + + +builddir/Makefile: patch + dh_testdir + # Add here commands to configure the package. + mkdir -p builddir + cd builddir && cmake .. -DCMAKE_INSTALL_PREFIX=/usr -DCMAKE_C_FLAGS="$(CFLAGS)" -DCMAKE_LD_FLAGS="-Wl,-z,defs" -DCMAKE_CXX_FLAGS="$(CXXFLAGS)" -DCMAKE_SKIP_RPATH=ON -DCMAKE_VERBOSE_MAKEFILE=ON -DwxWidgets_USE_STATIC=OFF -DWX_STATIC=OFF -DSTATIC_BUILD=OFF + + +build: build-arch build-indep +build-arch: build-stamp +build-indep: +build-stamp: builddir/Makefile + dh_testdir + + # Add here commands to compile the package. + $(MAKE) -C builddir + #docbook-to-man debian/pgagent.sgml > pgagent.1 + + touch $@ + +clean: unpatch + dh_testdir + dh_testroot + rm -f build-stamp + + # Add here commands to clean up after the build process. + rm -rf builddir + + + dh_clean + +install: build + dh_testdir + dh_testroot + dh_prep + dh_installdirs + + # Add here commands to install the package into debian/pgagent. + $(MAKE) -C builddir DESTDIR=$(CURDIR)/debian/pgagent install + + +# Build architecture-independent files here. +binary-indep: install +# We have nothing to do by default. + +# Build architecture-dependent files here. +binary-arch: install + dh_testdir + dh_testroot + dh_installchangelogs + dh_installdocs + dh_installexamples +# dh_install +# dh_installmenu + dh_installman + dh_link + dh_strip + dh_compress + dh_fixperms + dh_installdeb + dh_shlibdeps + dh_gencontrol + dh_md5sums + dh_builddeb + +binary: binary-indep binary-arch +.PHONY: build clean binary-indep binary-arch binary install --- pgagent-3.3.0.orig/debian/watch +++ pgagent-3.3.0/debian/watch @@ -0,0 +1,5 @@ +# Compulsory line, this is a version 3 file +version=3 + +# +http://ftp.postgresql.org/pub/pgadmin3/release/pgagent/ pgAgent-(.*)-Source.tar.gz