summaryrefslogtreecommitdiff
path: root/INSTALL
blob: 747ba91711535f5be1027bc043ce301761927d2a (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
Prerequisites
-------------

required:

* libpq from Postgresql and header files

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" <mount point>
    
    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!