[gentoo-commits] repo/gentoo:master commit in: dev-db/pgagent/files/, dev-db/pgagent/

2022-03-27 Thread Conrad Kostecki
commit: 5c82757d6d951a51308de7ab1f4330deecce7b99
Author: Conrad Kostecki  gentoo  org>
AuthorDate: Sun Mar 27 19:32:25 2022 +
Commit: Conrad Kostecki  gentoo  org>
CommitDate: Sun Mar 27 19:32:51 2022 +
URL:https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=5c82757d

dev-db/pgagent: drop 4.0.0-r1

Closes: https://bugs.gentoo.org/781284
Signed-off-by: Conrad Kostecki  gentoo.org>

 dev-db/pgagent/Manifest|  1 -
 .../files/pgagent-4.0.0-pthreads-linking.patch | 33 -
 dev-db/pgagent/pgagent-4.0.0-r1.ebuild | 55 --
 3 files changed, 89 deletions(-)

diff --git a/dev-db/pgagent/Manifest b/dev-db/pgagent/Manifest
index d3bd5981bcec..9e64e509a8e8 100644
--- a/dev-db/pgagent/Manifest
+++ b/dev-db/pgagent/Manifest
@@ -1,2 +1 @@
-DIST pgAgent-4.0.0-Source.tar.gz 63561 BLAKE2B 
1731e748a6a5e76cd8b177162eb5b82ae633d1b507739e3193a8857a0eee0fe775fdaadb871eb5d708c0f7e80558680b5d7d246f4cb5d2bc1c10955bdf9cc09e
 SHA512 
df2d6f5817d83d4cf60f0f1106718225870bcfd2f5b882765e5fd459e1614208225f90b29de492bec5284f3727f3d4be9f724b92ef503fea08029fab22a8fbb4
 DIST pgAgent-4.2.1-Source.tar.gz 65583 BLAKE2B 
ee75803475dfbb751f1a81da5c3a6bec82aee80e9ce7d0413f94395069b5c0cbb6ff8770083078ce0e3a571a4c1b6d2e6adf6af8f0bfa9e8adfc862fff38d0d3
 SHA512 
778ca020ec23b3d042760cdcf84d3c2da8da48c8a648a812c2e79edfcc8912ab23cc1a1c29f379d6a56960cdd876164397b8fe6b21dd386a917a80eaa71c

diff --git a/dev-db/pgagent/files/pgagent-4.0.0-pthreads-linking.patch 
b/dev-db/pgagent/files/pgagent-4.0.0-pthreads-linking.patch
deleted file mode 100644
index 95f8e998f58f..
--- a/dev-db/pgagent/files/pgagent-4.0.0-pthreads-linking.patch
+++ /dev/null
@@ -1,33 +0,0 @@
-From 5b79460bdda286ca988b39e93e446176e8a781d1 Mon Sep 17 00:00:00 2001
-From: Neel Patel 
-Date: Fri, 20 Jul 2018 13:35:35 +0100
-Subject: [PATCH] Link with pthreads on non-Windows and non-macOS platforms.
-
-Patch based on feedback and initial work by Christoph Berg.

- CMakeLists.txt | 6 ++
- 1 file changed, 6 insertions(+)
-
-diff --git a/CMakeLists.txt b/CMakeLists.txt
-index 1be24da..6f1eaa0 100755
 a/CMakeLists.txt
-+++ b/CMakeLists.txt
-@@ -134,9 +134,15 @@ IF(WIN32)
- ENDIF(WIN32)
- 
- ADD_EXECUTABLE(pgagent ${_srcs})
-+IF(UNIX AND NOT APPLE)
-+TARGET_LINK_LIBRARIES(
-+pgagent ${PG_LIBRARIES} ${Boost_LIBRARIES} -pthread
-+)
-+ELSE()
- TARGET_LINK_LIBRARIES(
- pgagent ${PG_LIBRARIES} ${Boost_LIBRARIES}
- )
-+ENDIF()
- 
- # Installation
- IF (WIN32)
--- 
-2.24.1
-

