Changes between Version 33 and Version 34 of RasdamanQuickInstallDebian7


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

--

Legend:

Unmodified
Added
Removed
Modified
  • RasdamanQuickInstallDebian7

    v33 v34  
    150150 * petascope (installation guide [wiki:Install#Installingpetascope here])
    151151 * rasgeo (installation guide [wiki:Install#rasgeo here])
    152 
    153 
    154 = Alternative PostgreSQL database location =
    155 
    156 == Move the database (untested yet) ==
    157 By default postgresql keeps the database in /var/lib/postgresql/8.4/main/, to move it to another place (let's say `/data/pgdata`) follow the steps below.
    158 
    159  1. Stop postgresql
    160 {{{
    161 #!sh
    162 service postgresql stop
    163 }}}
    164  2. Create new directory for the postgres database\
    165 {{{
    166 #!sh
    167 mkdir -p /data/pgdata
    168 chown postgres: /data/pgdata
    169 }}}
    170  3. Edit postgres configuration file and change the 'data_directory' to point to /data/pgdata
    171 {{{
    172 #!sh
    173 editor /etc/postgresql/8.4/main/postgresql.conf
    174 }}}
    175   3.1. Option 1: initialize new data dir
    176 {{{
    177 #!sh
    178 sudo -u postgres /usr/lib/postgresql/8.4/bin/initdb -D /data/pgdata
    179 }}}
    180   3.2. Option 2: move your old directory to the new place
    181 {{{
    182 #!sh
    183 mv /var/lib/postgresql/8.4/main/* /data/pgdata
    184 }}}
    185  4. Link to ssl certificates
    186 {{{
    187 #!sh
    188 ln -s /etc/ssl/certs/ssl-cert-snakeoil.pem /data/pgdata/server.crt
    189 ln -s /etc/ssl/private/ssl-cert-snakeoil.key /data/pgdata/server.key
    190 }}}
    191   4.1 Or alternatively set `ssl = false` in postgresql.conf
    192 
    193  5. Start postgresql
    194 {{{
    195 #!sh
    196 service postgresql start
    197 }}}
    198 
    199 == Use a tablespace ==
    200 Alternatively we can use a tablespace, and create RASBASE in that tablespace.
    201 
    202  1. Create new directory for the new tablespace:
    203 {{{
    204 #!sh
    205 mkdir -p /data/pgdata
    206 chown postgres: /data/pgdata
    207 }}}
    208  2. Create a `rasdaman` tablespace in postgres:
    209 {{{
    210 #!sh
    211 sudo -u postgres psql -d postgres
    212 CREATE TABLESPACE rasdaman LOCATION '/data/pgdata';
    213 }}}
    214  3. Patch the rasdaman create_db.sh script to use create the database in the new tablespace:
    215 {{{
    216 #!sh
    217 sed -i 's/createdb $DATABASE_NAME/createdb $DATABASE_NAME -D rasdaman/' $RMANHOME/bin/create_db.sh
    218 }}}