I am changing slightly the way we install a PostgreSQL server. To
recall, up to now installing the postgresql-server package created a
default database for you. But this database was not secured.
This has led to problems in some installations where the users were not
aware of this.
So no database is created during package install, instead instructions
are given on how to create a properly secured database.
ok?
Index: databases/postgresql/Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.91
diff -u -r1.91 Makefile
--- databases/postgresql/Makefile 15 Oct 2006 16:00:11 -0000 1.91
+++ databases/postgresql/Makefile 18 Oct 2006 11:12:19 -0000
@@ -7,7 +7,7 @@
VERSION= 8.1.5
DISTNAME= postgresql-${VERSION}
FULLPKGNAME= postgresql-client-${VERSION}
-PKGNAME-server= postgresql-server-${VERSION}
+PKGNAME-server= postgresql-server-${VERSION}p0
PKGNAME-docs= postgresql-docs-${VERSION}
CATEGORIES= databases
Index: databases/postgresql/files/README.OpenBSD
===================================================================
RCS file: /cvs/ports/databases/postgresql/files/README.OpenBSD,v
retrieving revision 1.14
diff -u -r1.14 README.OpenBSD
--- databases/postgresql/files/README.OpenBSD 15 Oct 2006 16:00:11 -0000
1.14
+++ databases/postgresql/files/README.OpenBSD 18 Oct 2006 11:12:19 -0000
@@ -1,56 +1,40 @@
-Requirements
-------------
-
-Please note that the OpenBSD port of the PostgreSQL server requires a
-kernel compiled with SYSVSEM and SYSVSHM options for proper operation.
-The GENERIC kernel has these settings.
-
Using PostgreSQL in an OpenBSD environment
-------------------------------------------
-If you are installing PostgreSQL for the first time, a default database
-will have been created for you. If this failed for any reason or if you
-want to use non-default paramaters, you can do something similar to the
-following steps manually:
+If you are installing PostgreSQL for the first time, you have to create
+a default database first. In the following example we install a database
+in /var/postgresql/data with a dba account 'postgres' and md5 authentication.
+We will be prompted for a password to protect the dba account:
# su - _postgresql
$ mkdir /var/postgresql/data
- $ initdb -D /var/postgresql/data
-
-If you are upgrading PostgreSQL then you may have a `pgsql' or `postgresql'
-user. It is suggested that you follow the steps in
+ $ initdb -D /var/postgresql/data -U postgres -A md5 -W
- !!PREFIX!!/share/doc/postgresql/INSTALL
-
-for more information on how to upgrade your existing databases. See
-also `Special notes for the OpenBSD port' below. Replace references to
-the `postgresql' user below with `pgsql' or whatever other user you
-have selected to be the database administration account.
+Please consult the PostgreSQL website for more information, especially when
+you are upgrading an existing database installation.
Auto Start and Stop
--------------------
-If you wish to start PostgreSQL automatically during system startup,
-add the following lines to /etc/rc.local:
+To start PostgreSQL at boot and shut it down when the system shuts down,
+add the following lines to /etc/rc.local and /etc/rc.shutdown, respectively:
+
+/etc/rc.local:
if [ -x !!PREFIX!!/bin/pg_ctl ]; then
su -l _postgresql -c "nohup !!PREFIX!!/bin/pg_ctl start \
- -D /var/postgresql/data -l /var/postgresql/logfile \
- -o '-D /var/postgresql/data'"
+ -D /var/postgresql/data -l /var/postgresql/logfile \
+ -o '-D /var/postgresql/data'"
echo -n ' postgresql'
fi
-To automatically shutdown the database as part of the system shutdown,
-add the following lines to /etc/rc.shutdown:
+/etc/rc.shutdown:
if [ -f /var/postgresql/data/postmaster.pid ]; then
su -l _postgresql -c "!!PREFIX!!/bin/pg_ctl stop -m fast \
- -D /var/postgresql/data"
+ -D /var/postgresql/data"
rm -f /var/postgresql/data/postmaster.pid
fi
Network Connections and Tuning
-------------------------------
To allow connections over TCP (and other options) edit the file:
Index: databases/postgresql/pkg/MESSAGE-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/MESSAGE-server,v
retrieving revision 1.3
diff -u -r1.3 MESSAGE-server
--- databases/postgresql/pkg/MESSAGE-server 5 Feb 2006 09:23:22 -0000
1.3
+++ databases/postgresql/pkg/MESSAGE-server 18 Oct 2006 11:12:19 -0000
@@ -1,2 +1,7 @@
-For more information on using PostgreSQL in an OpenBSD environment,
-please see ${PREFIX}/share/doc/postgresql/README.OpenBSD.
+* Important note for users familar with former versions of this package:
+ The postgresql-server package does no longer install a default database.
+
+To use the postgresql server you have to create a database first.
+
+You find detailled instructions on how to install a database in the file
+${PREFIX}/share/doc/postgresql/README.OpenBSD.
Index: databases/postgresql/pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
retrieving revision 1.10
diff -u -r1.10 PLIST-server
--- databases/postgresql/pkg/PLIST-server 9 Oct 2006 11:55:18 -0000
1.10
+++ databases/postgresql/pkg/PLIST-server 18 Oct 2006 11:12:19 -0000
@@ -403,4 +403,3 @@
@owner _postgresql
@group _postgresql
@sample /var/postgresql/
[EMAIL PROTECTED] su _postgresql -c "%D/bin/initdb -D /var/postgresql/data"