diff --git a/dev-db/pgagent/pgagent-4.0.0-r1.ebuild 
b/dev-db/pgagent/pgagent-4.0.0-r1.ebuild
deleted file mode 100644
index 50120fe2593b..
--- a/dev-db/pgagent/pgagent-4.0.0-r1.ebuild
+++ /dev/null
@@ -1,55 +0,0 @@
-# Copyright 1999-2020 Gentoo Authors
-# Distributed under the terms of the GNU General Public License v2
-
-EAPI=7
-CMAKE_IN_SOURCE_BUILD=1
-
-inherit cmake-utils user
-
-MY_PN=${PN/a/A}
-
-KEYWORDS="amd64 x86"
-
-DESCRIPTION="${MY_PN} is a job scheduler for PostgreSQL"
-HOMEPAGE="https://www.pgadmin.org/download/pgagent-source-code/";
-SRC_URI="https://ftp.postgresql.org/pub/pgadmin/${PN}/${MY_PN}-${PV}-Source.tar.gz";
-
-LICENSE="POSTGRESQL GPL-2"
-SLOT="0"
-
-RDEPEND="dev-db/postgresql:*
-   dev-libs/boost
-"
-DEPEND="${RDEPEND}"
-
-S="${WORKDIR}/${MY_PN}-${PV}-Source"
-
-PATCHES=( "${FILESDIR}"/pgagent-4.0.0-pthreads-linking.patch )
-
-src_prepare() {
-   cmake-utils_src_prepare
-
-   sed -e "s:share):share/${P}):" \
-   -i CMakeLists.txt || die "failed to patch CMakeLists.txt"
-}
-
-src_configure() {
-   mycmakeargs=( "-DSTATIC_BUILD:BOOLEAN=FALSE"
-  )
-   cmake-utils_src_configure
-}
-
-src_install() {
-   cmake-utils_src_install
-
-   newinitd "${FILESDIR}/pgagent.initd-r1" "${PN}"
-   newconfd "${FILESDIR}/pgagent.confd" "${PN}"
-
-   rm "${ED}"/usr/{LICENSE,README} || die "failed to remove useless docs"
-}
-
-pkg_preinst() {
-   # This user needs a real shell, and the daemon will use the
-   # ~/.pgpass file from its home directory.
-   enewuser pgagent -1 /bin/bash /home/pgagent
-}



[gentoo-commits] repo/gentoo:master commit in: dev-db/pgagent/files/, dev-db/pgagent/

2020-02-18 Thread Aaron W. Swenson
commit: cf58dfea3eb65e157aa56bc11cc795b49c629c1c
Author: Aaron W. Swenson  gentoo  org>
AuthorDate: Tue Feb 18 19:03:37 2020 +
Commit: Aaron W. Swenson  gentoo  org>
CommitDate: Tue Feb 18 19:03:44 2020 +
URL:https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=cf58dfea

dev-db/pgagent: Fix pthread linking

Bug: https://bugs.gentoo.org/688472
Package-Manager: Portage-2.3.84, Repoman-2.3.16
Signed-off-by: Aaron W. Swenson  gentoo.org>

 .../files/pgagent-4.0.0-pthreads-linking.patch | 33 +
 dev-db/pgagent/pgagent-4.0.0-r1.ebuild | 55 ++
 2 files changed, 88 insertions(+)

