summaryrefslogtreecommitdiff
path: root/doc/README.postgres
diff options
context:
space:
mode:
authorChristian Grothoff <christian@grothoff.org>2010-08-25 19:10:18 +0000
committerChristian Grothoff <christian@grothoff.org>2010-08-25 19:10:18 +0000
commit9aa22137e2427e1f44c7fca2f30005ba8b22195d (patch)
tree29ce98471d30a686c101ffff10b3461f7044491c /doc/README.postgres
parent073be523fd1121b2bb4cd2f77f3098b0c98c1738 (diff)
postgres hackery
Diffstat (limited to 'doc/README.postgres')
-rw-r--r--doc/README.postgres49
1 files changed, 49 insertions, 0 deletions
diff --git a/doc/README.postgres b/doc/README.postgres
new file mode 100644
index 000000000..0213c72fb
--- /dev/null
+++ b/doc/README.postgres
@@ -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/gnunet.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 gnunet
+ 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
+ gn090 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).
+