5 kx
5 kx COMPONENT_TARGETS = $(HARDWARE_INTEL_PC64)
5 kx
5 kx NEED_ABS_PATH = true
5 kx COMPONENT_IS_3PP = true
5 kx
5 kx CREATE_X86_32_PACKAGE = true
5 kx
5 kx
5 kx include ../../../build-system/constants.mk
5 kx
5 kx
5 kx SOURCE_REQUIRES = sources/packages/b/postgresql
5 kx
5 kx REQUIRES = app/postgresql/14.1
5 kx REQUIRES += dev/perl/5.36.0-x86_32
5 kx REQUIRES += dev/python3/3.10.8-x86_32
5 kx REQUIRES += app/util-linux/2.38.1-x86_32
385 kx REQUIRES += libs/libxml2/2.11.4-x86_32
5 kx REQUIRES += libs/libxslt/1.1.34-x86_32
5 kx REQUIRES += libs/readline/8.2-x86_32
29 kx REQUIRES += libs/icu4c/73.1-x86_32
5 kx REQUIRES += libs/lz4/1.9.4-x86_32
5 kx REQUIRES += net/openssl/1.1.1r-x86_32
5 kx REQUIRES += net/krb5/1.19.1-x86_32
5 kx REQUIRES += secure/pam/1.5.1-x86_32
5 kx
5 kx # ======= __END_OF_REQUIRES__ =======
5 kx
5 kx
5 kx version = 14.1
5 kx pg_version = $(shell echo $(version) | cut -f1,2 -d '.')
5 kx tar_bz2_archive = $(SRC_PACKAGE_PATH)/packages/b/postgresql/postgresql-$(version).tar.bz2
5 kx SRC_ARCHIVE = $(tar_bz2_archive)
5 kx SRC_DIR = $(TARGET_BUILD_DIR)/postgresql-$(version)
5 kx src_dir_name = postgresql-$(version)
5 kx src_done = $(TARGET_BUILD_DIR)/.source_done
5 kx
5 kx PATCHES = PATCHES
5 kx
5 kx build_tools_dir = $(TARGET_BUILD_DIR)/build-tools
5 kx
5 kx build_dir = $(TARGET_BUILD_DIR)/build
5 kx build_target = $(TARGET_BUILD_DIR)/.build_done
5 kx install_target = $(TARGET_BUILD_DIR)/.install_done
5 kx
5 kx abs_build_dir = $(CURDIR)/$(build_dir)
5 kx
5 kx
5 kx ####### Targets
5 kx
5 kx PKG_GROUP = app
5 kx
5 kx #
5 kx # *PKG_NAME & *PKG_VERSION shouldn't be a reference to value.
5 kx #
5 kx PGSQL_32_PKG_NAME = postgresql-x32
5 kx PGSQL_32_PKG_VERSION = 14.1
5 kx PGSQL_32_PKG_ARCH = $(PKGARCH)
5 kx PGSQL_32_PKG_DISTRO_NAME = $(DISTRO_NAME)
5 kx PGSQL_32_PKG_DISTRO_VERSION = $(DISTRO_VERSION)
5 kx PGSQL_32_PKG_GROUP = $(PKG_GROUP)
5 kx ### |---handy-ruler-------------------------------|
5 kx PGSQL_32_PKG_SHORT_DESCRIPTION = database management system
5 kx PGSQL_32_PKG_URL = $(BUG_URL)
5 kx PGSQL_32_PKG_LICENSE = custom
5 kx PGSQL_32_PKG_DESCRIPTION_FILE = $(TARGET_BUILD_DIR)/$(PGSQL_32_PKG_NAME)-pkg-description
5 kx PGSQL_32_PKG_DESCRIPTION_FILE_IN = $(PGSQL_32_PKG_NAME)-pkg-description.in
5 kx PGSQL_32_PKG_INSTALL_SCRIPT = $(PGSQL_32_PKG_NAME)-pkg-install.sh
5 kx
5 kx PGSQL_32_PKG = $(CURDIR)/$(TARGET_BUILD_DIR)/$(PGSQL_32_PKG_NAME)-package
5 kx
5 kx pkg_basename = $(PGSQL_32_PKG_NAME)-$(PGSQL_32_PKG_VERSION)-$(PGSQL_32_PKG_ARCH)-$(PGSQL_32_PKG_DISTRO_NAME)-$(PGSQL_32_PKG_DISTRO_VERSION)
5 kx
5 kx pkg_archive = $(TARGET_BUILD_DIR)/$(PKG_GROUP)/$(pkg_basename).$(pkg_arch_suffix)
5 kx pkg_certificate = $(call cert-name,$(pkg_archive))
5 kx pkg_signature = $(call sign-name,$(pkg_archive))
5 kx pkg_description = $(call desc-name,$(pkg_archive))
5 kx products = $(call pkg-files,$(pkg_archive))
5 kx
5 kx BUILD_TARGETS = $(build_target)
5 kx BUILD_TARGETS += $(install_target)
5 kx
5 kx PRODUCT_TARGETS = $(products)
5 kx
5 kx ROOTFS_TARGETS = $(pkg_archive)
5 kx
5 kx
5 kx include ../../../build-system/core.mk
5 kx
5 kx
5 kx env_sysroot = DESTDIR=$(PGSQL_32_PKG)
5 kx
5 kx
5 kx #
5 kx # Perl Configuration:
5 kx #
5 kx extra_environment = PERL=$(PERL)
5 kx extra_environment += pgac_perl_version=5.34.0
5 kx extra_environment += perl_archlibexp='$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_X86_32_SUFFIX)/perl5'
5 kx extra_environment += perl_privlibexp='$(TARGET_DEST_DIR)/usr/share/perl5'
5 kx extra_environment += perl_includespec='-I$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_X86_32_SUFFIX)/perl5/CORE'
5 kx extra_environment += perl_useshrplib='true'
5 kx extra_environment += perl_embed_ldflags='-L$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_X86_32_SUFFIX)/perl5/CORE -Wl,-E -Wl,-rpath,/usr/lib$(MULTILIB_X86_32_SUFFIX)/perl5/CORE -lperl'
5 kx
5 kx
5 kx #
5 kx # Python Configuration:
5 kx #
5 kx PYTHON_VERSION = 3.10
5 kx
5 kx python-configdir = $(shell echo "$(shell dirname $(shell ls $(TARGET_DEST_DIR)/usr/lib$(MULTILIB_X86_32_SUFFIX)/python$(1)/config-$(1)-*/config.c))")
5 kx
5 kx extra_environment += python_version=$(PYTHON_VERSION)
5 kx extra_environment += python_majorversion=$(PYTHON_MAJOR_VERSION)
5 kx extra_environment += python_configdir='$(call python-configdir,$(PYTHON_VERSION))'
5 kx extra_environment += python_includespec='-I$(TARGET_DEST_DIR)/usr/include/python$(PYTHON_VERSION)'
5 kx extra_environment += python_libdir='$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_X86_32_SUFFIX)'
5 kx extra_environment += python_enable_shared=1
5 kx extra_environment += python_libspec='-L$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_X86_32_SUFFIX) -lpython$(PYTHON_VERSION)'
5 kx extra_environment += python_additional_libs='-lpthread -ldl -lutil -lm'
5 kx
5 kx #
5 kx # Tools configure switches (for devenv pg_config):
5 kx #
5 kx tools_configure_switches = --docdir=/usr/share/doc/$(src_dir_name)
5 kx tools_configure_switches += --mandir=/usr/share/man
5 kx
5 kx tools_configure_switches += --includedir=/usr/include
5 kx tools_configure_switches += --sysconfdir=/etc/postgresql/$(pg_version)
5 kx tools_configure_switches += --datarootdir=/usr/share
5 kx tools_configure_switches += --datadir=/usr/share/postgresql-$(pg_version)
5 kx
5 kx #
5 kx # configure switches:
5 kx #
5 kx extra_configure_switches = --docdir=/usr/share/doc/$(src_dir_name)
5 kx extra_configure_switches += --mandir=/usr/share/man
5 kx
5 kx extra_configure_switches += --includedir=/usr/include
5 kx extra_configure_switches += --sysconfdir=/etc/postgresql/$(pg_version)
5 kx extra_configure_switches += --datarootdir=/usr/share
5 kx extra_configure_switches += --datadir=/usr/share/postgresql-$(pg_version)
5 kx
5 kx extra_configure_switches += --with-openssl
5 kx extra_configure_switches += --with-tcl=no
5 kx extra_configure_switches += --with-perl
5 kx extra_configure_switches += --with-python
5 kx extra_configure_switches += --with-libxml
5 kx extra_configure_switches += --with-libxslt
5 kx
5 kx extra_configure_switches += --with-gssapi
5 kx extra_configure_switches += --with-icu
5 kx extra_configure_switches += --with-uuid=e2fs
5 kx extra_configure_switches += --with-ldap
5 kx extra_configure_switches += --with-lz4
5 kx
5 kx extra_configure_switches += --enable-thread-safety
5 kx extra_configure_switches += --with-system-tzdata=/usr/share/zoneinfo
5 kx extra_configure_switches += --enable-nls
5 kx extra_configure_switches += --with-pam
5 kx
5 kx
5 kx TARGET_PERL_RPATH = /usr/lib$(MULTILIB_X86_32_SUFFIX):/usr/lib$(MULTILIB_X86_32_SUFFIX)/perl5/CORE:/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version)/lib
5 kx TARGET_PYTHON_RPATH = /usr/lib$(MULTILIB_X86_32_SUFFIX):/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version)/lib
5 kx TARGET_LIB_RPATH = $(TARGET_PYTHON_RPATH)
5 kx
5 kx CFLAGS += -Wno-unused-function
5 kx LDFLAGS += -Wl,-rpath,$(TARGET_LIB_RPATH)
5 kx
5 kx
5 kx ####### Dependencies
5 kx
5 kx $(src_done): $(SRC_ARCHIVE) $(PATCHES_DEP)
5 kx $(UNPACK_SRC_ARCHIVE)
5 kx $(APPLY_PATCHES)
5 kx # ======= remove parser files to build its again =======
5 kx @( rm -f $(SRC_DIR)/src/backend/parser/gram.{c,h} )
5 kx @touch $@
5 kx
5 kx $(build_target): $(src_done)
5 kx @mkdir -p $(PGSQL_32_PKG)/usr/bin
5 kx @mkdir -p $(build_tools_dir)
5 kx # ======= build pg_config for development environment =======
5 kx @( cd $(build_tools_dir) ; \
5 kx ../$(src_dir_name)/configure \
5 kx --prefix=/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version) \
5 kx $(tools_configure_switches) ; \
5 kx ( cd src/backend && $(MAKE) generated-headers ) ; \
5 kx $(MAKE) -C src/bin/pg_config ; \
5 kx cp -a src/bin/pg_config/pg_config $(PGSQL_32_PKG)/usr/bin/$(TARGET32)-pg_config ; \
5 kx )
5 kx # ======= build PostgreSQL for target machine =======
5 kx @mkdir -p $(build_dir)
5 kx @cd $(build_dir) && \
5 kx $(BUILD_ENVIRONMENT) $(extra_environment) ../$(src_dir_name)/configure \
5 kx --prefix=/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version) \
5 kx --build=$(BUILD) \
5 kx --host=$(TARGET32) \
5 kx $(extra_configure_switches)
5 kx # ======= make links in src/include directory to generated header files =======
5 kx @cd $(build_dir)/src/backend && $(MAKE) generated-headers
5 kx # ======= build postgresql-$(version) =======
5 kx @cd $(build_dir) && $(BUILD_ENVIRONMENT) $(MAKE) XSUBPPDIR=$(TARGET_DEST_DIR)/usr/share/perl5
5 kx @touch $@
5 kx
5 kx $(install_target): $(build_target)
5 kx @mkdir -p $(PGSQL_32_PKG)
5 kx @cd $(build_dir) && $(BUILD_ENVIRONMENT) $(MAKE) -j1 install $(env_sysroot)
5 kx @rm -rf $(PGSQL_32_PKG)/usr/include
5 kx @rm -rf $(PGSQL_32_PKG)/usr/share
5 kx # ======= create symlinks to binary executables =======
5 kx @mkdir -p $(PGSQL_32_PKG)/usr/bin/32
5 kx @( cd $(PGSQL_32_PKG)/usr/bin/32 ; \
5 kx for i in `ls ../../lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version)/bin/*` ; do \
5 kx ln -sf $$i ; \
5 kx done ; \
5 kx )
5 kx # ======= create symlinks to shared library for other programs =======
5 kx @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_X86_32_SUFFIX) ; \
5 kx for i in `ls postgresql/$(pg_version)/lib/lib*.so*` ; do \
5 kx ln -sf $$i ; \
5 kx done ; \
5 kx )
5 kx # ======= create symlinks to pkg-config files for other programs =======
5 kx @mkdir $(PGSQL_32_PKG)/usr/lib$(MULTILIB_X86_32_SUFFIX)/pkgconfig
5 kx @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_X86_32_SUFFIX)/pkgconfig ; \
5 kx for i in `ls ../postgresql/$(pg_version)/lib/pkgconfig/*.pc` ; do \
5 kx ln -sf $$i ; \
5 kx done ; \
5 kx )
5 kx # ======= remove toolchain path from target pkg-config *.pc files =======
5 kx @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version)/lib/pkgconfig ; \
5 kx sed -i "s,$(TARGET_DEST_DIR),,g" libecpg.pc libecpg_compat.pc \
5 kx libpgtypes.pc libpq.pc ; \
5 kx )
5 kx # ======= Install the same to $(TARGET_DEST_DIR) =======
5 kx $(call install-into-devenv, $(PGSQL_32_PKG))
5 kx # ======= remove devenv pg_config from target package =======
5 kx @rm -f $(PGSQL_32_PKG)/usr/bin/$(TARGET32)-pg_config
5 kx # ======= tune target Makefile.global variables =======
5 kx @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version)/lib/pgxs/src ; \
5 kx sed -i "s,$(abs_build_dir),/usr/src/x86_32/build-pgsql,g" Makefile.global ; \
5 kx sed -i "s,$(BUILDSYSTEM),,g" Makefile.global ; \
5 kx sed -i "s,$(BUILD),$(TARGET32),g" Makefile.global ; \
5 kx sed -i "s, --sysroot=$(TARGET_DEST_DIR),,g" Makefile.global ; \
5 kx sed -i "s,$(TARGET_DEST_DIR),,g" Makefile.global ; \
5 kx sed -i "s,CC=.*-gcc,CC=/usr/bin/gcc,g" Makefile.global ; \
5 kx sed -i "s,CPP = .*-gcc,CPP = /usr/bin/gcc,g" Makefile.global ; \
5 kx sed -i "s,CC = .*-gcc,CC = /usr/bin/gcc,g" Makefile.global ; \
5 kx sed -i "s,AR = .*-ar,AR = /usr/bin/ar,g" Makefile.global ; \
5 kx sed -i "s,LD = .*-ld,LD = /usr/bin/ld -melf_i386,g" Makefile.global ; \
5 kx sed -i "s,RANLIB = .*-ranlib,RANLIB = /usr/bin/ranlib,g" Makefile.global ; \
5 kx sed -i "s,= .*-strip,= /usr/bin/strip,g" Makefile.global ; \
5 kx )
5 kx # ======= tune pkg-config *.pc search path to the target destination for development =======
5 kx @( cd $(TARGET_DEST_DIR)/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version)/lib/pkgconfig ; \
5 kx sed -i "s,/usr,$(TARGET_DEST_DIR)/usr,g" libecpg.pc libecpg_compat.pc \
5 kx libpgtypes.pc libpq.pc ; \
5 kx sed -i "s,L/lib,L$(TARGET_DEST_DIR)/lib,g" libecpg.pc libecpg_compat.pc \
5 kx libpgtypes.pc libpq.pc ; \
5 kx )
5 kx # ======= Strip binaries =======
5 kx @( cd $(PGSQL_32_PKG) ; \
5 kx find . | xargs file | grep "executable" | grep ELF | cut -f 1 -d : | xargs $(STRIP) --strip-unneeded 2> /dev/null ; \
5 kx find . | xargs file | grep "shared object" | grep ELF | cut -f 1 -d : | xargs $(STRIP) --strip-unneeded 2> /dev/null ; \
5 kx find . | xargs file | grep "current ar archive" | cut -f 1 -d : | xargs $(STRIP) -g 2> /dev/null ; \
5 kx )
5 kx ifneq ($(PATCHELF),)
5 kx # ======= Set RPATH/RUNPATH for target shared objects =======
5 kx @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_X86_32_SUFFIX)/postgresql/$(pg_version)/lib ; \
5 kx for file in plperl.so ; do \
5 kx rpath=`$(PATCHELF) --print-rpath $$file 2> /dev/null` ; \
5 kx if echo "$$rpath" | grep -q "$(TARGET_DEST_DIR)" ; then \
5 kx $(PATCHELF) --set-rpath $(TARGET_PERL_RPATH) $$file 1> /dev/null 2> /dev/null ; \
5 kx fi ; \
5 kx done ; \
5 kx for file in plpython$(PYTHON_MAJOR_VERSION).so ; do \
5 kx rpath=`$(PATCHELF) --print-rpath $$file 2> /dev/null` ; \
5 kx if echo "$$rpath" | grep -q "$(TARGET_DEST_DIR)" ; then \
5 kx $(PATCHELF) --set-rpath $(TARGET_PYTHON_RPATH) $$file 1> /dev/null 2> /dev/null ; \
5 kx fi ; \
5 kx done ; \
5 kx )
5 kx endif
5 kx @touch $@
5 kx
5 kx $(PGSQL_32_PKG_DESCRIPTION_FILE): $(PGSQL_32_PKG_DESCRIPTION_FILE_IN)
5 kx @cat $< | $(SED) -e "s/@VERSION@/$(version)/g" > $@
5 kx
5 kx $(pkg_certificate) : $(pkg_archive) ;
5 kx $(pkg_signature) : $(pkg_archive) ;
5 kx $(pkg_description) : $(pkg_archive) ;
5 kx
5 kx $(pkg_archive): $(install_target) $(PGSQL_32_PKG_DESCRIPTION_FILE) $(PGSQL_32_PKG_INSTALL_SCRIPT)
5 kx @cp $(PGSQL_32_PKG_DESCRIPTION_FILE) $(PGSQL_32_PKG)/.DESCRIPTION
5 kx @cp $(PGSQL_32_PKG_INSTALL_SCRIPT) $(PGSQL_32_PKG)/.INSTALL
5 kx @$(BUILD_PKG_REQUIRES) $(PGSQL_32_PKG)/.REQUIRES
5 kx @echo "pkgname=$(PGSQL_32_PKG_NAME)" > $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "pkgver=$(PGSQL_32_PKG_VERSION)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "arch=$(PGSQL_32_PKG_ARCH)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "distroname=$(PGSQL_32_PKG_DISTRO_NAME)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "distrover=$(PGSQL_32_PKG_DISTRO_VERSION)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "group=$(PGSQL_32_PKG_GROUP)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "short_description=\"$(PGSQL_32_PKG_SHORT_DESCRIPTION)\"" >> $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "url=$(PGSQL_32_PKG_URL)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
5 kx echo "license=$(PGSQL_32_PKG_LICENSE)" >> $(PGSQL_32_PKG)/.PKGINFO
5 kx @$(PSEUDO) sh -c "cd $(PGSQL_32_PKG) && \
5 kx chown -R root:root . && \
5 kx $(MAKE_PACKAGE) -J --linkadd=yes $(GNUPG_OPTIONS) -m -d .. ."