summaryrefslogtreecommitdiffstats
path: root/system/postgresql/README.SBo
diff options
context:
space:
mode:
author Adis Nezirovic2010-05-11 22:27:00 +0200
committer David Somero2010-05-11 22:27:00 +0200
commit99e62536447ecb3c2c89631437848c42ec0f5b93 (patch)
treee9ba6886a68a04db0f68621ea6f0735a36794bf0 /system/postgresql/README.SBo
parent65739ea69c3643507c111655bce1ce3f98dc0f45 (diff)
downloadslackbuilds-99e62536447ecb3c2c89631437848c42ec0f5b93.tar.gz
system/postgresql: Updated for version 8.3.5
Diffstat (limited to 'system/postgresql/README.SBo')
-rw-r--r--system/postgresql/README.SBo37
1 files changed, 37 insertions, 0 deletions
diff --git a/system/postgresql/README.SBo b/system/postgresql/README.SBo
new file mode 100644
index 0000000000..24bd944c72
--- /dev/null
+++ b/system/postgresql/README.SBo
@@ -0,0 +1,37 @@
+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 and init script are included.
+For production level log file handling please read
+http://www.postgresql.org/docs/8.3/interactive/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
+
+This script builds postgresql with the 'adminpack', 'tsearch2', and
+'pgcrypto' features in the contrib directory.
+
+Please note that in order to actually use extension, you must execute
+accompanying SQL scripts located in /usr/share/postgresql/contrib
+
+Since 8.3 tsearch2 functionality is available in PostgreSQL core, and
+'tsearch2' extension serves only as a compatibility layer. You can
+prevent building of this extension with:
+ TSEARCH2_COMPAT=no ./postgresql.SlackBuild