summaryrefslogtreecommitdiff
path: root/databases/postgresql92-server/files
diff options
context:
space:
mode:
authorPalle Girgensohn <girgen@FreeBSD.org>2008-11-07 09:49:49 +0000
committerPalle Girgensohn <girgen@FreeBSD.org>2008-11-07 09:49:49 +0000
commit978e3de48fd8491061803765cdc592ab234edd46 (patch)
tree2f23f5da1426d6e37dcb3efb378e85bd08787403 /databases/postgresql92-server/files
parent- Fix build by not using ncurses-config since there is no need, and we do not (diff)
Update PostgreSQL to latest versions.
http://www.postgresql.org/docs/current/static/release-8-3-5.html http://www.postgresql.org/docs/current/static/release-8-2-11.html http://www.postgresql.org/docs/current/static/release-8-1-15.html http://www.postgresql.org/docs/current/static/release-8-0-19.html http://www.postgresql.org/docs/current/static/release-7-4-23.html Note that the GiST problem mentioned does not apply to users of the FreeBSD port, since the previous version of PostgreSQL never reached the ports tree, due to the freeze of the tree pending the FreeBSD 7.1 update. PR: 121848, 124713
Notes
Notes: svn path=/head/; revision=222485
Diffstat (limited to 'databases/postgresql92-server/files')
-rw-r--r--databases/postgresql92-server/files/502.pgsql9
-rw-r--r--databases/postgresql92-server/files/pkg-message-server.in2
2 files changed, 4 insertions, 7 deletions
diff --git a/databases/postgresql92-server/files/502.pgsql b/databases/postgresql92-server/files/502.pgsql
index acc1afe431cf..d2235e414cd2 100644
--- a/databases/postgresql92-server/files/502.pgsql
+++ b/databases/postgresql92-server/files/502.pgsql
@@ -18,9 +18,6 @@
# daily_pgsql_backup_enable="YES" # do backup
# daily_pgsql_vacuum_enable="YES" # do vacuum
-daily_pgsql_vacuum_enable="YES"
-daily_pgsql_backup_enable="NO"
-
daily_pgsql_vacuum_args="-z"
daily_pgsql_pgdump_args="-b -F c"
# backupdir is relative to ~pgsql home directory unless it begins with a slash:
@@ -48,11 +45,11 @@ case "$daily_pgsql_backup_enable" in
# but this might not be where you want the backups...
if [ ! -d ${backupdir} ] ; then
echo Creating ${backupdir}
- mkdir ${backupdir}; chmod 700 ${backupdir}; chown pgsql ${backupdir}
+ mkdir -m 700 ${backupdir}; chown pgsql ${backupdir}
fi
echo
- echo "PostgreSQL maintenance"
+ echo "PostgreSQL backups"
# Protect the data
umask 077
@@ -83,7 +80,7 @@ case "$daily_pgsql_vacuum_enable" in
[Yy][Ee][Ss])
echo
- echo "vacuuming..."
+ echo "PostgreSQL vacuum"
su -l pgsql -c "vacuumdb -a -q ${daily_pgsql_vacuum_args}"
if [ $? -gt 0 ]
then
diff --git a/databases/postgresql92-server/files/pkg-message-server.in b/databases/postgresql92-server/files/pkg-message-server.in
index cd6c42ed2090..54f397448198 100644
--- a/databases/postgresql92-server/files/pkg-message-server.in
+++ b/databases/postgresql92-server/files/pkg-message-server.in
@@ -31,7 +31,7 @@ consider running the SQL script %%PREFIX%%/share/postgresql/odbc.sql
to get the functions required for ODBC compliance.
Please note that if you use the rc script,
-%%PREFIX%%/etc/rc.conf/postgresql, to initialize the database, unicode
+%%PREFIX%%/etc/rc.d/postgresql, to initialize the database, unicode
(UTF-8) will be used to store character data by default. Set
postgresql_initdb_flags or use login.conf settings described below to
alter this behaviour. See the start rc script for more info.