Skip to contentSkip to conversation

pgpool2: Added a new recipe.

PATCH In review Lei Maohui 2 participants 4 messages Jan 9, 2023 – Jan 11, 2023

lore
Share & tools
lore

Lei Maohui

author
#0 lore raw

PATCH 1/1 pgpool2: Added a new recipe.

Pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It is distributed under a license similar to BSD and MIT. It provides the following features.

---
 .../recipes-support/pgpool2/pgpool2/pgpool.service | 17 ++++++++
 .../pgpool2/pgpool2/pgpool.sysconfig               |  7 ++++
 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb   | 46 ++++++++++++++++++++++
 3 files changed, 70 insertions(+)
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service new file +17 -0
new file mode 100644
index 0000000..bf2d323
@@ -0,0 +1,17 @@
+[Unit]
+Description=Pgpool-II
+After=syslog.target network.target
+
+[Service]
+
+User=postgres
+Group=postgres
+
+EnvironmentFile=-/etc/sysconfig/pgpool
+
+ExecStart=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $OPTS
+ExecStop=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $STOP_OPTS stop
+ExecReload=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf reload
+
+[Install]
+WantedBy=multi-user.target
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig new file +7 -0
new file mode 100644
index 0000000..ea13089
@@ -0,0 +1,7 @@
+# Options for pgpool
+
+# -n: don't run in daemon mode. does not detach control tty
+# -d: debug mode. lots of debug information will be printed
+
+#OPTS=" -d -n"
+OPTS=" -n"
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +46 -0

46 lines not on this page · raw message

Signature · 1 line
1.8.3.1
#1 lore raw

fails to build on qemuarm/glibc and other various combinations with same error as

https://errors.yoctoproject.org/Errors/Details/687226/

Quoted 113 lines · leimaohui

Pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It is distributed under a license similar to BSD and MIT. It provides the following features.

---
 .../recipes-support/pgpool2/pgpool2/pgpool.service | 17 ++++++++
 .../pgpool2/pgpool2/pgpool.sysconfig               |  7 ++++
 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb   | 46 ++++++++++++++++++++++
 3 files changed, 70 insertions(+)
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service new file +17 -0
new file mode 100644
index 0000000..bf2d323
@@ -0,0 +1,17 @@
+[Unit]
+Description=Pgpool-II
+After=syslog.target network.target
+
+[Service]
+
+User=postgres
+Group=postgres
+
+EnvironmentFile=-/etc/sysconfig/pgpool
+
+ExecStart=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $OPTS
+ExecStop=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $STOP_OPTS stop
+ExecReload=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf reload
+
+[Install]
+WantedBy=multi-user.target
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig new file +7 -0
new file mode 100644
index 0000000..ea13089
@@ -0,0 +1,7 @@
+# Options for pgpool
+
+# -n: don't run in daemon mode. does not detach control tty
+# -d: debug mode. lots of debug information will be printed
+
+#OPTS=" -d -n"
+OPTS=" -n"
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +46 -1
new file mode 100644
index 0000000..52e0192
@@ -0,0 +1,46 @@
+SUMMARY = "a language independent connection pool server for PostgreSQL."
+
+DESCRIPTION = "Pgpool-II is a middleware that works between PostgreSQL \
+               servers and a PostgreSQL database client. It is distributed \
+               under a license similar to BSD and MIT. It provides the \
+               following features."
+
+HOMEPAGE = "http://pgpool.net"
+
+LICENSE = "BSD-2-Clause"
+LIC_FILES_CHKSUM = "file://COPYING;md5=e4b38de086d73e0521de0bbdbaa4a1a9"
+
+SRC_URI = "http://www.pgpool.net/mediawiki/images/pgpool-II-${PV}.tar.gz \
+          file://pgpool.sysconfig \
+          file://pgpool.service \
+           "
+SRC_URI[sha256sum] = "4b379bbba8e178128a1cee4a5bd1ae116dedb3da6121b728c18f0f54c881f328"
+
+S = "${WORKDIR}/pgpool-II-${PV}"
+
+inherit autotools systemd
+
+SYSTEMD_SERVICE:${PN} = "pgpool.service"
+
+PACKAGECONFIG ??= " openssl libmemcached postgresql \
+    ${@bb.utils.filter('DISTRO_FEATURES', 'pam', d)} \
+    "
+PACKAGECONFIG[pam] = "--with-pam,--without-pam,libpam,"
+PACKAGECONFIG[openssl] = "--with-openssl,--without-openssl,openssl"
+PACKAGECONFIG[libmemcached] = "--with-memcached=${STAGING_INCDIR}/libmemcachedutil-1.0,--without-memcached,libmemcached"
+PACKAGECONFIG[postgresql] = "--with-pgsql-includedir=${STAGING_INCDIR}/postgresql --with-pgsql=${bindir} ,,postgresql"
+
+EXTRA_OECONF += "-disable-static \
+               "
+B = "${S}"
+CFLAGS:append = " -fcommon "
+
+FILES:${PN} += "${datadir}/pgpool-II/ "
+
+do_install:append() {
+    install -d ${D}${sysconfdir}/pgpool-II
+    install -D -m 0644 ${WORKDIR}/pgpool.sysconfig  ${D}${sysconfdir}/pgpool-II/pgpool.conf
+    install -D -m 0644 ${S}/src/sample/pcp.conf.sample ${D}${sysconfdir}/pgpool-II/pcp.conf
+    install -D -m 0644 ${S}/src/sample/pool_hba.conf.sample ${D}${sysconfdir}/pgpool-II/pool_hba.conf
+    install -Dm 0644 ${WORKDIR}/pgpool.service ${D}${systemd_system_unitdir}/pgpool.service
+}
--

