From b8b6f075b0edb77b2014bf84130a69903ad5519e Mon Sep 17 00:00:00 2001 From: Andreas Baumann Date: Thu, 12 Apr 2012 20:47:24 +0200 Subject: added some rudimentary install docu, renamed test.sql to create.sql and schema.sql --- INSTALL | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) (limited to 'INSTALL') 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! + -- cgit v1.2.3-54-g00ecf