From ef04462873b369ade9ccd90b764d5e1d45e5f6a2 Mon Sep 17 00:00:00 2001 From: Slack Coder Date: Wed, 27 Mar 2024 15:57:01 -0500 Subject: Use _slackcoder tags --- postgresql/README | 4 +++- postgresql/README.SBo | 51 ---------------------------------------- postgresql/README_slackware.txt | 51 ++++++++++++++++++++++++++++++++++++++++ postgresql/postgresql.SlackBuild | 2 +- 4 files changed, 55 insertions(+), 53 deletions(-) delete mode 100644 postgresql/README.SBo create mode 100644 postgresql/README_slackware.txt diff --git a/postgresql/README b/postgresql/README index 5e488da..6f98a82 100644 --- a/postgresql/README +++ b/postgresql/README @@ -4,7 +4,7 @@ development history, it is quickly becoming the de facto database for enterprise level open source solutions. Before you can run postgresql you'll need to create the database; -please see README.SBo. +please see README_slackware.txt. You need a "postgres" user and group prior to building postgresql. Something like this will suffice for most systems: @@ -12,3 +12,5 @@ Something like this will suffice for most systems: useradd -u 209 -g 209 -d /var/lib/pgsql postgres Feel free to use a different uid and gid if desired, but 209 is recommended to avoid conflicts with other stuff from SlackBuilds.org. + +This is a fork from slackbuild.org's build script to bump to version 15. diff --git a/postgresql/README.SBo b/postgresql/README.SBo deleted file mode 100644 index 89e1424..0000000 --- a/postgresql/README.SBo +++ /dev/null @@ -1,51 +0,0 @@ -Before you can run postgresql you'll need to create the -database files in /var/lib/pgsql. The following should do -the trick. - # su postgres -c "initdb -D /var/lib/pgsql/14/data --locale=en_US.UTF-8 -A md5 -W" - -Additionally, a logrotation script and init script are included. -For production level log file handling please read -https://www.postgresql.org/docs/14/logfile-maintenance.html - -In order to start postgresql at boot and stop it properly at shutdown, -make sure rc.postgresql is executable and add the following lines to -the following files: - - /etc/rc.d/rc.local - ================== - # Startup postgresql - if [ -x /etc/rc.d/rc.postgresql ]; then - /etc/rc.d/rc.postgresql start - fi - - /etc/rc.d/rc.local_shutdown - =========================== - # Stop postgres - if [ -x /etc/rc.d/rc.postgresql ]; then - /etc/rc.d/rc.postgresql stop - fi - -Additionally, rc.postgresql script has additional modes for stop/restart: - force-stop|force-restart (i.e. pg_ctl 'fast' mode) - unclean-stop|unclean-restart (i.e. pg_ctl 'immediate' mode) -See https://www.postgresql.org/docs/14/app-pg-ctl.html - -From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade: - https://www.postgresql.org/docs/14/pgupgrade.html - -A few hints for PostgreSQL 10.x -> 14.x upgrade: - - Don't remove old PostgreSQL 10.x package - - Install PostgreSQL 14.x, note that binaries are in - '/usr/lib64/postgresql/14/bin' - - Follow regular pg_upgrade docs - - Remove old package when transition is over, or read comments in - rc.postgresql if you want to run multiple PostgreSQL versions in parallel - -This script builds postgresql with some useful extension modules from -the contrib directory, see PG_EXTENSIONS in SlackBuild file. -To build PostgreSQL with all extensions, use the following command: - - # PG_EXTENSIONS=ALL ./postgresql.SlackBuild - -Please note that in order to actually use extension, you must execute -'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension. diff --git a/postgresql/README_slackware.txt b/postgresql/README_slackware.txt new file mode 100644 index 0000000..89e1424 --- /dev/null +++ b/postgresql/README_slackware.txt @@ -0,0 +1,51 @@ +Before you can run postgresql you'll need to create the +database files in /var/lib/pgsql. The following should do +the trick. + # su postgres -c "initdb -D /var/lib/pgsql/14/data --locale=en_US.UTF-8 -A md5 -W" + +Additionally, a logrotation script and init script are included. +For production level log file handling please read +https://www.postgresql.org/docs/14/logfile-maintenance.html + +In order to start postgresql at boot and stop it properly at shutdown, +make sure rc.postgresql is executable and add the following lines to +the following files: + + /etc/rc.d/rc.local + ================== + # Startup postgresql + if [ -x /etc/rc.d/rc.postgresql ]; then + /etc/rc.d/rc.postgresql start + fi + + /etc/rc.d/rc.local_shutdown + =========================== + # Stop postgres + if [ -x /etc/rc.d/rc.postgresql ]; then + /etc/rc.d/rc.postgresql stop + fi + +Additionally, rc.postgresql script has additional modes for stop/restart: + force-stop|force-restart (i.e. pg_ctl 'fast' mode) + unclean-stop|unclean-restart (i.e. pg_ctl 'immediate' mode) +See https://www.postgresql.org/docs/14/app-pg-ctl.html + +From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade: + https://www.postgresql.org/docs/14/pgupgrade.html + +A few hints for PostgreSQL 10.x -> 14.x upgrade: + - Don't remove old PostgreSQL 10.x package + - Install PostgreSQL 14.x, note that binaries are in + '/usr/lib64/postgresql/14/bin' + - Follow regular pg_upgrade docs + - Remove old package when transition is over, or read comments in + rc.postgresql if you want to run multiple PostgreSQL versions in parallel + +This script builds postgresql with some useful extension modules from +the contrib directory, see PG_EXTENSIONS in SlackBuild file. +To build PostgreSQL with all extensions, use the following command: + + # PG_EXTENSIONS=ALL ./postgresql.SlackBuild + +Please note that in order to actually use extension, you must execute +'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension. diff --git a/postgresql/postgresql.SlackBuild b/postgresql/postgresql.SlackBuild index 64b8345..63840eb 100644 --- a/postgresql/postgresql.SlackBuild +++ b/postgresql/postgresql.SlackBuild @@ -32,7 +32,7 @@ cd $(dirname $0) ; CWD=$(pwd) PRGNAM=postgresql VERSION=${VERSION:-15.5} BUILD=${BUILD:-1} -TAG=${TAG:-_SBo} +TAG=${TAG:-_slackcoder} PKGTYPE=${PKGTYPE:-tgz} PG_VERSION=${PG_VERSION:-15} -- cgit v1.2.3