Commits

Dane Springmeyer committed b8fb807

fix up mistakes around postgres auth, stick with tutorial using the unix user to connect to postgres as a super user

Comments (0)

Files changed (3)

 
 * Create a PostGIS enabled database from `template_postgis` as the postgres user::
 
-    createdb barcelona -T template_postgis -U postgres
+    createdb barcelona -T template_postgis
 
 
   .. note::
 
   * Then in the connections window type:
 
-    * Name: OSM
+    * Name: OSM (or anything you like here)
 
     * Host: leave blank
+    
+      * (normally you would type "localhost" but that requires allowing "trust" connections, see :ref:`trouble-postgres-connection`)
 
     * Database: barcelona
 
     * Port: 5432
 
-    * Username: postgres
+    * Username: osm
 
-    * Password: osm (only needed on windows!)
+    * Password: leave blank (on windows type "osm")
 
-  * Click **Test connect**
+  * Click **Test connect**. And problems see: :ref:`trouble-postgres-connection`
 
   * You should should get a message that the connection was successful
 

speakers_notes.rst

 
   # this did nothing - actually grew... ugh
   sudo apt-get remove aisleriot openoffice.org* empathy rythmbox transmission-gtk rhythmbox sudoku simple-scan quadrapassel pitivi gnome-orca gnome-media gnomine gnome-mahjongg gbrainy f-spot evolution gwibber
+  
+
+FAQ:
+----
+
+Running your own OSM server
+
+ * absolute minimum would be dual core with 4GB of RAM, but likely the weekly import taking around 24 hours which may be too long
+
+ * having multiple disks and/or more RAM may be more useful than lots of CPUs
+ 
+ * single country: in that case DB probably all fits in RAM which makes the rendering CPU-bound

troubleshooting.rst

 
 You may recieve an error like::
 
+  $ createdb -T template_postgis osm # connecting as "osm" user by supplying no -U argument
+  could not connect to database postgres: FATAL:  Ident authentication failed for user "osm"
+
+or if trying to connect as the postgres user:
+
   $ createdb -T template_postgis osm -U postgres
   could not connect to database postgres: FATAL:  Ident authentication failed for user "postgres"
 
-If you get this it means you need to either enable "trust" connections for postgres (editing pg_hba.conf), or alternatively allow your user to connect to a postgres database. The latter approach is easier for a demo machine.
 
-Here is the trick::
+If you get this it means you need to either allow your unix user to connect to a postgres database, or 
+enable "trust" connections for postgres (editing pg_hba.conf), or alternatively allow your user to connect to a postgres database. 
+
+The first approach is easier for a demo machine, the latter more secure.
+
+Here is the trick for the easy, insecure method::
 
   sudo su - postgres
   createuser osm # or your username
-    Enter name of role to add: osm
-    Shall the new role be a superuser? (y/n) y
+  # prompt: "Shall the new role be a superuser? (y/n)"
+  y
 
-To enable "trust" connections, that will allow you to connect as the postgres user without a password do::
+Or "trust" connections, that will allow you to connect as the postgres user without a password::
 
   sudo vim /etc/postgresql/8.4/main/pg_hba.conf
   ## Change
 
 .. _trouble-postgres-win:
 
+
 Troubleshooting PostgreSQL startup on Windows
 ---------------------------------------------