diff --git a/dev-db/pgagent/files/pgagent-4.0.0-pthreads-linking.patch 
b/dev-db/pgagent/files/pgagent-4.0.0-pthreads-linking.patch
new file mode 100644
index 000..95f8e998f58
--- /dev/null
+++ b/dev-db/pgagent/files/pgagent-4.0.0-pthreads-linking.patch
@@ -0,0 +1,33 @@
+From 5b79460bdda286ca988b39e93e446176e8a781d1 Mon Sep 17 00:00:00 2001
+From: Neel Patel 
+Date: Fri, 20 Jul 2018 13:35:35 +0100
+Subject: [PATCH] Link with pthreads on non-Windows and non-macOS platforms.
+
+Patch based on feedback and initial work by Christoph Berg.
+---
+ CMakeLists.txt | 6 ++
+ 1 file changed, 6 insertions(+)
+
+diff --git a/CMakeLists.txt b/CMakeLists.txt
+index 1be24da..6f1eaa0 100755
+--- a/CMakeLists.txt
 b/CMakeLists.txt
+@@ -134,9 +134,15 @@ IF(WIN32)
+ ENDIF(WIN32)
+ 
+ ADD_EXECUTABLE(pgagent ${_srcs})
++IF(UNIX AND NOT APPLE)
++TARGET_LINK_LIBRARIES(
++pgagent ${PG_LIBRARIES} ${Boost_LIBRARIES} -pthread
++)
++ELSE()
+ TARGET_LINK_LIBRARIES(
+ pgagent ${PG_LIBRARIES} ${Boost_LIBRARIES}
+ )
++ENDIF()
+ 
+ # Installation
+ IF (WIN32)
+-- 
+2.24.1
+

diff --git a/dev-db/pgagent/pgagent-4.0.0-r1.ebuild 
b/dev-db/pgagent/pgagent-4.0.0-r1.ebuild
new file mode 100644
index 000..fe9014a136f
--- /dev/null
+++ b/dev-db/pgagent/pgagent-4.0.0-r1.ebuild
@@ -0,0 +1,55 @@
+# Copyright 1999-2020 Gentoo Authors
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=7
+CMAKE_IN_SOURCE_BUILD=1
+
+inherit cmake-utils user
+
+MY_PN=${PN/a/A}
+
+KEYWORDS="~amd64 ~x86"
+
+DESCRIPTION="${MY_PN} is a job scheduler for PostgreSQL"
+HOMEPAGE="https://www.pgadmin.org/download/pgagent-source-code/";
+SRC_URI="https://ftp.postgresql.org/pub/pgadmin/${PN}/${MY_PN}-${PV}-Source.tar.gz";
+
+LICENSE="POSTGRESQL GPL-2"
+SLOT="0"
+
+RDEPEND="dev-db/postgresql:*
+   dev-libs/boost
+"
+DEPEND="${RDEPEND}"
+
+S="${WORKDIR}/${MY_PN}-${PV}-Source"
+
+PATCHES=( "${FILESDIR}"/pgagent-4.0.0-pthreads-linking.patch )
+
+src_prepare() {
+   cmake-utils_src_prepare
+
+   sed -e "s:share):share/${P}):" \
+   -i CMakeLists.txt || die "failed to patch CMakeLists.txt"
+}
+
+src_configure() {
+   mycmakeargs=( "-DSTATIC_BUILD:BOOLEAN=FALSE"
+  )
+   cmake-utils_src_configure
+}
+
+src_install() {
+   cmake-utils_src_install
+
+   newinitd "${FILESDIR}/pgagent.initd-r1" "${PN}"
+   newconfd "${FILESDIR}/pgagent.confd" "${PN}"
+
+   rm "${ED}"/usr/{LICENSE,README} || die "failed to remove useless docs"
+}
+
+pkg_preinst() {
+   # This user needs a real shell, and the daemon will use the
+   # ~/.pgpass file from its home directory.
+   enewuser pgagent -1 /bin/bash /home/pgagent
+}



[gentoo-commits] repo/gentoo:master commit in: dev-db/pgagent/files/, dev-db/pgagent/

2018-02-06 Thread Michael Orlitzky
commit: b49eb9e14ad0df4a6a7bd145657430a6a90d2b91
Author: Michael Orlitzky  gentoo  org>
AuthorDate: Wed Feb  7 03:06:51 2018 +
Commit: Michael Orlitzky  gentoo  org>
CommitDate: Wed Feb  7 03:06:51 2018 +
URL:https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=b49eb9e1

