Changes between Version 9 and Version 10 of RasdamanQuickInstallCentos7


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

--

Legend:

Unmodified
Added
Removed
Modified
  • RasdamanQuickInstallCentos7

    v9 v10  
    176176make check
    177177}}}
    178 
    179 
    180 = Alternative PostgreSQL database location =
    181 
    182 == Move the database (untested yet) ==
    183 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.
    184 
    185  1. Stop postgresql
    186 {{{
    187 #!sh
    188 service postgresql stop
    189 }}}
    190  2. Create new directory for the postgres database\
    191 {{{
    192 #!sh
    193 mkdir -p /data/pgdata
    194 chown postgres: /data/pgdata
    195 }}}
    196  3. Edit postgres configuration file and change the 'data_directory' to point to /data/pgdata
    197 {{{
    198 #!sh
    199 editor /etc/postgresql/8.4/main/postgresql.conf
    200 }}}
    201   3.1. Option 1: initialize new data dir
    202 {{{
    203 #!sh
    204 sudo -u postgres /usr/lib/postgresql/8.4/bin/initdb -D /data/pgdata
    205 }}}
    206   3.2. Option 2: move your old directory to the new place
    207 {{{
    208 #!sh
    209 mv /var/lib/postgresql/8.4/main/* /data/pgdata
    210 }}}
    211  4. Link to ssl certificates
    212 {{{
    213 #!sh
    214 ln -s /etc/ssl/certs/ssl-cert-snakeoil.pem /data/pgdata/server.crt
    215 ln -s /etc/ssl/private/ssl-cert-snakeoil.key /data/pgdata/server.key
    216 }}}
    217   4.1 Or alternatively set `ssl = false` in postgresql.conf
    218 
    219  5. Start postgresql
    220 {{{
    221 #!sh
    222 service postgresql start
    223 }}}
    224 
    225 == Use a tablespace ==
    226 Alternatively we can use a tablespace, and create RASBASE in that tablespace.
    227 
    228  1. Create new directory for the new tablespace:
    229 {{{
    230 #!sh
    231 mkdir -p /data/pgdata
    232 chown postgres: /data/pgdata
    233 }}}
    234  2. Create a `rasdaman` tablespace in postgres:
    235 {{{
    236 #!sh
    237 sudo -u postgres psql -d postgres
    238 CREATE TABLESPACE rasdaman LOCATION '/data/pgdata';
    239 }}}
    240  3. Patch the rasdaman create_db.sh script to use create the database in the new tablespace:
    241 {{{
    242 #!sh
    243 sed -i 's/createdb $DATABASE_NAME/createdb $DATABASE_NAME -D rasdaman/' $RMANHOME/bin/create_db.sh
    244 }}}