Imported from the SVN repository

http://svn.wolffelaar.nl/wsvn/phpbb/branches/jessie/

Signed-off-by: Olivier Gayot <duskcoder@gmail.com>

1 files changed, 57 insertions, 0 deletions

diff --git a/debian/README.postgresql b/debian/README.postgresql
new file mode 100644
index 0000000..66fb388
--- /dev/null
+++ b/debian/README.postgresql
@@ -0,0 +1,57 @@
+How to setup the postgresql database
+====================================
+
+As far as postgresql is concerned, dbconfig-common is still limited,
+meaning authentication to the postgresql server has to be setup
+manually.
+
+We show a typical postgresql default config
+(/etc/postgresql/x.y/zz/pg_hba.conf), where the line that is to be
+added and allows access to phpbb as it is configured by this package
+is prepended with a plus (+) sign. (The plus sign is NOT to be copied
+to the config!)
+
+ # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD
+ local   all         postgres                          ident sameuser
++local   phpbb3      phpbb3                            md5
+ local   all         all                               ident sameuser
+ host    all         all         127.0.0.1/32          md5
+ host    all         all         ::1/128               md5
+
+Note that the entry has to be made at the shown location and not
+simply at the end of the file.
+
+Reload postgresql for the changes to take effect. The password that
+you entered during installation will be used by phpbb to authenticate
+to the database; you don't need to put it anywhere else.
+
+To give more users access to more databases just add other lines like
+the above to the configuration.
+
+You can use the same user and the same database for different forums
+by specifying a different table_prefix for each installation in the
+phpBB config. Note that all users can however access all databases then.
+
+Further examples when adding more forums:
+
+# same user, different database:
+# let's hope they don't guess the name of the other databases
+local   phpbb3-2      phpbb3                            md5
+
+# different user, same database:
+# only makes sense when you set table-specific privileges
+local   phpbb3      phpbb3-2                            md5
+
+# different user, different database:
+# the way things should be
+local   phpbb3-2      phpbb3-2                          md5
+
+Again: do not simply add any of these to the bottom of the config
+file, but at the location that was shown in the first example,
+i.e. before the authentication for "all" is defined for the connection
+method that you choose to employ (local=Unix-domain socket,
+host=TCP/IP).
+
+For further details about client authentication to PostgreSQL, please
+consult the excellent documentation at 
+http://www.postgresql.org/docs/7.4/static/client-authentication.html.