dev-db/pgagent: remove "unused" pgagent-3.4.0-r1.ebuild.

Package-Manager: Portage-2.3.19, Repoman-2.3.6

 dev-db/pgagent/files/pgagent.initd | 24 ---
 dev-db/pgagent/pgagent-3.4.0-r1.ebuild | 55 --
 2 files changed, 79 deletions(-)

diff --git a/dev-db/pgagent/files/pgagent.initd 
b/dev-db/pgagent/files/pgagent.initd
deleted file mode 100644
index a43916888bb..000
--- a/dev-db/pgagent/files/pgagent.initd
+++ /dev/null
@@ -1,24 +0,0 @@
-#!/sbin/openrc-run
-# Copyright 1999-2012 Gentoo Foundation
-# Distributed under the terms of the GNU General Public License v2
-
-PGAGENTOPT="-t ${PGA_POLL} -r ${PGA_RETRY} -s ${PGA_LOG} -l ${PGA_LEVEL}"
-
-PGOPT="hostaddr=${PG_HOST} dbname=${PG_DBNAME} user=${PG_USER}"
-
-depend() {
-use net
-need postgresql
-}
-
-start() {
-ebegin "Starting pgagent"
-start-stop-daemon --start --exec /usr/bin/pgagent -- ${PGAGENTOPT} ${PGOPT}
-eend $?
-}
-
-stop() {
-ebegin "Stopping pgagent"
-start-stop-daemon --stop --name pgagent
-eend $?
-}

diff --git a/dev-db/pgagent/pgagent-3.4.0-r1.ebuild 
b/dev-db/pgagent/pgagent-3.4.0-r1.ebuild
deleted file mode 100644
index aed37174e31..000
--- a/dev-db/pgagent/pgagent-3.4.0-r1.ebuild
+++ /dev/null
@@ -1,55 +0,0 @@
-# Copyright 1999-2017 Gentoo Foundation
-# Distributed under the terms of the GNU General Public License v2
-
-EAPI="5"
-CMAKE_IN_SOURCE_BUILD=1
-WX_GTK_VER="3.0"
-
-inherit cmake-utils eutils wxwidgets
-
-MY_PN=${PN/a/A}
-
-KEYWORDS="amd64 x86"
-
-DESCRIPTION="${MY_PN} is a job scheduler for PostgreSQL"
-HOMEPAGE="http://www.pgadmin.org/download/pgagent.php";
-SRC_URI="mirror://postgresql/pgadmin3/release/${PN}/${MY_PN}-${PV}-Source.tar.gz"
-LICENSE="POSTGRESQL GPL-2"
-SLOT="0"
-IUSE=""
-
-RDEPEND=">=dev-db/postgresql-9.0.0:*
-x11-libs/wxGTK:${WX_GTK_VER}
-"
-DEPEND="${RDEPEND}
-   >=dev-util/cmake-2.6
-"
-
-S="${WORKDIR}/${MY_PN}-${PV}-Source"
-
-src_prepare() {
-   cmake-utils_src_prepare
-
-   sed -e "s:share):share/${P}):" \
-   -i CMakeLists.txt || die "Couldn't patch CMakeLists.txt"
-   sed -i -e '/SET(WX_VERSION "2.8")/d' CMakeLists.txt || die
-}
-
-src_configure() {
-   if has_version "x11-libs/wxGTK[X]"; then
-   need-wxwidgets unicode
-   else
-   need-wxwidgets base-unicode
-   fi
-   mycmakeargs="-DSTATIC_BUILD:BOOLEAN=FALSE -DWX_VERSION=${WX_GTK_VER}"
-   cmake-utils_src_configure
-}
-
-src_install() {
-   cmake-utils_src_install
-
-   newinitd "${FILESDIR}/pgagent.initd" ${PN}
-   newconfd "${FILESDIR}/pgagent.confd" ${PN}
-
-   rm "${ED}"/usr/{LICENSE,README} || die "Failed to remove useless docs"
-}



