megdb/create.sh at master · MicroB3-IS/megdb · GitHub

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
41
42
43
44
45
46
47
48
49
50
51
52
53
# steps to creation
# 1. initdb -D [myclusterdir]
# 2. postgres -D [myclusterdir]
# 4. create.sh

VERSIONING=/opt/versioning
POSTGIS=/opt/postgres/9.1.1/pgsql/share/contrib/postgis-1.5
PORT=5432
DATABASE=megdb
DUMPFILE=megdb.dump

echo Creating developer database ${DATABASE}

psql -p ${PORT} -U postgres -c "DROP DATABASE ${DATABASE};"
createdb -p ${PORT} -U postgres -E UTF8 ${DATABASE}

echo Setting up baseline DDL

psql -p ${PORT} -f baseline/add-versioning.sql ${DATABASE}
psql -p ${PORT} -f ${POSTGIS}/postgis.sql ${DATABASE}
psql -p ${PORT} -f ${POSTGIS}/spatial_ref_sys.sql ${DATABASE}
psql -p ${PORT} -f ${POSTGIS}/postgis_comments.sql ${DATABASE}
psql -p ${PORT} -f baseline/hstore.sql ${DATABASE}
psql -p ${PORT} -f baseline/roles.sql ${DATABASE}
psql -p ${PORT} -f baseline/baseline.sql ${DATABASE}

echo Applying patches now...

psql -p ${PORT} -f patches/1-partitioning.sql ${DATABASE}
psql -p ${PORT} -f patches/5-view-fix.sql ${DATABASE}
psql -p ${PORT} -f patches/6-drop-sequence-storage-legacy.sql ${DATABASE}

echo Loading test data

psql -p ${PORT} -f before_pg_restore_test_data.sql ${DATABASE}

echo Now restoring data

pg_restore -a -v -e -p ${PORT} -n cv -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n pfam_23 -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n pfam_24 -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n core -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n partitions -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n elayers -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n web_r8 -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n silva_r102_ssu -d ${DATABASE} ${DUMPFILE}
pg_restore -a -v -e -p ${PORT} -n silva_r102_lsu -d ${DATABASE} ${DUMPFILE}


echo recreating trigger
psql -p ${PORT} -f after_pg_restore_test_data.sql ${DATABASE}

echo Done