Looks good. A couple of trivial suggestions...
1. The phrase "dba account" in the following lines is
ambiguous, since a DBA account can either be
"_postgresql" on the system or "postgres" on the
database, or at least those are the defaults. It will
leave less people scratching their heads if you just
called it a database superuser account.
+in /var/postgresql/data with a dba account 'postgres'
and md5
authentication.
+We will be prompted for a password to protect the dba
account:
2. Typo here
+You find [detailled] instructions on how to install a
database in the
file
-em
--- Marc Balmer <[EMAIL PROTECTED]> wrote:
> 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"
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
