diff options
author | Sean Chittenden <seanc@FreeBSD.org> | 2005-11-17 00:04:58 +0000 |
---|---|---|
committer | Sean Chittenden <seanc@FreeBSD.org> | 2005-11-17 00:04:58 +0000 |
commit | 0ea3f56ce4e3e64541f3c3baf787bc1d7011d9ef (patch) | |
tree | 8566241aeb1b751c728fea6eebcb0a6a1fd2cb5a /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.pgsql | 81 | ||||
-rw-r--r-- | databases/postgresql-devel/files/dot.cshrc.in | 7 | ||||
-rw-r--r-- | databases/postgresql-devel/files/dot.profile.in | 11 | ||||
-rw-r--r-- | databases/postgresql-devel/files/patch-contrib::pgcrypto::Makefile | 20 | ||||
-rw-r--r-- | databases/postgresql-devel/files/pgsql.sh.tmpl | 40 | ||||
-rw-r--r-- | databases/postgresql-devel/files/post-install-notes | 45 |
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 - |