OpenPKG CVS Repository
http://cvs.openpkg.org/
____________________________________________________________________________
Server: cvs.openpkg.org Name: Ralf S. Engelschall
Root: /v/openpkg/cvs Email: [EMAIL PROTECTED]
Module: openpkg-src Date: 03-Mar-2006 19:45:23
Branch: HEAD Handle: 2006030318452300
Modified files:
openpkg-src/postgresql postgresql.spec
Log:
use the new role system instead of the backward compability layer; fix
the database creation by referencing the corresponding tablespace
Summary:
Revision Changes Path
1.194 +5 -4 openpkg-src/postgresql/postgresql.spec
____________________________________________________________________________
patch -p0 <<'@@ .'
Index: openpkg-src/postgresql/postgresql.spec
============================================================================
$ cvs diff -u -r1.193 -r1.194 postgresql.spec
--- openpkg-src/postgresql/postgresql.spec 2 Mar 2006 17:17:01 -0000
1.193
+++ openpkg-src/postgresql/postgresql.spec 3 Mar 2006 18:45:23 -0000
1.194
@@ -43,7 +43,7 @@
Group: Database
License: GPL
Version: %{V_postgresql}
-Release: 20060302
+Release: 20060303
# package options
%option with_server yes
@@ -659,12 +659,13 @@
echo " \$ chmod 700 /u/<user>/rdbms"
echo " \$ chown %{l_rusr}:%{l_rgrp} /u/<user>/rdbms"
echo " \$ $RPM_INSTALL_PREFIX/bin/psql -U $l_pguser -d
template1"
- echo " template1=> CREATE USER <user>"
+ echo " template1=> CREATE ROLE <user> LOGIN"
echo " ENCRYPTED PASSWORD '<password>'"
- echo " NOCREATEDB NOCREATEUSER;"
+ echo " NOCREATEDB NOCREATEROLE;"
echo " template1=> CREATE TABLESPACE <user> OWNER <user>"
echo " LOCATION '/u/<user>/rdbms';"
- echo " template1=> CREATE DATABASE <user>"
+ echo " template1=> CREATE DATABASE <user> OWNER <user>"
+ echo " TABLESPACE <user>;"
echo " \$ echo 'localhost:*:<user>:<user>:<password>'
>>/u/<user>/.pgpass"
echo " \$ chmod 600 <user> /u/<user>/.pgpass; chown <user>
/u/<user>/.pgpass"
echo "After this the user <user> will be able to connect to his
RDBMS with:"
@@ .
______________________________________________________________________
The OpenPKG Project www.openpkg.org
CVS Repository Commit List openpkg-cvs@openpkg.org
