-
Notifications
You must be signed in to change notification settings - Fork 0
/
INSTALL
41 lines (24 loc) · 906 Bytes
/
INSTALL
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
40
Prerequisites
-------------
required:
* libpq from Postgresql and header files
* libfuse FUSE library and header files
Compilation
-----------
make
make install [DESTDIR=x] [prefix=x]
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!