diff options
Diffstat (limited to 'system/postgresql/README')
| -rw-r--r-- | system/postgresql/README | 54 |
1 files changed, 54 insertions, 0 deletions
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 <dpage@vale-housing.co.uk> + +tsearch2 - + Full-text-index support using GiST + by Teodor Sigaev <teodor@sigaev.ru> and Oleg Bartunov + <oleg@sai.msu.su>. + + +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 + + |