[GNUnet-SVN] r8086 - in GNUnet: . contrib doc src/applications

[gnunet]

Author: grothoff
Date: 2009-01-03 03:02:16 -0700 (Sat, 03 Jan 2009)
New Revision: 8086

Added:
   GNUnet/doc/README.postgres
Modified:
   GNUnet/contrib/config-daemon.scm
   GNUnet/doc/Makefile.am
   GNUnet/src/applications/Makefile.am
   GNUnet/todo
Log:
pgres

Modified: GNUnet/contrib/config-daemon.scm
===================================================================
--- GNUnet/contrib/config-daemon.scm    2009-01-03 09:39:34 UTC (rev 8085)
+++ GNUnet/contrib/config-daemon.scm    2009-01-03 10:02:16 UTC (rev 8086)
@@ -645,13 +645,13 @@
   "sqstore"
   (_ "Which database should be used?")
   (_ 
-"Which database should be used?  The options are \"sqstore_sqlite\" and 
\"sqstore_mysql\".  You must run gnunet-update after changing this value!
+"Which database should be used?  The options are \"sqstore_sqlite\", 
\"sqstore_postgres\" and \"sqstore_mysql\".  You must run gnunet-update after 
changing this value!
                        
-In order to use sqstore_mysql, you must configure the mysql database, which is 
relatively simple.  Read the file doc/README.mysql for how to setup mysql." )
+In order to use MySQL or Postgres, you must configure the respective database, 
which is relatively simple.  Read the file doc/README.mysql or 
doc/README.postgres for how to setup the respective database." )
   '()
   #t
   "sqstore_sqlite"
-  (list "SC" "sqstore_sqlite" "sqstore_mysql")
+  (list "SC" "sqstore_sqlite" "sqstore_postgres" "sqstore_mysql")
   'fs-loaded) )
 
 (define (modules-dstore builder)

Modified: GNUnet/doc/Makefile.am
===================================================================
--- GNUnet/doc/Makefile.am      2009-01-03 09:39:34 UTC (rev 8085)
+++ GNUnet/doc/Makefile.am      2009-01-03 10:02:16 UTC (rev 8086)
@@ -1,2 +1,2 @@
 SUBDIRS = . man
-EXTRA_DIST = README.mysql
+EXTRA_DIST = README.mysql README.postgres

Added: GNUnet/doc/README.postgres
===================================================================
--- GNUnet/doc/README.postgres                          (rev 0)
+++ GNUnet/doc/README.postgres  2009-01-03 10:02:16 UTC (rev 8086)
@@ -0,0 +1,49 @@
+How to setup the Postgres database for GNUnet.
+
+NOTE: This db module was developed for Postgres 8.3.  I have no
+idea what the minimum version that we require is exactly.
+
+HIGHLIGHTS
+
+Pros
+ + Easier to setup than MySQL
+ + Real database
+Cons 
+ - Quite slow
+ - Still some setup
+
+MANUAL SETUP INSTRUCTIONS
+
+ 1) in /etc/gnunetd.conf, set
+    sqstore = "sqstore_postgres"
+
+ 2) Then access postgres to create a user; I had to do this to get 
+    access and create a user:
+    # su - postgres
+    $ createuser
+    At this point, use the name of the user running gnunetd 
+    for the role, do not set it to superuser, allow the creation
+    of databases.
+
+ 3) As that user, create a database (or two):
+    $ createdb gnunet
+    $ createdb gnunetcheck # this way you can run "make check"
+
+ Thats it. 
+
+ 4) Still, perhaps you should briefly try if the DB connection 
+    works. First, login as the user who will run gnunetd. Then use,
+
+    $ psql gnunet # or gnunetcheck
+    gnunet=> \dt
+   
+    If, after you have started gnunetd at least once, you get a
+    gn080 table here, it probably works.
+ 
+PROBLEMS?
+
+If you have problems related to the postgres module, your best friend
+is probably the postgres manual. The first thing to check is that
+postgres is basically operational, that you can connect to it, create
+tables, issue queries etc. (see step 4 above for details).
+

Modified: GNUnet/src/applications/Makefile.am
===================================================================
--- GNUnet/src/applications/Makefile.am 2009-01-03 09:39:34 UTC (rev 8085)
+++ GNUnet/src/applications/Makefile.am 2009-01-03 10:02:16 UTC (rev 8086)
@@ -7,7 +7,7 @@
 endif
 
 if HAVE_POSTGRES
-# POSTGRES_DIR = sqstore_postgres
+ POSTGRES_DIR = sqstore_postgres
 endif
 
 if LINUX

Modified: GNUnet/todo
===================================================================
--- GNUnet/todo 2009-01-03 09:39:34 UTC (rev 8085)
+++ GNUnet/todo 2009-01-03 10:02:16 UTC (rev 8086)
@@ -12,7 +12,6 @@
 - Correctness: 
   * kv_sqlitetest has MAJOR valgrind failures!
   * kvstore_mysql is not implemented!
-  * sqstore_postgres is not implemented
   *  dstore_postgres is not implemented
   * kvstore_postgres is not implemented
   * new MySQL code sometimes causes gnunetd to "hang"