> 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.
Sounds good to me. > 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"