[gentoo-commits] repo/gentoo:master commit in: dev-db/pgagent/files/, dev-db/pgagent/

2017-08-16 Thread Michael Orlitzky
commit: a244d75fc8320b34929a09fd93140a8b00aa95ee
Author: Michael Orlitzky  gentoo  org>
AuthorDate: Wed Aug 16 13:48:48 2017 +
Commit: Michael Orlitzky  gentoo  org>
CommitDate: Wed Aug 16 13:52:16 2017 +
URL:https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=a244d75f

dev-db/pgagent: new patch to fix building against postgres-10.x.

The pgAgent build system didn't support a two-digit version of
postgres, so pgagent failed to build against (for example)
dev-db/postgresql-10_beta3. This has been fixed upstream but not yet
released, so this commit cherry-picks that upstream commit as a patch
and adds it (in-place) to the latest pgagent-3.4.0-r2.ebuild.

Gentoo-Bug: 625878

Package-Manager: Portage-2.3.6, Repoman-2.3.1

 dev-db/pgagent/files/postgres-10-build-fix.patch | 52 
 dev-db/pgagent/pgagent-3.4.0-r2.ebuild   |  2 +
 2 files changed, 54 insertions(+)

diff --git a/dev-db/pgagent/files/postgres-10-build-fix.patch 
b/dev-db/pgagent/files/postgres-10-build-fix.patch
new file mode 100644
index 000..e2ecb0aa60b
--- /dev/null
+++ b/dev-db/pgagent/files/postgres-10-build-fix.patch
@@ -0,0 +1,52 @@
+From a7b82fb3d3bd3de3ce624d9e4b0da53cb9835c2d Mon Sep 17 00:00:00 2001
+From: Ashesh Vashi 
+Date: Mon, 31 Jul 2017 14:57:55 +0530
+Subject: [PATCH] Added support two digits version for PostgreSQL/EDB Postgres
+ Advanced Server >= 10
+
+---
+ CMakeLists.txt | 6 +-
+ cmake/FindPG.cmake | 6 +++---
+ 2 files changed, 8 insertions(+), 4 deletions(-)
+
+diff --git a/CMakeLists.txt b/CMakeLists.txt
+index 8214650..29755b4 100755
+--- a/CMakeLists.txt
 b/CMakeLists.txt
