summaryrefslogtreecommitdiff
path: root/databases/postgresql-devel/files
diff options
context:
space:
mode:
authorSean Chittenden <seanc@FreeBSD.org>2005-11-17 00:04:58 +0000
committerSean Chittenden <seanc@FreeBSD.org>2005-11-17 00:04:58 +0000
commit0ea3f56ce4e3e64541f3c3baf787bc1d7011d9ef (patch)
tree8566241aeb1b751c728fea6eebcb0a6a1fd2cb5a /databases/postgresql-devel/files
parent- Don't create /var/log/jarfile, it's not used (diff)
devel/bison1875's time has come and gone and its only consumer is the
databases/postgresql-devel port, which isn't needed either now that 8.1 has officially landed. Submitted by: ade@
Notes
Notes: svn path=/head/; revision=148537
Diffstat (limited to 'databases/postgresql-devel/files')
-rw-r--r--databases/postgresql-devel/files/502.pgsql81
-rw-r--r--databases/postgresql-devel/files/dot.cshrc.in7
-rw-r--r--databases/postgresql-devel/files/dot.profile.in11
-rw-r--r--databases/postgresql-devel/files/patch-contrib::pgcrypto::Makefile20
-rw-r--r--databases/postgresql-devel/files/pgsql.sh.tmpl40
-rw-r--r--databases/postgresql-devel/files/post-install-notes45
6 files changed, 0 insertions, 204 deletions
diff --git a/databases/postgresql-devel/files/502.pgsql b/databases/postgresql-devel/files/502.pgsql
deleted file mode 100644
index 3a44f1132ac8..000000000000
--- a/databases/postgresql-devel/files/502.pgsql
+++ /dev/null
@@ -1,81 +0,0 @@
-#!/bin/sh
-#
-# $FreeBSD$
-#
-# Maintenance shell script to vacuum and backup database
-# Put this in /usr/local/etc/periodic/daily, and it will be run
-# every night
-#
-# Written by Palle Girgensohn <girgen@partitur.se>
-#
-# In public domain, do what you like with it,
-# and use it at your own risk... :)
-#
-######################################################################
-#
-# If you like to tweak the settings of the variables PGBACKUPDIR and
-# PGDUMP_ARGS, you should preferably set them in ~pgsql/.profile.
-# If set there, that setting will override the defaults here.
-#
-######################################################################
-
-DIR=`dirname $0`
-progname=`basename $0`
-PRG=`cd $DIR; pwd `/$progname
-
-# Run as user pgsql
-if [ `id -un` != pgsql ]; then
- su -l pgsql -c ${PRG}
- exit $?
-fi
-
-# arguments to pg_dump
-PGDUMP_ARGS=${PGDUMP_ARGS:-"-b -F c"}
-
-# The directory where the backups will reside.
-# ${HOME} is pgsql's home directory
-#
-PGBACKUPDIR=${PGBACKUPDIR:-${HOME}/backups}
-
-# PGBACKUPDIR must be writeable by user pgsql
-# ~pgsql is just that under normal circumstances,
-# but this might not be where you want the backups...
-if [ ! -d ${PGBACKUPDIR} ] ; then
- echo Creating ${PGBACKUPDIR}
- mkdir ${PGBACKUPDIR}
- chmod 700 ${PGBACKUPDIR}
-fi
-
-echo
-echo "PostgreSQL maintenance"
-
-# Protect the data
-umask 077
-dbnames=`psql -q -t -A -d template1 -c "SELECT datname FROM pg_database WHERE datname != 'template0'"`
-rc=$?
-for db in ${dbnames}; do
- echo -n " $db"
- file=${PGBACKUPDIR}/pgdump_${db}_`date "+%Y%m%d"`
- pg_dump ${PGDUMP_ARGS} -d $db -f ${file}
- [ $? -gt 0 ] && rc=3
-done
-
-if [ $rc -gt 0 ]; then
- echo
- echo "Errors were reported during backup."
-fi
-
-echo
-echo "vacuuming..."
-vacuumdb -a -z -q
-if [ $? -gt 0 ]
-then
- echo
- echo "Errors were reported during vacuum."
- rc=3
-fi
-
-# cleaning up old data
-find ${PGBACKUPDIR} -name 'pgdump_*' -a -atime +7 -delete
-
-exit $rc
diff --git a/databases/postgresql-devel/files/dot.cshrc.in b/databases/postgresql-devel/files/dot.cshrc.in
deleted file mode 100644
index f8e190c1613e..000000000000
--- a/databases/postgresql-devel/files/dot.cshrc.in
+++ /dev/null
@@ -1,7 +0,0 @@
-set path = ( %%PREFIX%%/bin $path )
-
-# note: PGDATA can be overridden by the -D startup option
-setenv PGDATA $HOME/data
-
-#You might want to set some locale stuff here
-#setenv LC_ALL sv_SE.ISO_8859-1
diff --git a/databases/postgresql-devel/files/dot.profile.in b/databases/postgresql-devel/files/dot.profile.in
deleted file mode 100644
index b4b638f64eb4..000000000000
--- a/databases/postgresql-devel/files/dot.profile.in
+++ /dev/null
@@ -1,11 +0,0 @@
-# both new and old layout's paths, but new path first...
-PATH=%%PREFIX%%/bin:${PATH}
-
-# note: PGDATA can be overridden by the -D startup option
-PGDATA=${HOME}/data
-
-export PATH PGDATA
-
-#You might want to set some locale stuff here
-#LC_ALL=sv_SE.ISO_8859-1
-#export PGDATESTYLE LC_ALL
diff --git a/databases/postgresql-devel/files/patch-contrib::pgcrypto::Makefile b/databases/postgresql-devel/files/patch-contrib::pgcrypto::Makefile
deleted file mode 100644
index 66112d5d50a9..000000000000
--- a/databases/postgresql-devel/files/patch-contrib::pgcrypto::Makefile
+++ /dev/null
@@ -1,20 +0,0 @@
---- contrib/pgcrypto/Makefile.orig Thu May 8 16:09:28 2003
-+++ contrib/pgcrypto/Makefile Thu May 8 16:12:47 2003
-@@ -7,7 +7,7 @@
- include $(top_builddir)/src/Makefile.global
-
- # either 'builtin', 'mhash', 'openssl'
--cryptolib = builtin
-+cryptolib = openssl
-
- # either 'builtin', 'system'
- cryptsrc = builtin
-@@ -21,7 +21,7 @@
- # This works ofcouse only with cryptolib = openssl
- #
- # 'silly' - use libc random() - very weak
--random = silly
-+random = dev
- random_dev = \"/dev/urandom\"
-
- ##########################
diff --git a/databases/postgresql-devel/files/pgsql.sh.tmpl b/databases/postgresql-devel/files/pgsql.sh.tmpl
deleted file mode 100644
index d67d9b642f1b..000000000000
--- a/databases/postgresql-devel/files/pgsql.sh.tmpl
+++ /dev/null
@@ -1,40 +0,0 @@
-#!/bin/sh
-
-# $FreeBSD$
-#
-# For postmaster startup options, edit $PGDATA/postgresql.conf
-
-PREFIX=%%PREFIX%%
-PGBIN=${PREFIX}/bin
-
-case $1 in
-start)
- [ -d ${PREFIX}/lib ] && /sbin/ldconfig -m ${PREFIX}/lib
- touch /var/log/pgsql
- chmod 600 /var/log/pgsql
- chown pgsql:pgsql /var/log/pgsql
- [ -x ${PGBIN}/pg_ctl ] && {
- su -l pgsql -c \
- '[ -d ${PGDATA} ] && exec %%PREFIX%%/bin/pg_ctl start -s -w -l /var/log/pgsql'
- echo -n ' pgsql'
- }
- ;;
-
-stop)
- [ -x ${PGBIN}/pg_ctl ] && {
- su -l pgsql -c 'exec %%PREFIX%%/bin/pg_ctl stop -s -m fast'
- echo -n ' pgsql'
- }
- ;;
-
-status)
- [ -x ${PGBIN}/pg_ctl ] && {
- exec su -l pgsql -c 'exec %%PREFIX%%/bin/pg_ctl status'
- }
- ;;
-
-*)
- echo "usage: `basename $0` {start|stop|status}" >&2
- exit 64
- ;;
-esac
diff --git a/databases/postgresql-devel/files/post-install-notes b/databases/postgresql-devel/files/post-install-notes
deleted file mode 100644
index 557614dd1842..000000000000
--- a/databases/postgresql-devel/files/post-install-notes
+++ /dev/null
@@ -1,45 +0,0 @@
-The PostgreSQL port has a collection of "side orders":
-
-postgresql-doc
- For all of the html documentation
-
-postgresql-tcltk
- If you want tcl/tk client support. You get a neat GUI, pgaccess, as
- a bonus!
-
-postgresql-odbc
- For client access from unix applications using ODBC as access
- method.
-
-ruby-postgres, py-PyGreSQL, p5-Pg, p5-DBD-Pg, postgresql-jdbc
- For client access to PostgreSQL databases using the languages: ruby,
- python, perl, perl DBI, and jdbc.
-
-postgresql-plperl, postgresql-pltcl & postgresql-plruby
- For using perl5, tcl, and ruby as procedural languages.
-
-Note that many files have moved around compared to previous versions
-of PostgreSQL. For example, plpgsql.so and all other language modules
-are now in /usr/local/lib/postgresql.
-
-If you have many tables and many clients running, consider raising
-kern.maxfiles using sysctl(8), or reconfigure your kernel
-appropriately.
-
-You should vacuum and backup your database regularly. There is a
-periodic script, /usr/local/share/postgresql/502.pgsql, that you may
-find useful.
-
-To allow many simultaneous connections to your PostgreSQL server, you
-should raise the SystemV shared memory limits in your kernel. Here are
-example values for allowing up to 180 clients (tinkering in
-postgresql.conf also needed, of course):
- options SYSVSHM
- options SYSVSEM
- options SYSVMSG
- options SHMMAXPGS=65536
- options SEMMNI=40
- options SEMMNS=240
- options SEMUME=40
- options SEMMNU=120
-