1.8.3.1

-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#100478): https://lists.openembedded.org/g/openembedded-devel/message/100478
Mute This Topic: https://lists.openembedded.org/mt/96146690/1997914
Group Owner: [email protected]
Unsubscribe: https://lists.openembedded.org/g/openembedded-devel/unsub [[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-

#2 lore raw

also see the dependency problems

https://autobuilder.yoctoproject.org/typhoon/#/builders/88/builds/2339

Quoted 120 lines · Khem Raj

fails to build on qemuarm/glibc and other various combinations with same error as

https://errors.yoctoproject.org/Errors/Details/687226/

Quoted 113 lines · leimaohui

Pgpool-II is a middleware that works between PostgreSQL servers and a PostgreSQL database client. It is distributed under a license similar to BSD and MIT. It provides the following features.

---
 .../recipes-support/pgpool2/pgpool2/pgpool.service | 17 ++++++++
 .../pgpool2/pgpool2/pgpool.sysconfig               |  7 ++++
 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb   | 46 ++++++++++++++++++++++
 3 files changed, 70 insertions(+)
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service new file +17 -0
new file mode 100644
index 0000000..bf2d323
@@ -0,0 +1,17 @@
+[Unit]
+Description=Pgpool-II
+After=syslog.target network.target
+
+[Service]
+
+User=postgres
+Group=postgres
+
+EnvironmentFile=-/etc/sysconfig/pgpool
+
+ExecStart=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $OPTS
+ExecStop=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $STOP_OPTS stop
+ExecReload=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf reload
+
+[Install]
+WantedBy=multi-user.target
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig new file +7 -0
new file mode 100644
index 0000000..ea13089
@@ -0,0 +1,7 @@
+# Options for pgpool
+
+# -n: don't run in daemon mode. does not detach control tty
+# -d: debug mode. lots of debug information will be printed
+
+#OPTS=" -d -n"
+OPTS=" -n"
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +46 -1
new file mode 100644
index 0000000..52e0192
@@ -0,0 +1,46 @@
+SUMMARY = "a language independent connection pool server for PostgreSQL."
+
+DESCRIPTION = "Pgpool-II is a middleware that works between PostgreSQL \
+               servers and a PostgreSQL database client. It is distributed \
+               under a license similar to BSD and MIT. It provides the \
+               following features."
+
+HOMEPAGE = "http://pgpool.net"
+
+LICENSE = "BSD-2-Clause"
+LIC_FILES_CHKSUM = "file://COPYING;md5=e4b38de086d73e0521de0bbdbaa4a1a9"
+
+SRC_URI = "http://www.pgpool.net/mediawiki/images/pgpool-II-${PV}.tar.gz \
+          file://pgpool.sysconfig \
+          file://pgpool.service \
+           "
+SRC_URI[sha256sum] = "4b379bbba8e178128a1cee4a5bd1ae116dedb3da6121b728c18f0f54c881f328"
+
+S = "${WORKDIR}/pgpool-II-${PV}"
+
+inherit autotools systemd
+
+SYSTEMD_SERVICE:${PN} = "pgpool.service"
+
+PACKAGECONFIG ??= " openssl libmemcached postgresql \
+    ${@bb.utils.filter('DISTRO_FEATURES', 'pam', d)} \
+    "
+PACKAGECONFIG[pam] = "--with-pam,--without-pam,libpam,"
+PACKAGECONFIG[openssl] = "--with-openssl,--without-openssl,openssl"
+PACKAGECONFIG[libmemcached] = "--with-memcached=${STAGING_INCDIR}/libmemcachedutil-1.0,--without-memcached,libmemcached"
+PACKAGECONFIG[postgresql] = "--with-pgsql-includedir=${STAGING_INCDIR}/postgresql --with-pgsql=${bindir} ,,postgresql"
+
+EXTRA_OECONF += "-disable-static \
+               "
+B = "${S}"
+CFLAGS:append = " -fcommon "
+
+FILES:${PN} += "${datadir}/pgpool-II/ "
+
+do_install:append() {
+    install -d ${D}${sysconfdir}/pgpool-II
+    install -D -m 0644 ${WORKDIR}/pgpool.sysconfig  ${D}${sysconfdir}/pgpool-II/pgpool.conf
+    install -D -m 0644 ${S}/src/sample/pcp.conf.sample ${D}${sysconfdir}/pgpool-II/pcp.conf
+    install -D -m 0644 ${S}/src/sample/pool_hba.conf.sample ${D}${sysconfdir}/pgpool-II/pool_hba.conf
+    install -Dm 0644 ${WORKDIR}/pgpool.service ${D}${systemd_system_unitdir}/pgpool.service
+}
--

