README_slackware.txt (1970B)
1 Before you can run postgresql you'll need to create the 2 database files in /var/lib/pgsql. The following should do 3 the trick. 4 # su postgres -c "initdb -D /var/lib/pgsql/14/data --locale=en_US.UTF-8 -A md5 -W" 5 6 Additionally, a logrotation script and init script are included. 7 For production level log file handling please read 8 https://www.postgresql.org/docs/14/logfile-maintenance.html 9 10 In order to start postgresql at boot and stop it properly at shutdown, 11 make sure rc.postgresql is executable and add the following lines to 12 the following files: 13 14 /etc/rc.d/rc.local 15 ================== 16 # Startup postgresql 17 if [ -x /etc/rc.d/rc.postgresql ]; then 18 /etc/rc.d/rc.postgresql start 19 fi 20 21 /etc/rc.d/rc.local_shutdown 22 =========================== 23 # Stop postgres 24 if [ -x /etc/rc.d/rc.postgresql ]; then 25 /etc/rc.d/rc.postgresql stop 26 fi 27 28 Additionally, rc.postgresql script has additional modes for stop/restart: 29 force-stop|force-restart (i.e. pg_ctl 'fast' mode) 30 unclean-stop|unclean-restart (i.e. pg_ctl 'immediate' mode) 31 See https://www.postgresql.org/docs/14/app-pg-ctl.html 32 33 From PostgreSQL 9.3 we support in place database upgrades using pg_upgrade: 34 https://www.postgresql.org/docs/14/pgupgrade.html 35 36 A few hints for PostgreSQL 10.x -> 14.x upgrade: 37 - Don't remove old PostgreSQL 10.x package 38 - Install PostgreSQL 14.x, note that binaries are in 39 '/usr/lib64/postgresql/14/bin' 40 - Follow regular pg_upgrade docs 41 - Remove old package when transition is over, or read comments in 42 rc.postgresql if you want to run multiple PostgreSQL versions in parallel 43 44 This script builds postgresql with some useful extension modules from 45 the contrib directory, see PG_EXTENSIONS in SlackBuild file. 46 To build PostgreSQL with all extensions, use the following command: 47 48 # PG_EXTENSIONS=ALL ./postgresql.SlackBuild 49 50 Please note that in order to actually use extension, you must execute 51 'CREATE EXTENSION [ IF NOT EXISTS ] extension_name' for each extension.