added some rudimentary install docu, renamed test.sql to create.sql and schema.sql

1 files changed, 28 insertions, 0 deletions

diff --git a/INSTALL b/INSTALL
index 0f3cc4b..675b7a5 100644
--- a/INSTALL
+++ b/INSTALL
@@ -9,3 +9,31 @@ Compilation
 -----------
 
 make
+
+Installation
+------------
+
+* Create a postgresql user and database (as user postgres)
+
+    createuser -S -R -D -P someuser (enter some password)
+    createdb -O someuser somedb
+    
+    make sure access permissions are right in pg_hba.conf.
+
+* Initialize the database schema (as user using fuse)
+
+    psql -U someuser somedb < schema.sql
+    
+* Mount the FUSE filesystem
+
+    pgfuse "user=someuser dbname=somedb"
+    
+    If you use a password, store the password in ~/.pgpass:
+    
+    dbhost:5432:somedb:someuser:somepass
+    
+    (or in any file specified in the PASSFILE environment variable)
+    
+    Though you can specify password directly in the PostgreSQL
+    connection string, this is not safe!
+