1.8.3.1

-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group.
View/Reply Online (#100478): https://lists.openembedded.org/g/openembedded-devel/message/100478
Mute This Topic: https://lists.openembedded.org/mt/96146690/1997914
Group Owner: [email protected]
Unsubscribe: https://lists.openembedded.org/g/openembedded-devel/unsub [[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-

#3 lore raw

Hi,

Quoted 1 line

https://autobuilder.yoctoproject.org/typhoon/#/builders/88/builds/2339

I'm sorry I can't reproduce the dependency problems:

stdio: ERROR: Nothing PROVIDES 'libmemcached' (but /home/pokybuild/yocto-worker/meta-oe/build/meta-openembedded/meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb DEPENDS on or otherwise requires it)
stdio: ERROR: Required build target 'meta-world-pkgdata' has no buildable providers.
stdio: ERROR: Nothing PROVIDES 'libmemcached' (but /home/pokybuild/yocto-worker/meta-oe/build/meta-openembedded/meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb DEPENDS on or otherwise requires it)
stdio: ERROR: Required build target 'meta-world-pkgdata' has no buildable providers.
stdio: ERROR: Nothing PROVIDES 'libmemcached' (but /home/pokybuild/yocto-worker/meta-oe/build/meta-openembedded/meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb DEPENDS on or otherwise requires it)
stdio: ERROR: Required build target 'meta-world-pkgdata' has no buildable providers.

And I found it strange that the recipe of 'libmemcached' was in meta-networking:recipes-support/libmemcached/libmemcached_1.0.18.bb. Why did this error occur?

Best regards
Lei

Quoted 158 lines

-----Original Message-----
From: Khem Raj <[email protected]>
Sent: Tuesday, January 10, 2023 12:59 AM
To: Lei, Maohui <[email protected]>
Cc: [email protected]
Subject: Re: [oe] [meta-oe][PATCH] pgpool2: Added a new recipe.

also see the dependency problems

https://autobuilder.yoctoproject.org/typhoon/#/builders/88/builds/2339

Quoted 9 lines · Khem Raj

fails to build on qemuarm/glibc and other various combinations with same error as

https://errors.yoctoproject.org/Errors/Details/687226/

Quoted 2 lines · leimaohui

Pgpool-II is a middleware that works between PostgreSQL servers and a

PostgreSQL database client. It is distributed under a license similar to BSD and MIT. It provides the following features.

Quoted 6 lines
Quoted 6 lines
---
 .../recipes-support/pgpool2/pgpool2/pgpool.service | 17 ++++++++
 .../pgpool2/pgpool2/pgpool.sysconfig               |  7 ++++
 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb   | 46

++++++++++++++++++++++

Quoted 47 lines
Quoted 47 lines
 3 files changed, 70 insertions(+)
 create mode 100644
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service
 create mode 100644
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig
 create mode 100644 meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb
meta-oe/recipes-support/pgpool2/pgpool2/pgpool.service new file +18 -0
new file mode 100644
index 0000000..bf2d323
@@ -0,0 +1,17 @@
+[Unit]
+Description=Pgpool-II
+After=syslog.target network.target
+
+[Service]
+
+User=postgres
+Group=postgres
+
+EnvironmentFile=-/etc/sysconfig/pgpool
+
+ExecStart=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $OPTS
+ExecStop=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf $STOP_OPTS
+stop ExecReload=/usr/bin/pgpool -f /etc/pgpool-II/pgpool.conf
+reload
+
+[Install]
+WantedBy=multi-user.target

diff --git a/meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig b/meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig new file mode 100644
index 0000000..ea13089

meta-oe/recipes-support/pgpool2/pgpool2/pgpool.sysconfig new file +7 -0
@@ -0,0 +1,7 @@
+# Options for pgpool
+
+# -n: don't run in daemon mode. does not detach control tty # -d:
+debug mode. lots of debug information will be printed
+
+#OPTS=" -d -n"
+OPTS=" -n"
Quoted 8 lines

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb line 1

Quoted 8 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +1 -0
new file mode 100644
index 0000000..52e0192
@@ -0,0 +1,46 @@
+SUMMARY = "a language independent connection pool server for

PostgreSQL."

Quoted 10 lines

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb

Quoted 10 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +10 -0
+
+DESCRIPTION = "Pgpool-II is a middleware that works between PostgreSQL \
+               servers and a PostgreSQL database client. It is distributed \
+               under a license similar to BSD and MIT. It provides the \
+               following features."
+
+HOMEPAGE = "http://pgpool.net"
+
+LICENSE = "BSD-2-Clause"
+LIC_FILES_CHKSUM =

"file://COPYING;md5=e4b38de086d73e0521de0bbdbaa4a1a9"

Quoted 2 lines

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb line 13

Quoted 2 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +2 -0
+
+SRC_URI = "http://www.pgpool.net/mediawiki/images/pgpool-II-${PV}.tar.gz

\

Quoted 4 lines

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb

Quoted 4 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +4 -0
+          file://pgpool.sysconfig \
+          file://pgpool.service \
+           "
+SRC_URI[sha256sum] =

"4b379bbba8e178128a1cee4a5bd1ae116dedb3da6121b728c18f0f54c881f328 "

Quoted 5 lines
Quoted 5 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +5 -0
+
+S = "${WORKDIR}/pgpool-II-${PV}"
+
+inherit autotools systemd
+
Quoted 8 lines

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb

Quoted 8 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +8 -0
+SYSTEMD_SERVICE:${PN} = "pgpool.service"
+
+PACKAGECONFIG ??= " openssl libmemcached postgresql \
+    ${@bb.utils.filter('DISTRO_FEATURES', 'pam', d)} \
+    "
+PACKAGECONFIG[pam] = "--with-pam,--without-pam,libpam,"
+PACKAGECONFIG[openssl] = "--with-openssl,--without-openssl,openssl"
+PACKAGECONFIG[libmemcached] =

"--with-memcached=${STAGING_INCDIR}/libmemcachedutil-1.0,--without-memc ached,libmemcached"

Quoted 1 line

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb line 31

Quoted 1 line
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +1 -0
+PACKAGECONFIG[postgresql] =

"--with-pgsql-includedir=${STAGING_INCDIR}/postgresql --with-pgsql=${bindir} ,,postgresql"

Quoted 11 lines

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb

Quoted 11 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +11 -0
+
+EXTRA_OECONF += "-disable-static \
+               "
+B = "${S}"
+CFLAGS:append = " -fcommon "
+
+FILES:${PN} += "${datadir}/pgpool-II/ "
+
+do_install:append() {
+    install -d ${D}${sysconfdir}/pgpool-II
+    install -D -m 0644 ${WORKDIR}/pgpool.sysconfig

${D}${sysconfdir}/pgpool-II/pgpool.conf

Quoted 1 line

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb line 43

Quoted 1 line
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +1 -0
+    install -D -m 0644 ${S}/src/sample/pcp.conf.sample

${D}${sysconfdir}/pgpool-II/pcp.conf

Quoted 1 line

meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb line 44

Quoted 1 line
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +1 -0
+    install -D -m 0644 ${S}/src/sample/pool_hba.conf.sample

${D}${sysconfdir}/pgpool-II/pool_hba.conf

Quoted 18 lines
Quoted 18 lines
meta-oe/recipes-support/pgpool2/pgpool2_4.4.1.bb new file +3 -1
+    install -Dm 0644 ${WORKDIR}/pgpool.service
+${D}${systemd_system_unitdir}/pgpool.service
+}
--

1.8.3.1

-=-=-=-=-=-=-=-=-=-=-=-
Links: You receive all messages sent to this group. View/Reply Online (#100478):
https://lists.openembedded.org/g/openembedded-devel/message/100478
Mute This Topic: https://lists.openembedded.org/mt/96146690/1997914
Group Owner: [email protected] Unsubscribe:
https://lists.openembedded.org/g/openembedded-devel/unsub
[[email protected]]
-=-=-=-=-=-=-=-=-=-=-=-