From bae18fdb80148edcdae1b2576e950bd40bcbea4d Mon Sep 17 00:00:00 2001 From: Adis Nezirovic Date: Tue, 11 May 2010 15:18:43 +0200 Subject: system/postgresql: Initial import --- system/postgresql/README | 54 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 54 insertions(+) create mode 100644 system/postgresql/README (limited to 'system/postgresql/README') diff --git a/system/postgresql/README b/system/postgresql/README new file mode 100644 index 0000000000..a2c2a18999 --- /dev/null +++ b/system/postgresql/README @@ -0,0 +1,54 @@ +PostgreSQL is an advanced object-relational database management +system (ORDBMS) based on POSTGRES. With more than 15 years of +development history, it is quickly becoming the de facto +database for enterprise level open source solutions. + +Homepage: http://www.postgresql.org + +This script builds postgresql with a couple of useful features in the +contrib directory. + +adminpack - + File and log manipulation routines, used by pgAdmin + by Dave Page + +tsearch2 - + Full-text-index support using GiST + by Teodor Sigaev and Oleg Bartunov + . + + +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/data" + +Additionally, a logrotation script is added to /etc/logrotate.d/ and an +rc.postgresql script is added. In order to activate postgresql at boot +time and shut it down properly upon system shutdown, 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, you'll have to set the rc script to be executable just +like any other Slackware rc script. + + # chmod +x /etc/rc.d/rc.postgresql + + -- cgit v1.2.3