+@@ -176,7 +176,11 @@ MESSAGE(STATUS "  Description : 
${CPACK_PACKAGE_DESCRIPTION_SUMM
+ MESSAGE(STATUS "  Version : ${VERSION}")
+ MESSAGE(STATUS " ")
+ MESSAGE(STATUS "  PostgreSQL version string   : ${PG_VERSION_STRING}")
+-MESSAGE(STATUS "  PostgreSQL version parts: 
${PG_MAJOR_VERSION}.${PG_MINOR_VERSION}.${PG_PATCH_VERSION}")
++IF(${PG_MAJOR_VERSION} GREATER 9)
++  MESSAGE(STATUS "  PostgreSQL version parts: ${PG_MAJOR_VERSION}")
++ELSE()
++  MESSAGE(STATUS "  PostgreSQL version parts: 
${PG_MAJOR_VERSION}.${PG_MINOR_VERSION}")
++ENDIF(${PG_MAJOR_VERSION} GREATER 10)
+ MESSAGE(STATUS "  PostgreSQL path : ${PG_ROOT_DIR}")
+ MESSAGE(STATUS "  PostgreSQL config binary: ${PG_CONFIG_PATH}")
+ MESSAGE(STATUS "  PostgreSQL include path : ${PG_INCLUDE_DIRS}")
+diff --git a/cmake/FindPG.cmake b/cmake/FindPG.cmake
+index 349086c..9768771 100644
+--- a/cmake/FindPG.cmake
 b/cmake/FindPG.cmake
+@@ -28,7 +28,6 @@
+ # PG_VERSION_STRING - The PostgreSQL version number.
+ # PG_MAJOR_VERSION - The PostgreSQL major version (x in x.y.z).
+ # PG_MINOR_VERSION - The PostgreSQL minor version (y in x.y.z).
+-# PG_PATCH_VERSION - The PostgreSQL patch version (z in x.y.z).
+ # PG_EXTENSION - Set to TRUE if PostgreSQL supports extensions.
+ 
+ IF(NOT PG_STATIC OR PG_STATIC STREQUAL "")
+@@ -70,8 +69,9 @@ IF(NOT _retval)
+ # Split the version into its component parts.
+ STRING(REGEX MATCHALL "[0-9]+" PG_VERSION_PARTS "${PG_VERSION_STRING}")
+ LIST(GET PG_VERSION_PARTS 0 PG_MAJOR_VERSION)
+-LIST(GET PG_VERSION_PARTS 1 PG_MINOR_VERSION)
+-LIST(GET PG_VERSION_PARTS 2 PG_PATCH_VERSION)
++IF((PG_MAJOR_VERSION LESS 10))
++LIST(GET PG_VERSION_PARTS 1 PG_MINOR_VERSION)
++ENDIF((PG_MAJOR_VERSION LESS 10))
+ 
+ # Are extensions supported?
+ IF((PG_MAJOR_VERSION GREATER 9) OR ((PG_MAJOR_VERSION EQUAL 9) AND 
(PG_MINOR_VERSION GREATER 0)))

diff --git a/dev-db/pgagent/pgagent-3.4.0-r2.ebuild 
b/dev-db/pgagent/pgagent-3.4.0-r2.ebuild
index 9f44b6fff0f..e71c4b87d44 100644
--- a/dev-db/pgagent/pgagent-3.4.0-r2.ebuild
+++ b/dev-db/pgagent/pgagent-3.4.0-r2.ebuild
@@ -24,6 +24,8 @@ DEPEND="${RDEPEND}"
 
 S="${WORKDIR}/${MY_PN}-${PV}-Source"
 
+PATCHES=( "${FILESDIR}/postgres-10-build-fix.patch" )
+
 src_prepare() {
default
sed -e "s:share):share/${P}):" \



[gentoo-commits] repo/gentoo:master commit in: dev-db/pgagent/files/, dev-db/pgagent/

2017-08-15 Thread Michael Orlitzky
commit: 5b41b4fb3fc10a2b4046fb2c8c97d9b824505f20
Author: Michael Orlitzky  gentoo  org>
AuthorDate: Wed Aug 16 05:15:21 2017 +
Commit: Michael Orlitzky  gentoo  org>
CommitDate: Wed Aug 16 05:15:21 2017 +
URL:https://gitweb.gentoo.org/repo/gentoo.git/commit/?id=5b41b4fb

dev-db/pgagent: new revision with a dedicated "pgagent" user.

The pgagent daemon used to run as root, which can be dangerous. That
system user is used to execute the database jobs, meaning that a
non-root user with permission to schedule pgagent jobs could gain
root. This new revision creates a dedicated "pgagent" system user,
and the new init script launches the daemon as that user.

An ewarn lets users know that some migration work may be needed.

Gentoo-Bug: 537264

Package-Manager: Portage-2.3.6, Repoman-2.3.1

 dev-db/pgagent/files/pgagent.initd-r1  | 31 +++
 dev-db/pgagent/pgagent-3.4.0-r2.ebuild | 69 ++
 2 files changed, 100 insertions(+)

diff --git a/dev-db/pgagent/files/pgagent.initd-r1 
b/dev-db/pgagent/files/pgagent.initd-r1
new file mode 100644
index 000..a555006d3bd
--- /dev/null
+++ b/dev-db/pgagent/files/pgagent.initd-r1
@@ -0,0 +1,31 @@
+#!/sbin/openrc-run
+# Copyright 1999-2017 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+
+command="/usr/bin/pgagent"
+command_user="pgagent"
+
+# If pgagent daemonizes itself, it won't write a PID file and
+# we have to work a little harder to stop() it. So let it run
+# in the foreground, and have OpenRC manage its PID file.
+command_args="-f
+  -t ${PGA_POLL}
+  -r ${PGA_RETRY}
+  -s ${PGA_LOG}
+  -l ${PGA_LEVEL}
+  hostaddr=${PG_HOST}
+  dbname=${PG_DBNAME}
+  user=${PG_USER}"
+
+command_background="true"
+pidfile="/run/pgagent.pid"
+
+depend() {
+use net
+need postgresql
+}
+
+start_pre() {
+# The log file needs to be writable by the daemon user.
+checkpath --file --owner root:pgagent --mode 0660 "${PGA_LOG}"
+}

diff --git a/dev-db/pgagent/pgagent-3.4.0-r2.ebuild 
b/dev-db/pgagent/pgagent-3.4.0-r2.ebuild
new file mode 100644
index 000..9f44b6fff0f
--- /dev/null
+++ b/dev-db/pgagent/pgagent-3.4.0-r2.ebuild
@@ -0,0 +1,69 @@
+# Copyright 1999-2017 Gentoo Foundation
+# Distributed under the terms of the GNU General Public License v2
+
+EAPI=6
+CMAKE_IN_SOURCE_BUILD=1
+WX_GTK_VER="3.0"
+
+inherit cmake-utils user wxwidgets
+
+MY_PN=${PN/a/A}
+
+KEYWORDS="~amd64 ~x86"
+
+DESCRIPTION="${MY_PN} is a job scheduler for PostgreSQL"
+HOMEPAGE="http://www.pgadmin.org/download/pgagent.php";
+SRC_URI="mirror://postgresql/pgadmin3/release/${PN}/${MY_PN}-${PV}-Source.tar.gz"
+LICENSE="POSTGRESQL GPL-2"
+SLOT="0"
+IUSE=""
+
+RDEPEND="dev-db/postgresql:*
+x11-libs/wxGTK:${WX_GTK_VER}"
+DEPEND="${RDEPEND}"
+
+S="${WORKDIR}/${MY_PN}-${PV}-Source"
+
+src_prepare() {
+   default
+   sed -e "s:share):share/${P}):" \
+   -i CMakeLists.txt || die "failed to patch CMakeLists.txt"
+   sed -i -e '/SET(WX_VERSION "2.8")/d' CMakeLists.txt || die
+}
+
+src_configure() {
+   if has_version "x11-libs/wxGTK[X]"; then
+   need-wxwidgets unicode
+   else
+   need-wxwidgets base-unicode
+   fi
+   mycmakeargs=( "-DSTATIC_BUILD:BOOLEAN=FALSE"
+ "-DWX_VERSION=${WX_GTK_VER}" )
+   cmake-utils_src_configure
+}
+
+src_install() {
+   cmake-utils_src_install
+
+   newinitd "${FILESDIR}/pgagent.initd-r1" "${PN}"
+   newconfd "${FILESDIR}/pgagent.confd" "${PN}"
+
+   rm "${ED}"/usr/{LICENSE,README} || die "failed to remove useless docs"
+}
+
+pkg_preinst() {
+   # This user needs a real shell, and the daemon will use the
+   # ~/.pgpass file from its home directory.
+   enewuser pgagent -1 /bin/bash /home/pgagent
+}
+
+pkg_postinst() {
+   if [[ -n "${REPLACING_VERSIONS}" ]]; then
+   # This warning can be removed around a year after this version
+   # goes stable.
+   ewarn 'pgAgent now runs as a dedicated "pgagent" user (as'
+   ewarn 'opposed to root). You may need to move your 
/root/.pgpass'
+   ewarn 'file to /home/pgagent/.pgpass, and the new user will'
+   ewarn 'need permissions on any paths that it will access.'
+   fi
+}