Changes between Version 4 and Version 5 of rasdamanStoragePostgreSQL


Ignore:
Timestamp:
Dec 30, 2015 6:32:27 AM (21 months ago)
Author:
pbaumann
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • rasdamanStoragePostgreSQL

    v4 v5  
    99
    1010(more to come)
     11
     12=== PostgreSQL ===
     13
     14To implement the geo semantics, petascope uses a relational database for the geo-related metadata. Currently, only PostgreSQL is supported; for the future, support of SQLite is planned (in parallel to the rasdaman array engine). This is how to set up PostgreSQL for use by petascope:
     15
     161. Prepare postgres:
     17{{{
     18#!sh
     19# if postgres has not been initialized yet:
     20sudo service postgresql initdb
     21
     22# you may need to allow trust-based access in PostgreSQL
     23# NOTE: On Debian 8 this file is in /etc/postgresql/9.4/main/pg_hba.conf
     24#       On CentOS 7 this file can be found in /var/lib/pgsql/data/pg_hba.conf
     25editor /etc/postgresql/9.4/main/pg_hba.conf
     26
     27# add the below to the `pg_hba.conf` PostgreSQL configuration file (before the ident lines):
     28
     29#------------------------------------------------------------
     30# "local" is for Unix domain socket connections only
     31local   all         all                               trust
     32# IPv4 local connections:
     33host    all         all         127.0.0.1/32          trust
     34# IPv6 local connections:
     35host    all         all         ::1/128               trust
     36#------------------------------------------------------------
     37
     38# reload PostgreSQL so that the new configuration will take effect
     39sudo service postgresql reload
     40}}}
    1141
    1242== Database location ==