Author: poeml Date: Thu Jan 2 01:52:40 2014 New Revision: 8307 URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain?rev=8307&view=rev Log: docs/install: clarify some things on postgresql config. Modified: trunk/docs/installation/source.rst Modified: trunk/docs/installation/source.rst URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain/trunk/docs/installation/source.rst?rev=8307&r1=8306&r2=8307&view=diff ============================================================================== --- trunk/docs/installation/source.rst (original) +++ trunk/docs/installation/source.rst Thu Jan 2 01:52:40 2014 _at_@ -126,19 +126,10 @@ Install the PostgreSQL server, start it and create a user and a database:: - root_at_powerpc:~ # su - postgres + su - postgres postgres_at_powerpc:~> createuser -P mirrorbrain - Enter password for new role: - Enter it again: - Shall the new role be a superuser? (y/n) n - Shall the new role be allowed to create databases? (y/n) n - Shall the new role be allowed to create more new roles? (y/n) n - CREATE ROLE - postgres_at_powerpc:~> createdb -O mirrorbrain mirrorbrain - CREATE DATABASE postgres_at_powerpc:~> createlang plpgsql mirrorbrain - postgres_at_powerpc:~> Maybe it is a good idea to check PostgreSQL's access policy configuration at _at_@ -151,7 +142,6 @@ # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only - #local all all ident local all all password # IPv4 local connections: host all all 127.0.0.1/32 password _at_@ -160,6 +150,11 @@ # remote connections: host mirrorbrain mirrorbrain 10.10.2.3/32 md5 + +.. note:: I recommend to use "password" or "md5" authentication in all lines. + Remove "ident"; it is not so handy, at least not if you aren't always + the same user. "password" is transmitting in clear text, so use + "md5" for all remote connections. If you plan to use `mod_asn`_ for lookup of AS (autonomous system) data, now's the moment to install the ``ip4r`` data type into PostgreSQL. See the `mod_asn _______________________________________________ mirrorbrain-commits mailing list Archive: http://mirrorbrain.org/archive/mirrorbrain-commits/ Note: To remove yourself from this list, send a mail with the content unsubscribe to the address mirrorbrain-commits-request_at_mirrorbrain.orgReceived on Thu Jan 02 2014 - 00:52:42 GMT
This archive was generated by hypermail 2.3.0 : Thu Jan 02 2014 - 01:17:08 GMT