I'm a bit confused with your patch and comments.
The bit that reads:
--
+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:
--
Do you really mean a user account of 'postgres'? I
thought this user was changed to '_postgresql' in out
OpenBSD port.
By "dba account" do you mean a system user account or
a PostgreSQL database account?
And exactly which step is going to prompt for "a password"?
--- 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
