From patchwork Wed Nov 11 20:39:55 2026 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Babanpreet Singh X-Patchwork-Id: 103784 Received: from mail-pj1-f46.google.com (mail-pj1-f46.google.com [209.85.216.46]) by mx.groups.io with SMTP id smtpd.msgproc01-g2.3639.1794429600940399266 for ; Wed, 11 Nov 2026 12:40:00 -0800 Authentication-Results: mx.groups.io; dkim=pass header.i=@gmail.com header.s=20260707 header.b=dVyvjuOR; spf=pass (domain: gmail.com, ip: 209.85.216.46, mailfrom: bbnpreetsingh@gmail.com) Received: by mail-pj1-f46.google.com with SMTP id 98e67ed59e1d1-3b0a519049aso2384085a91.1 for ; Wed, 11 Nov 2026 12:40:00 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1794429600; x=1795034400; darn=lists.openembedded.org; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to:content-type; bh=yuN2Q7/h1U9XuDY4i0JtMo7/Vpunn5TuatsuUpOUTso=; b=dVyvjuORnI58v7D0+fjktTvknxV+RcfMG4EE4HiQ2YYx4DIJ588fc+lyo+SZpuslLJ cypUvxVYYrIEm/jzaHeDm2UDew0Y8WFsfMIU+kDr8xmUSHQ2JyDsx3jQn8cT67peHSMl Ahnq9s2zWDAYWaQ56PAmuhVU0BNh+8wmiLgZReNwjBsXfDj7RqRyFw1aKBX4db0wM7tT zpm8BRCGXb7oYJjgo8bAGdRttBoGkDM6k82mSWcj4GQjKOGgCN+zJnQT/Wt3hTMQFHZ+ kEg46ajQlWHZ/Z+wSEdYaUCwJ0qA6L852/yYwHNhUGMIHfQHmMm+Duznzc8u3Hqwn2wN ck1w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1794429600; x=1795034400; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to:content-type; bh=yuN2Q7/h1U9XuDY4i0JtMo7/Vpunn5TuatsuUpOUTso=; b=ureyOG9kmRz2ern4GpRh29OoZU3FnwuanwE0rJV0m1BS+Ontxr11t/p65+GDXVcynx eFv7QjHPadnOqbtiP1+EM1CWZqORAJk8HA3iuqVIg3I7j4+MBOmv233wANN2Yws1MWwy Kko3M4ALnBWhZI5zrjEZVH0dZJD2Hf+3gEOfZJaYYVKUuL/p3ffhUyZYVNpC9pAi1U4Z w1NjV/HHID4ZBynaL+11P1K+TUVr6SI8qnprDBG45/1vu6lmy5MtsrpMMDm0tURuYq0C uwPd7idTUbHycV39EI+VRgHBaeSwAoqI/mqInxID+8ofXv0NIymgF/PyRYJQeMYWXBjO CHPg== X-Gm-Message-State: APuU4Z+n3jRPqe6tCaxRRMeEIbbn+TNNjAucSMUP1BildSp9IupZ5FFW G/5OyEEEM+0SeCTwVNFu68zCHeWbYbBhzDPSn17nQRC1nwkUfqXQv99mRkh2lIOZ X-Gm-Gg: AYBFou08krGqfudglvb3C6bUAsdAbWwvp4bVDwEAOX+UnWhpeGtCB278LeFjkLWvo67 GFngkcOjkO54Zx4s8A+FOBKRuU4wDwzUkpI3DrtsLj0SQ4f8RIEEhDLmZWfq4nAfpY0kEjktKBO XLhfFR9omQoxfLJPK9CwVX/Okd1TOIgLzZrQ8/KQfUe6VdfD7YJV6BL/H13Ml0QPkIU6+mHHHkU fUlL9/OCIr/qdymTR6cErK+k5f3lcsrt/fhHDhHXUloe8EQ3MFcxLm9JO0qGCiCbILwf+ES++vg Sn2GrMEJ1eZhGVcEfhj1VOC6LSZrExCfrF6RP6YDDGnMsVQIsbpmuG4pSMqMQyVSYOs9sOgwUA/ SkBXVJ4evreOgR7frHliN8+j8cbtkwip3CWINvcc77druOqY0l9j1ayErdHmlVd2pPPePl5RlbK 3n/iQt5xt/MXZI8QCT24SmUeHxLaYZnhBNOI83YZEgSsnwLI/vbnn8U/C5LkBh+wIUJg14AAdlI +IfZxdlwZzRpPVCzilQuf5QERMlaMWnfXxvRkQl3gjDumy8HOGXMjEh9wOVj/RK0SN2hqQPOLVw x4ra/yrR6um2GNlELnZplSkT8PabQrENzsdT4NRJKgxONZbHaXK/ZSxoG7V3SxE= X-Received: by 2002:a17:90b:2684:b0:3ac:aa8d:19de with SMTP id 98e67ed59e1d1-3b182df326emr3589595a91.3.1794429600138; Wed, 11 Nov 2026 12:40:00 -0800 (PST) Return-Path: Received: from localhost.localdomain ([108.180.159.198]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-cdd8d699b93sm1841011a12.14.2026.11.11.12.39.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Nov 2026 12:39:59 -0800 (PST) From: Babanpreet Singh To: openembedded-devel@lists.openembedded.org Cc: Khem Raj , Ross Burton , Babanpreet Singh Subject: [meta-oe][PATCH 1/3] postgresql: make PGXS usable for cross-building extensions Date: Wed, 11 Nov 2026 20:39:55 +0000 Message-ID: <20261111203957.7-2-bbnpreetsingh@gmail.com> X-Mailer: git-send-email 2.43.0 In-Reply-To: <20261111203957.7-1-bbnpreetsingh@gmail.com> References: <20261111203957.7-1-bbnpreetsingh@gmail.com> MIME-Version: 1.0 List-Id: X-Webhook-Received: from 45-33-107-173.ip.linodeusercontent.com [45.33.107.173] by lin-tor-korg-lkml-alma10-1 with HTTPS for ; Wed, 11 Nov 2026 20:40:07 -0000 X-Groupsio-URL: https://lists.openembedded.org/g/openembedded-devel/message/132138 Extensions built with PGXS need pg_config and Makefile.global, but pg_config is a target binary and the staged Makefile.global has its paths stripped. Stage a shell pg_config in crossscripts and fix up the staged PGXS makefiles so extensions can be built against the sysroot. Signed-off-by: Babanpreet Singh --- .../recipes-dbs/postgresql/files/pg_config | 43 +++++++++++++ meta-oe/recipes-dbs/postgresql/postgresql.inc | 62 +++++++++++++++++-- 2 files changed, 99 insertions(+), 6 deletions(-) create mode 100755 meta-oe/recipes-dbs/postgresql/files/pg_config diff --git a/meta-oe/recipes-dbs/postgresql/files/pg_config b/meta-oe/recipes-dbs/postgresql/files/pg_config new file mode 100755 index 0000000000..1fab031a90 --- /dev/null +++ b/meta-oe/recipes-dbs/postgresql/files/pg_config @@ -0,0 +1,43 @@ +#!/bin/sh +# pg_config for cross builds, the real one is a target binary. +# Build paths are answered inside the sysroot, install paths as on the target. + +sysroot=$(cd "$(dirname "$0")" && pwd -P) +sysroot=${sysroot%@CROSSSCRIPTS@} + +value() { + case $1 in + --bindir) echo "@BINDIR@" ;; + --docdir) echo "@DOCDIR@" ;; + --htmldir) echo "@DOCDIR@" ;; + --includedir) echo "$sysroot@INCLUDEDIR@" ;; + --pkgincludedir) echo "$sysroot@PKGINCLUDEDIR@" ;; + --includedir-server) echo "$sysroot@PKGINCLUDEDIR@/server" ;; + --libdir) echo "$sysroot@LIBDIR@" ;; + --pkglibdir) echo "@PKGLIBDIR@" ;; + --localedir) echo "@LOCALEDIR@" ;; + --mandir) echo "@MANDIR@" ;; + --sharedir) echo "@SHAREDIR@" ;; + --sysconfdir) echo "@SYSCONFDIR@" ;; + --pgxs) echo "$sysroot@PKGLIBDIR@/pgxs/src/makefiles/pgxs.mk" ;; + --version) echo "PostgreSQL @VERSION@" ;; + *) + echo "pg_config: $1 is not available in a cross build" >&2 + exit 1 + ;; + esac +} + +all="bindir docdir htmldir includedir pkgincludedir includedir-server \ + libdir pkglibdir localedir mandir sharedir sysconfdir pgxs version" + +if [ $# -eq 0 ]; then + for opt in $all; do + printf '%s = %s\n' "$(echo "$opt" | tr a-z A-Z)" "$(value "--$opt")" + done + exit 0 +fi + +for arg; do + value "$arg" +done diff --git a/meta-oe/recipes-dbs/postgresql/postgresql.inc b/meta-oe/recipes-dbs/postgresql/postgresql.inc index 76e90df765..5ac0513085 100644 --- a/meta-oe/recipes-dbs/postgresql/postgresql.inc +++ b/meta-oe/recipes-dbs/postgresql/postgresql.inc @@ -30,6 +30,7 @@ SRC_URI = "https://ftp.postgresql.org/pub/source/v${PV}/${BP}.tar.bz2 \ file://postgresql-setup \ file://postgresql.service \ file://run-ptest \ + file://pg_config \ " LEAD_SONAME = "libpq.so" @@ -284,16 +285,65 @@ do_install:append() { install -m 0644 ${UNPACKDIR}/postgresql.service ${D}${systemd_unitdir}/system sed -i -e 's,@BINDIR@,${bindir},g' \ ${D}${systemd_unitdir}/system/postgresql.service - # Remove the build path + # Make the installed PGXS makefiles usable from extension recipes: take + # the toolchain from the environment and drop the build paths. PostgreSQL + # 18 skips pg_config when prefix is set, the first expression undoes that. if [ -f ${D}${libdir}/${BPN}/pgxs/src/Makefile.global ]; then - sed -i -e 's#${RECIPE_SYSROOT}##g' \ - -e 's#${RECIPE_SYSROOT_NATIVE}##g' \ - -e 's#${WORKDIR}##g' \ - -e 's#${TMPDIR}##g' \ - ${D}${libdir}/${BPN}/pgxs/src/Makefile.global + sed -i \ + -e 's#^ifneq (,$(if $(PGXS),,1)$(prefix))$#ifndef PGXS#' \ + -e 's#^CC = .*#CC := $(CC)#' \ + -e 's#^CXX = .*#CXX := $(CXX)#' \ + -e 's#^CPP = .*#CPP := $(CPP)#' \ + -e 's#^LD = .*#LD := $(LD)#' \ + -e 's# -fcanon-prefix-map##g' \ + -e 's# -f\(file\|debug\|macro\)-prefix-map=[^ ]*##g' \ + -e 's#^CFLAGS = \(.*\)#CFLAGS := \1 $(CFLAGS)#' \ + -e 's#^CXXFLAGS = \(.*\)#CXXFLAGS := \1 $(CXXFLAGS)#' \ + -e 's#^LDFLAGS = \(.*\)#LDFLAGS := \1 $(LDFLAGS)#' \ + -e '/^CFLAGS :=/s# -I${STAGING_INCDIR}/${PYTHON_DIR}##' \ + -e 's#${RECIPE_SYSROOT}${includedir}#$(includedir)#g' \ + -e 's#${RECIPE_SYSROOT}${libdir}#$(libdir)#g' \ + -e 's#${STAGING_BINDIR_NATIVE}/perl-native/perl#perl#g' \ + -e 's#${STAGING_BINDIR_NATIVE}/python3-native/python3#python3#g' \ + -e 's#${STAGING_BINDIR_NATIVE}/##g' \ + -e 's#${TMPDIR}/hosttools/##g' \ + -e 's#${RECIPE_SYSROOT_NATIVE}##g' \ + -e 's#${RECIPE_SYSROOT}##g' \ + -e 's#${WORKDIR}##g' \ + -e 's#${TMPDIR}##g' \ + ${D}${libdir}/${BPN}/pgxs/src/Makefile.global + # PGXS installs headers and libraries into directories pg_config + # reports inside the sysroot, strip the sysroot there + sed -i -e '/^pgxsdir = /a pg_sysroot := $(patsubst %$(pgxsdir)/src/makefiles/pgxs.mk,%,$(PGXS))' \ + ${D}${libdir}/${BPN}/pgxs/src/Makefile.global + sed -i -e 's#$(DESTDIR)$(includedir_server)#$(DESTDIR)$(includedir_server:$(pg_sysroot)%=%)#g' \ + ${D}${libdir}/${BPN}/pgxs/src/makefiles/pgxs.mk + sed -i -e 's#$(DESTDIR)$(libdir)#$(DESTDIR)$(libdir:$(pg_sysroot)%=%)#g' \ + ${D}${libdir}/${BPN}/pgxs/src/Makefile.shlib fi } +# pg_config is a target binary, stage a script for extension builds +SYSROOT_PREPROCESS_FUNCS += "postgresql_sysroot_preprocess" +postgresql_sysroot_preprocess() { + install -d ${SYSROOT_DESTDIR}${bindir_crossscripts} + sed -e 's,@CROSSSCRIPTS@,${bindir_crossscripts},g' \ + -e 's,@BINDIR@,${bindir},g' \ + -e 's,@DOCDIR@,${docdir}/${BPN},g' \ + -e 's,@INCLUDEDIR@,${includedir},g' \ + -e 's,@PKGINCLUDEDIR@,${includedir}/${BPN},g' \ + -e 's,@LIBDIR@,${libdir},g' \ + -e 's,@PKGLIBDIR@,${libdir}/${BPN},g' \ + -e 's,@LOCALEDIR@,${datadir}/locale,g' \ + -e 's,@MANDIR@,${mandir},g' \ + -e 's,@SHAREDIR@,${datadir}/${BPN},g' \ + -e 's,@SYSCONFDIR@,${sysconfdir}/${BPN},g' \ + -e 's,@VERSION@,${PV},g' \ + ${UNPACKDIR}/pg_config \ + > ${SYSROOT_DESTDIR}${bindir_crossscripts}/pg_config + chmod 0755 ${SYSROOT_DESTDIR}${bindir_crossscripts}/pg_config +} + SSTATE_SCAN_FILES += "Makefile.global" SSTATE_SCAN_FILES:remove = "*_config" From patchwork Wed Nov 11 20:39:56 2026 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Babanpreet Singh X-Patchwork-Id: 103785 Received: from mail-pg1-f170.google.com (mail-pg1-f170.google.com [209.85.215.170]) by mx.groups.io with SMTP id smtpd.msgproc01-g2.3640.1794429601506107041 for ; Wed, 11 Nov 2026 12:40:01 -0800 Authentication-Results: mx.groups.io; dkim=pass header.i=@gmail.com header.s=20260707 header.b=pNW9S6Dp; spf=pass (domain: gmail.com, ip: 209.85.215.170, mailfrom: bbnpreetsingh@gmail.com) Received: by mail-pg1-f170.google.com with SMTP id 41be03b00d2f7-cdab8873d9dso1540550a12.1 for ; Wed, 11 Nov 2026 12:40:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1794429601; x=1795034401; darn=lists.openembedded.org; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to:content-type; bh=kwwvbVpbBKpTwniQr0F26nnvIbZB981KNeSIwtQvbmg=; b=pNW9S6DpyZUA22i7RuRhS4qTPbTlKBaHET6dAuKrek10tMlCvF1NVNTpXb+IO3GzzH VFOCkVVb1JAZZPWwsd34AXVGiDr9WoVT59id1q+Nknq5IysaP37PQuhkr/Xo/zZs6a9f l2OJU3CnSZ6S02zHBGjvKNJmDFZiD7AwlYzhLmUiucLxZK7lD4sJwtJiF3UcnxKbVLlG BboZey3UFtEl9qVkYP+GmqyfzX3QrPHnwHmFon6Bji90Ep99C8L76fCBtX6GgPqAUuPo QgKM7Dv+ACJPZCkSfk9PmHn0mDgvPEwKqHZ+FZtJ9ZCgxrpksCWsAOKKqLsj1fygdX9a DGTQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1794429601; x=1795034401; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to:content-type; bh=kwwvbVpbBKpTwniQr0F26nnvIbZB981KNeSIwtQvbmg=; b=NAgNKqYFW8vK9LYLUrS2+cQ8VuTKWFwVmiDCOKFeVIjBRDOXj2Mqsdy+rLDESfI2jE vFwkkCf1vlNHS7BDkSYMj33sXpth8C8CjRs7wa2MKWHU3muPSmSYnhkBzdtaE731UzQV XG6VAHJz9wKk2rHpFu06Zz4tTj8wHnk4Fl5fMzSdJIG2DGnBc26pNmo8P73NUdkOGdrc yaKt+gxYw6DlBbNLE0ly4ZPMbbiozV4E9OuB/G+YHWJ5fkEq1liM9HUmu1jsbZRVIi+5 kSvv8KTqAkD8ZcIF3Zw2riEB8NKt4um9rRUvx4Eggf/vQ/mFDsiqldlyoymycyI6Whe8 K6KQ== X-Gm-Message-State: APuU4Z+Vls0kJHpowAeBoBSwm84zyt9RfkM9/9efGyUhpfSO45Sp6Hpx wYnZn7FuxMCRPeN0JU/4YqVoLx7fdzge1C84lE8q1KjdcLCFOlDtZY8K+sNkJXam X-Gm-Gg: AYBFou152rcZ499tYMRdvGSdhLoac4mSMGTG1Ki923GrdxAvNhyimsVKx2dKND7eMSv ve19K3XlNwBcjveOfjWqIEHC2ozF4QO/li9ePrc64gXHBtEPHbH39UdjjxVjvY1Ss79F9I7CiU/ YbgJofbbTQsdqw3sHBIylOY+Ttz3KSxb6A35EEXRCDkSfyO8kFWQRm5Nkajqc8175vgXw/EFCvr 2i/bFjE1263CPSWueF7Opy9Q/2g8u0bXb6oa0SfceBsiQ7KQhWu+fQqmc6xwR2xpwF4LKgbXMbR VS19Gk9HIin0TuXs8c4juvro1WjWOXuMn/5gf06hmZuL+AiGCoXiQavGWvbZgcaWxBlkJoD+3MG Wb/rVG2hFX8F0KvaU9XJkULC6AehVNTMeTY3DCG9WubTcyjnY+E+O7wmIecTmpLCFN0LUUG+QlN EvbDyue0ASDS93pkBdTV5hYgLP1yYgp1yZBd0f/zTXAS9n6jtZVzQrQMfFDtK1v+5A6YDVJtsoU 0r54Nq67RzclUpCmnTeP1Js6zthxlwzRvILGs2dF+uWiW8kSVaofiVIfZhefWL/4AjYuMuGQ01s qyGQQ3N9Z1iLn0RcZFrgJcR8lVFHhKzBTMEJBdpbfkXIVUBcpnLjAz4Hry6LQiE= X-Received: by 2002:a17:90b:4a12:b0:3b0:9fbf:8951 with SMTP id 98e67ed59e1d1-3b182e0346bmr3570997a91.5.1794429600833; Wed, 11 Nov 2026 12:40:00 -0800 (PST) Return-Path: Received: from localhost.localdomain ([108.180.159.198]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-cdd8d699b93sm1841011a12.14.2026.11.11.12.40.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Nov 2026 12:40:00 -0800 (PST) From: Babanpreet Singh To: openembedded-devel@lists.openembedded.org Cc: Khem Raj , Ross Burton , Babanpreet Singh Subject: [meta-oe][PATCH 2/3] pgxs.bbclass: add class for PostgreSQL extensions Date: Wed, 11 Nov 2026 20:39:56 +0000 Message-ID: <20261111203957.7-3-bbnpreetsingh@gmail.com> X-Mailer: git-send-email 2.43.0 In-Reply-To: <20261111203957.7-1-bbnpreetsingh@gmail.com> References: <20261111203957.7-1-bbnpreetsingh@gmail.com> MIME-Version: 1.0 List-Id: X-Webhook-Received: from 45-33-107-173.ip.linodeusercontent.com [45.33.107.173] by lin-tor-korg-lkml-alma10-1 with HTTPS for ; Wed, 11 Nov 2026 20:40:07 -0000 X-Groupsio-URL: https://lists.openembedded.org/g/openembedded-devel/message/132139 Extensions that build with PGXS need the same dependency, make arguments and FILES. Put them in a class so a recipe only has to inherit pgxs. Signed-off-by: Babanpreet Singh --- meta-oe/classes/pgxs.bbclass | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) create mode 100644 meta-oe/classes/pgxs.bbclass diff --git a/meta-oe/classes/pgxs.bbclass b/meta-oe/classes/pgxs.bbclass new file mode 100644 index 0000000000..b1c7aca264 --- /dev/null +++ b/meta-oe/classes/pgxs.bbclass @@ -0,0 +1,22 @@ +# +# Copyright OpenEmbedded Contributors +# +# SPDX-License-Identifier: MIT +# + +# Class for PostgreSQL extensions that are built with PGXS + +DEPENDS += "postgresql" + +# USE_PGXS is for makefiles that can also build inside the PostgreSQL tree +EXTRA_OEMAKE:append = " USE_PGXS=1 PG_CONFIG=pg_config" + +pgxs_do_install() { + oe_runmake install DESTDIR=${D} +} + +EXPORT_FUNCTIONS do_install + +FILES:${PN} += "${libdir}/postgresql ${datadir}/postgresql" + +RDEPENDS:${PN} += "postgresql" From patchwork Wed Nov 11 20:39:57 2026 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Babanpreet Singh X-Patchwork-Id: 103783 Received: from mail-pg1-f181.google.com (mail-pg1-f181.google.com [209.85.215.181]) by mx.groups.io with SMTP id smtpd.msgproc01-g2.3641.1794429602715098959 for ; Wed, 11 Nov 2026 12:40:02 -0800 Authentication-Results: mx.groups.io; dkim=pass header.i=@gmail.com header.s=20260707 header.b=ji1SX59u; spf=pass (domain: gmail.com, ip: 209.85.215.181, mailfrom: bbnpreetsingh@gmail.com) Received: by mail-pg1-f181.google.com with SMTP id 41be03b00d2f7-cdb681de50eso1235686a12.2 for ; Wed, 11 Nov 2026 12:40:02 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20260707; t=1794429602; x=1795034402; darn=lists.openembedded.org; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:from:to:cc:subject:date :message-id:reply-to:content-type; bh=q/MIgTbFhy0402EcKQpuIjjhhYvZNZWqYEu0Brl5Xzw=; b=ji1SX59u6ovl2qa4/i/l7xJohLtorjql1JXr697OGujFKFoa9cN+U4rAZ6KhA4MHx6 K78+TVgg3SLVKLxH1hM65Kn+7/3GQsuCGEYhPpZDZI5OkXsZHvSN9EcJF/lv4m0G8sKt 8ghKh2TOP4MURrbiQaoPDFpD5EWjplSKhonEMEwN0iZrw+/BH8fRD4TFAfCM916WaZja ZiSXT0aC9uJinwbHBOAf8RsYUO96XaE5mVThxOifed0X04wUpum14tJplBlETdp0wZxr ioXDNDbRdTBuaonE/TYj5CZMnnYO1EZdCslllp+5cFT71m7iY2dJSlmXP4iDDW19crmK 3RwQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20260707; t=1794429602; x=1795034402; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:date:subject:cc:to:from:x-gm-gg:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to:content-type; bh=q/MIgTbFhy0402EcKQpuIjjhhYvZNZWqYEu0Brl5Xzw=; b=lKFYWZ4lmz9vXRsVx6gQXEAFlWdvg+aWOZrLO25dT81Aacy/QLcre19GELEZlZjnTq 9r5WMso6GN3IlQfG32OE1NL7P7OFygujGkbCwX2wr7VgBnUoTKRuM9LWcLxL9vicl1Xs kpP2EFUJySXw5t8vJVtJdd0YgVuT23N1ocQmX2ooUJk2OK8ODRFrkFC4vEfadfoQlfrS Zi1tZLwcv38cU6Rl35a6yuU7Q27WYLj7lquY4dW7H398Yjp2NEjoCIQHJC64fQ6EDVDl QxpJworUBwU2BoHs679kJ1H2vKnYnaanCtaG6hm1HIpT0Eh9TBxXy9FdQMnzM41AvjcD vQjw== X-Gm-Message-State: APuU4Z+6OZCy4tue5YhlO9MsA0WAuuKb4cbsw2yQrESB+Iu06p3hHYbk DmPDm2ohqJ8sxsBbLS/SFnpMhz7mrp6Ha4Lht9wygEGGxOISldAUC8b02LxbXMN1KDU= X-Gm-Gg: AYBFou0ZJBP6aokplmKnVv+ka+bi+gRoYbu1eejN1MvDwm2usFsgNnYd6pNyDAp3Om/ NGR/WyEFfBBMeH2+uhBw6scvYjKoHrvo++avWOAu5Z71ba0cJAv92xru/C74Br44ZYtE4BwWWzK lV9ZjRlzoqXFpooaNhtIMwdpgbmaac1s55kHv+9doMz+rIgZTgbtitnLI5UKlJUJPApq/JM7NQX iEM3G0zeeSO2FUS9ebibOoYZhpE16amRPKfe5AbB9sPjdbjnvFaZMDrMYLWk4DXR8JWPPNowVsj LjpyQVJADOfUBlSq9tNUczPR++dZYJWINn/+P0BWEYJUvq7lFxAmiOIvQP+dX+SMtjx1khDViIw NujjSQu3G9R+zMz5juj/N42vXA+b3cQPiDv7u7cnUzcLgEpp3ODIwoTd5l15cFi9v9Nynk4L5cV 3mKMCLd8j3Pa/IE8KiLZf5QT3zd+nSQ6QiLEEuU8BngYPF4MYAkMeRwdQuvjPbfRZVzhVRUyMbF J0/wk5HE4oQgsbK0YdEuF1P8y0BgSjiAsaoqwcAWH5L22LWmdN0Dvv00oT4od3S8S2hNFrkEihr fH5sQCVcYbwI2y2Emz4IXVetyqOFVKM45DGZIVLwDRY/vjSiluc+DIy5tmQ0g1U= X-Received: by 2002:a17:90b:4f45:b0:3a4:945e:bc33 with SMTP id 98e67ed59e1d1-3b182ff36acmr3401172a91.47.1794429602020; Wed, 11 Nov 2026 12:40:02 -0800 (PST) Return-Path: Received: from localhost.localdomain ([108.180.159.198]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-cdd8d699b93sm1841011a12.14.2026.11.11.12.40.00 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 11 Nov 2026 12:40:01 -0800 (PST) From: Babanpreet Singh To: openembedded-devel@lists.openembedded.org Cc: Khem Raj , Ross Burton , Babanpreet Singh Subject: [meta-oe][PATCH 3/3] pg-cron: add recipe Date: Wed, 11 Nov 2026 20:39:57 +0000 Message-ID: <20261111203957.7-4-bbnpreetsingh@gmail.com> X-Mailer: git-send-email 2.43.0 In-Reply-To: <20261111203957.7-1-bbnpreetsingh@gmail.com> References: <20261111203957.7-1-bbnpreetsingh@gmail.com> MIME-Version: 1.0 List-Id: X-Webhook-Received: from 45-33-107-173.ip.linodeusercontent.com [45.33.107.173] by lin-tor-korg-lkml-alma10-1 with HTTPS for ; Wed, 11 Nov 2026 20:40:07 -0000 X-Groupsio-URL: https://lists.openembedded.org/g/openembedded-devel/message/132140 pg_cron is a cron-based job scheduler that runs inside PostgreSQL. Signed-off-by: Babanpreet Singh --- .../packagegroups/packagegroup-meta-oe.bb | 1 + meta-oe/recipes-dbs/pg-cron/pg-cron_1.6.8.bb | 13 +++++++++++++ 2 files changed, 14 insertions(+) create mode 100644 meta-oe/recipes-dbs/pg-cron/pg-cron_1.6.8.bb diff --git a/meta-oe/recipes-core/packagegroups/packagegroup-meta-oe.bb b/meta-oe/recipes-core/packagegroups/packagegroup-meta-oe.bb index ebd66425de..7fba0722b9 100644 --- a/meta-oe/recipes-core/packagegroups/packagegroup-meta-oe.bb +++ b/meta-oe/recipes-core/packagegroups/packagegroup-meta-oe.bb @@ -214,6 +214,7 @@ RDEPENDS:packagegroup-meta-oe-dbs = "\ libdbi \ lmdb \ mariadb \ + pg-cron \ postgresql \ psqlodbc \ rocksdb \ diff --git a/meta-oe/recipes-dbs/pg-cron/pg-cron_1.6.8.bb b/meta-oe/recipes-dbs/pg-cron/pg-cron_1.6.8.bb new file mode 100644 index 0000000000..9f9a59b398 --- /dev/null +++ b/meta-oe/recipes-dbs/pg-cron/pg-cron_1.6.8.bb @@ -0,0 +1,13 @@ +SUMMARY = "Run periodic jobs in PostgreSQL" +DESCRIPTION = "pg_cron is a cron-based job scheduler that runs inside \ +PostgreSQL as an extension. Jobs are scheduled from SQL with the usual \ +cron syntax and run by a background worker in the server." +HOMEPAGE = "https://github.com/citusdata/pg_cron" +BUGTRACKER = "https://github.com/citusdata/pg_cron/issues" +LICENSE = "PostgreSQL" +LIC_FILES_CHKSUM = "file://LICENSE;md5=b70f68d78dbcc36c5654d795cee59b0d" + +SRC_URI = "git://github.com/citusdata/pg_cron.git;protocol=https;branch=main;tag=v${PV}" +SRCREV = "2323864075a50f234235f98e567eb958f923b2b3" + +inherit pgxs