Index: Makefile
===================================================================
--- Makefile (nonexistent)
+++ Makefile (revision 5)
@@ -0,0 +1,312 @@
+
+COMPONENT_TARGETS = $(HARDWARE_S824L)
+COMPONENT_TARGETS += $(HARDWARE_VESNIN)
+COMPONENT_TARGETS += $(HARDWARE_TL2WK2)
+COMPONENT_TARGETS += $(HARDWARE_TL2SV2)
+
+NEED_ABS_PATH = true
+COMPONENT_IS_3PP = true
+
+CREATE_PPC32_PACKAGE = true
+
+
+include ../../../build-system/constants.mk
+
+
+SOURCE_REQUIRES = sources/packages/b/postgresql
+
+REQUIRES = app/postgresql/14.1
+REQUIRES += dev/perl/5.36.0-ppc32
+REQUIRES += dev/python3/3.10.8-ppc32
+REQUIRES += app/util-linux/2.38.1-ppc32
+REQUIRES += libs/libxml2/2.9.9-ppc32
+REQUIRES += libs/libxslt/1.1.34-ppc32
+REQUIRES += libs/readline/8.2-ppc32
+REQUIRES += libs/icu4c/68.2-ppc32
+REQUIRES += libs/lz4/1.9.4-ppc32
+REQUIRES += net/openssl/1.1.1r-ppc32
+REQUIRES += net/krb5/1.19.1-ppc32
+REQUIRES += secure/pam/1.5.1-ppc32
+
+# ======= __END_OF_REQUIRES__ =======
+
+
+version = 14.1
+pg_version = $(shell echo $(version) | cut -f1,2 -d '.')
+tar_bz2_archive = $(SRC_PACKAGE_PATH)/packages/b/postgresql/postgresql-$(version).tar.bz2
+SRC_ARCHIVE = $(tar_bz2_archive)
+SRC_DIR = $(TARGET_BUILD_DIR)/postgresql-$(version)
+src_dir_name = postgresql-$(version)
+src_done = $(TARGET_BUILD_DIR)/.source_done
+
+PATCHES = PATCHES
+
+build_tools_dir = $(TARGET_BUILD_DIR)/build-tools
+
+build_dir = $(TARGET_BUILD_DIR)/build
+build_target = $(TARGET_BUILD_DIR)/.build_done
+install_target = $(TARGET_BUILD_DIR)/.install_done
+
+abs_build_dir = $(CURDIR)/$(build_dir)
+
+
+####### Targets
+
+PKG_GROUP = app
+
+#
+# *PKG_NAME & *PKG_VERSION shouldn't be a reference to value.
+#
+PGSQL_32_PKG_NAME = postgresql-x32
+PGSQL_32_PKG_VERSION = 14.1
+PGSQL_32_PKG_ARCH = $(PKGARCH)
+PGSQL_32_PKG_DISTRO_NAME = $(DISTRO_NAME)
+PGSQL_32_PKG_DISTRO_VERSION = $(DISTRO_VERSION)
+PGSQL_32_PKG_GROUP = $(PKG_GROUP)
+### |---handy-ruler-------------------------------|
+PGSQL_32_PKG_SHORT_DESCRIPTION = database management system
+PGSQL_32_PKG_URL = $(BUG_URL)
+PGSQL_32_PKG_LICENSE = custom
+PGSQL_32_PKG_DESCRIPTION_FILE = $(TARGET_BUILD_DIR)/$(PGSQL_32_PKG_NAME)-pkg-description
+PGSQL_32_PKG_DESCRIPTION_FILE_IN = $(PGSQL_32_PKG_NAME)-pkg-description.in
+PGSQL_32_PKG_INSTALL_SCRIPT = $(PGSQL_32_PKG_NAME)-pkg-install.sh
+
+PGSQL_32_PKG = $(CURDIR)/$(TARGET_BUILD_DIR)/$(PGSQL_32_PKG_NAME)-package
+
+pkg_basename = $(PGSQL_32_PKG_NAME)-$(PGSQL_32_PKG_VERSION)-$(PGSQL_32_PKG_ARCH)-$(PGSQL_32_PKG_DISTRO_NAME)-$(PGSQL_32_PKG_DISTRO_VERSION)
+
+pkg_archive = $(TARGET_BUILD_DIR)/$(PKG_GROUP)/$(pkg_basename).$(pkg_arch_suffix)
+pkg_certificate = $(call cert-name,$(pkg_archive))
+pkg_signature = $(call sign-name,$(pkg_archive))
+pkg_description = $(call desc-name,$(pkg_archive))
+products = $(call pkg-files,$(pkg_archive))
+
+BUILD_TARGETS = $(build_target)
+BUILD_TARGETS += $(install_target)
+
+PRODUCT_TARGETS = $(products)
+
+ROOTFS_TARGETS = $(pkg_archive)
+
+
+include ../../../build-system/core.mk
+
+
+env_sysroot = DESTDIR=$(PGSQL_32_PKG)
+
+
+#
+# Perl Configuration:
+#
+extra_environment = PERL=$(PERL)
+extra_environment += pgac_perl_version=5.34.0
+extra_environment += perl_archlibexp='$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_PPC32_SUFFIX)/perl5'
+extra_environment += perl_privlibexp='$(TARGET_DEST_DIR)/usr/share/perl5'
+extra_environment += perl_includespec='-I$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_PPC32_SUFFIX)/perl5/CORE'
+extra_environment += perl_useshrplib='true'
+extra_environment += perl_embed_ldflags='-L$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_PPC32_SUFFIX)/perl5/CORE -Wl,-E -Wl,-rpath,/usr/lib$(MULTILIB_PPC32_SUFFIX)/perl5/CORE -lperl'
+
+#
+# Python Configuration:
+#
+PYTHON_VERSION = 3.10
+
+python-configdir = $(shell echo "$(shell dirname $(shell ls $(TARGET_DEST_DIR)/usr/lib$(MULTILIB_PPC32_SUFFIX)/python$(1)/config-$(1)-*/config.c))")
+
+extra_environment += python_version=$(PYTHON_VERSION)
+extra_environment += python_majorversion=$(PYTHON_MAJOR_VERSION)
+extra_environment += python_configdir='$(call python-configdir,$(PYTHON_VERSION))'
+extra_environment += python_includespec='-I$(TARGET_DEST_DIR)/usr/include/python$(PYTHON_VERSION)'
+extra_environment += python_libdir='$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_PPC32_SUFFIX)'
+extra_environment += python_enable_shared=1
+extra_environment += python_libspec='-L$(TARGET_DEST_DIR)/usr/lib$(MULTILIB_PPC32_SUFFIX) -lpython$(PYTHON_VERSION)'
+extra_environment += python_additional_libs='-lpthread -ldl -lutil -lm'
+
+#
+# Tools configure switches (for devenv pg_config):
+#
+tools_configure_switches = --docdir=/usr/share/doc/$(src_dir_name)
+tools_configure_switches += --mandir=/usr/share/man
+
+tools_configure_switches += --includedir=/usr/include
+tools_configure_switches += --sysconfdir=/etc/postgresql/$(pg_version)
+tools_configure_switches += --datarootdir=/usr/share
+tools_configure_switches += --datadir=/usr/share/postgresql-$(pg_version)
+
+#
+# configure switches:
+#
+extra_configure_switches = --docdir=/usr/share/doc/$(src_dir_name)
+extra_configure_switches += --mandir=/usr/share/man
+
+extra_configure_switches += --includedir=/usr/include
+extra_configure_switches += --sysconfdir=/etc/postgresql/$(pg_version)
+extra_configure_switches += --datarootdir=/usr/share
+extra_configure_switches += --datadir=/usr/share/postgresql-$(pg_version)
+
+extra_configure_switches += --with-openssl
+extra_configure_switches += --with-tcl=no
+extra_configure_switches += --with-perl
+extra_configure_switches += --with-python
+extra_configure_switches += --with-libxml
+extra_configure_switches += --with-libxslt
+
+extra_configure_switches += --with-gssapi
+extra_configure_switches += --with-icu
+extra_configure_switches += --with-uuid=e2fs
+extra_configure_switches += --with-ldap
+extra_configure_switches += --with-lz4
+
+extra_configure_switches += --enable-thread-safety
+extra_configure_switches += --with-system-tzdata=/usr/share/zoneinfo
+extra_configure_switches += --enable-nls
+extra_configure_switches += --with-pam
+
+
+TARGET_PERL_RPATH = /usr/lib$(MULTILIB_PPC32_SUFFIX):/usr/lib$(MULTILIB_PPC32_SUFFIX)/perl5/CORE:/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version)/lib
+TARGET_PYTHON_RPATH = /usr/lib$(MULTILIB_PPC32_SUFFIX):/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version)/lib
+TARGET_LIB_RPATH = $(TARGET_PYTHON_RPATH)
+
+CFLAGS += -Wno-unused-function
+LDFLAGS += -Wl,-rpath,$(TARGET_LIB_RPATH)
+
+
+####### Dependencies
+
+$(src_done): $(SRC_ARCHIVE) $(PATCHES_DEP)
+ $(UNPACK_SRC_ARCHIVE)
+ $(APPLY_PATCHES)
+ # ======= remove parser files to build its again =======
+ @( rm -f $(SRC_DIR)/src/backend/parser/gram.{c,h} )
+ @touch $@
+
+$(build_target): $(src_done)
+ @mkdir -p $(PGSQL_32_PKG)/usr/bin
+ @mkdir -p $(build_tools_dir)
+ # ======= build pg_config for development environment =======
+ @( cd $(build_tools_dir) ; \
+ ../$(src_dir_name)/configure \
+ --prefix=/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version) \
+ $(tools_configure_switches) ; \
+ ( cd src/backend && $(MAKE) generated-headers ) ; \
+ $(MAKE) -C src/bin/pg_config ; \
+ cp -a src/bin/pg_config/pg_config $(PGSQL_32_PKG)/usr/bin/$(TARGET32)-pg_config ; \
+ )
+ # ======= build PostgreSQL for target machine =======
+ @mkdir -p $(build_dir)
+ @cd $(build_dir) && \
+ $(BUILD_ENVIRONMENT) $(extra_environment) ../$(src_dir_name)/configure \
+ --prefix=/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version) \
+ --build=$(BUILD) \
+ --host=$(TARGET32) \
+ $(extra_configure_switches)
+ # ======= make links in src/include directory to generated header files =======
+ @cd $(build_dir)/src/backend && $(MAKE) generated-headers
+ # ======= build postgresql-$(version) =======
+ @cd $(build_dir) && $(BUILD_ENVIRONMENT) $(MAKE) XSUBPPDIR=$(TARGET_DEST_DIR)/usr/share/perl5
+ @touch $@
+
+$(install_target): $(build_target)
+ @mkdir -p $(PGSQL_32_PKG)
+ @cd $(build_dir) && $(BUILD_ENVIRONMENT) $(MAKE) -j1 install $(env_sysroot)
+ @rm -rf $(PGSQL_32_PKG)/usr/include
+ @rm -rf $(PGSQL_32_PKG)/usr/share
+ # ======= create symlinks to binary executables =======
+ @mkdir -p $(PGSQL_32_PKG)/usr/bin/32
+ @( cd $(PGSQL_32_PKG)/usr/bin/32 ; \
+ for i in `ls ../../lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version)/bin/*` ; do \
+ ln -sf $$i ; \
+ done ; \
+ )
+ # ======= create symlinks to shared library for other programs =======
+ @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_PPC32_SUFFIX) ; \
+ for i in `ls postgresql/$(pg_version)/lib/lib*.so*` ; do \
+ ln -sf $$i ; \
+ done ; \
+ )
+ # ======= create symlinks to pkg-config files for other programs =======
+ @mkdir $(PGSQL_32_PKG)/usr/lib$(MULTILIB_PPC32_SUFFIX)/pkgconfig
+ @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_PPC32_SUFFIX)/pkgconfig ; \
+ for i in `ls ../postgresql/$(pg_version)/lib/pkgconfig/*.pc` ; do \
+ ln -sf $$i ; \
+ done ; \
+ )
+ # ======= remove toolchain path from target pkg-config *.pc files =======
+ @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version)/lib/pkgconfig ; \
+ sed -i "s,$(TARGET_DEST_DIR),,g" libecpg.pc libecpg_compat.pc \
+ libpgtypes.pc libpq.pc ; \
+ )
+ # ======= Install the same to $(TARGET_DEST_DIR) =======
+ $(call install-into-devenv, $(PGSQL_32_PKG))
+ # ======= remove devenv pg_config from target package =======
+ @rm -f $(PGSQL_32_PKG)/usr/bin/$(TARGET32)-pg_config
+ # ======= tune target Makefile.global variables =======
+ @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version)/lib/pgxs/src ; \
+ sed -i "s,$(abs_build_dir),/usr/src/ppc32/build-pgsql,g" Makefile.global ; \
+ sed -i "s,$(BUILDSYSTEM),,g" Makefile.global ; \
+ sed -i "s,$(BUILD),$(TARGET32),g" Makefile.global ; \
+ sed -i "s, --sysroot=$(TARGET_DEST_DIR),,g" Makefile.global ; \
+ sed -i "s,$(TARGET_DEST_DIR),,g" Makefile.global ; \
+ sed -i "s,CC=.*-gcc,CC=/usr/bin/gcc,g" Makefile.global ; \
+ sed -i "s,CPP = .*-gcc,CPP = /usr/bin/gcc,g" Makefile.global ; \
+ sed -i "s,CC = .*-gcc,CC = /usr/bin/gcc,g" Makefile.global ; \
+ sed -i "s,AR = .*-ar,AR = /usr/bin/ar,g" Makefile.global ; \
+ sed -i "s,LD = .*-ld,LD = /usr/bin/ld -melf_i386,g" Makefile.global ; \
+ sed -i "s,RANLIB = .*-ranlib,RANLIB = /usr/bin/ranlib,g" Makefile.global ; \
+ sed -i "s,= .*-strip,= /usr/bin/strip,g" Makefile.global ; \
+ )
+ # ======= tune pkg-config *.pc search path to the target destination for development =======
+ @( cd $(TARGET_DEST_DIR)/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version)/lib/pkgconfig ; \
+ sed -i "s,/usr,$(TARGET_DEST_DIR)/usr,g" libecpg.pc libecpg_compat.pc \
+ libpgtypes.pc libpq.pc ; \
+ sed -i "s,L/lib,L$(TARGET_DEST_DIR)/lib,g" libecpg.pc libecpg_compat.pc \
+ libpgtypes.pc libpq.pc ; \
+ )
+ # ======= Strip binaries =======
+ @( cd $(PGSQL_32_PKG) ; \
+ find . | xargs file | grep "executable" | grep ELF | cut -f 1 -d : | xargs $(STRIP) --strip-unneeded 2> /dev/null ; \
+ find . | xargs file | grep "shared object" | grep ELF | cut -f 1 -d : | xargs $(STRIP) --strip-unneeded 2> /dev/null ; \
+ find . | xargs file | grep "current ar archive" | cut -f 1 -d : | xargs $(STRIP) -g 2> /dev/null ; \
+ )
+ifneq ($(PATCHELF),)
+ # ======= Set RPATH/RUNPATH for target shared objects =======
+ @( cd $(PGSQL_32_PKG)/usr/lib$(MULTILIB_PPC32_SUFFIX)/postgresql/$(pg_version)/lib ; \
+ for file in plperl.so ; do \
+ rpath=`$(PATCHELF) --print-rpath $$file 2> /dev/null` ; \
+ if echo "$$rpath" | grep -q "$(TARGET_DEST_DIR)" ; then \
+ $(PATCHELF) --set-rpath $(TARGET_PERL_RPATH) $$file 1> /dev/null 2> /dev/null ; \
+ fi ; \
+ done ; \
+ for file in plpython$(PYTHON_MAJOR_VERSION).so ; do \
+ rpath=`$(PATCHELF) --print-rpath $$file 2> /dev/null` ; \
+ if echo "$$rpath" | grep -q "$(TARGET_DEST_DIR)" ; then \
+ $(PATCHELF) --set-rpath $(TARGET_PYTHON_RPATH) $$file 1> /dev/null 2> /dev/null ; \
+ fi ; \
+ done ; \
+ )
+endif
+ @touch $@
+
+$(PGSQL_32_PKG_DESCRIPTION_FILE): $(PGSQL_32_PKG_DESCRIPTION_FILE_IN)
+ @cat $< | $(SED) -e "s/@VERSION@/$(version)/g" > $@
+
+$(pkg_certificate) : $(pkg_archive) ;
+$(pkg_signature) : $(pkg_archive) ;
+$(pkg_description) : $(pkg_archive) ;
+
+$(pkg_archive): $(install_target) $(PGSQL_32_PKG_DESCRIPTION_FILE) $(PGSQL_32_PKG_INSTALL_SCRIPT)
+ @cp $(PGSQL_32_PKG_DESCRIPTION_FILE) $(PGSQL_32_PKG)/.DESCRIPTION
+ @cp $(PGSQL_32_PKG_INSTALL_SCRIPT) $(PGSQL_32_PKG)/.INSTALL
+ @$(BUILD_PKG_REQUIRES) $(PGSQL_32_PKG)/.REQUIRES
+ @echo "pkgname=$(PGSQL_32_PKG_NAME)" > $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "pkgver=$(PGSQL_32_PKG_VERSION)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "arch=$(PGSQL_32_PKG_ARCH)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "distroname=$(PGSQL_32_PKG_DISTRO_NAME)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "distrover=$(PGSQL_32_PKG_DISTRO_VERSION)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "group=$(PGSQL_32_PKG_GROUP)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "short_description=\"$(PGSQL_32_PKG_SHORT_DESCRIPTION)\"" >> $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "url=$(PGSQL_32_PKG_URL)" >> $(PGSQL_32_PKG)/.PKGINFO ; \
+ echo "license=$(PGSQL_32_PKG_LICENSE)" >> $(PGSQL_32_PKG)/.PKGINFO
+ @$(PSEUDO) sh -c "cd $(PGSQL_32_PKG) && \
+ chown -R root:root . && \
+ $(MAKE_PACKAGE) -J --linkadd=yes $(GNUPG_OPTIONS) -m -d .. ."
Index: PATCHES
===================================================================
--- PATCHES (nonexistent)
+++ PATCHES (revision 5)
@@ -0,0 +1,3 @@
+
+../../../sources/packages/b/postgresql/patches/postgresql-14.1-cross-configure.patch -p0
+../../../sources/packages/b/postgresql/patches/postgresql-14.1-run-socket-dir.patch -p0
Index: postgresql-x32-pkg-description.in
===================================================================
--- postgresql-x32-pkg-description.in (nonexistent)
+++ postgresql-x32-pkg-description.in (revision 5)
@@ -0,0 +1,19 @@
+# HOW TO EDIT THIS FILE:
+# The "handy ruler" below makes it easier to edit a package description. Line
+# up the first '|' above the ':' following the base package name, and the '|'
+# on the right side marks the last column you can put a character in. You must
+# make exactly 11 lines for the formatting to be correct. It's also
+# customary to leave one space after the ':'.
+
+ |-----handy-ruler------------------------------------------------------|
+postgresql-x32: PostgreSQL-x32 @VERSION@ (database management system)
+postgresql-x32:
+postgresql-x32: PostgreSQL is an advanced object-relational database management
+postgresql-x32: system (ORDBMS) based on POSTGRES. With more than 15 years of
+postgresql-x32: development history, it is quickly becoming the de facto
+postgresql-x32: database for enterprise level open source solutions.
+postgresql-x32:
+postgresql-x32: Homepage: https://www.postgresql.org
+postgresql-x32:
+postgresql-x32:
+postgresql-x32:
Index: postgresql-x32-pkg-install.sh
===================================================================
--- postgresql-x32-pkg-install.sh (nonexistent)
+++ postgresql-x32-pkg-install.sh (revision 5)
@@ -0,0 +1,39 @@
+#!/bin/sh
+
+# arg 1: the new package version
+pre_install() {
+ /bin/true
+}
+
+# arg 1: the new package version
+post_install() {
+ /bin/true
+}
+
+# arg 1: the new package version
+# arg 2: the old package version
+pre_update() {
+ /bin/true
+}
+
+# arg 1: the new package version
+# arg 2: the old package version
+post_update() {
+ post_install
+}
+
+# arg 1: the old package version
+pre_remove() {
+ /bin/true
+}
+
+# arg 1: the old package version
+post_remove() {
+ /bin/true
+}
+
+
+operation=$1
+shift
+
+$operation $*
Property changes on: postgresql-x32-pkg-install.sh
___________________________________________________________________
Added: svn:executable
## -0,0 +1 ##
+*
\ No newline at end of property
Index: .
===================================================================
--- . (nonexistent)
+++ . (revision 5)
Property changes on: .
___________________________________________________________________
Added: svn:ignore
## -0,0 +1,73 ##
+
+# install dir
+dist
+
+# Target build dirs
+.a1x-newlib
+.a2x-newlib
+.at91sam7s-newlib
+
+.build-machine
+
+.a1x-glibc
+.a2x-glibc
+.h3-glibc
+.h5-glibc
+.i586-glibc
+.i686-glibc
+.imx6-glibc
+.jz47xx-glibc
+.makefile
+.am335x-glibc
+.omap543x-glibc
+.p5600-glibc
+.power8-glibc
+.power8le-glibc
+.power9-glibc
+.power9le-glibc
+.m1000-glibc
+.riscv64-glibc
+.rk328x-glibc
+.rk33xx-glibc
+.rk339x-glibc
+.s8xx-glibc
+.s9xx-glibc
+.x86_64-glibc
+
+# Hidden files (each file)
+.makefile
+.dist
+.rootfs
+
+# src & hw requires
+.src_requires
+.src_requires_depend
+.requires
+.requires_depend
+
+# Tarballs
+*.gz
+*.bz2
+*.lz
+*.xz
+*.tgz
+*.txz
+
+# Signatures
+*.asc
+*.sig
+*.sign
+*.sha1sum
+
+# Patches
+*.patch
+
+# Descriptions
+*.dsc
+*.txt
+
+# Default linux config files
+*.defconfig
+
+# backup copies
+*~