1
|
#!/bin/sh
|
2
|
|
3
|
#This script is used to move the data of a postgresql 8.4 instance to the
|
4
|
#new installed postgresql 9.3 instance after the os was upgraded from ubuntu 10.04 to 14.04.
|
5
|
#Basically it will decompress a metacat backup file which contains a dumped-all file and
|
6
|
#resotre it in a postgresql 9.3 instance.
|
7
|
#You need to pass the metacat backup file to this script. We assume the backup file
|
8
|
#locating at /var/metacat/metacat-backup directory.
|
9
|
#This script should be run as the root user.
|
10
|
#Usage: nohup ./restore-dumped-data-to-pg9.3.sh metacat_backup_file_name &
|
11
|
|
12
|
#Check the argument of the script. It only can have one - the metacat backup file name.
|
13
|
|
14
|
METACAT_BACKUP_DIR=/var/metacat/metacat-backup
|
15
|
SQL_FILE=metacat-postgres-backup.sql
|
16
|
METACAT_BACKUP_FILE_SUFFIX=.tgz
|
17
|
DB_BASE=/var/lib/postgresql
|
18
|
OLD_DB_VERSION=8.4
|
19
|
ANOTHER_OLD_DB_VERSION=9.1
|
20
|
NEW_DB_VERSION=9.3
|
21
|
NEW_DB_CONFIG=/etc/postgresql/$NEW_DB_VERSION/main/postgresql.conf
|
22
|
OLD_DB_DATA_DIR=$DB_BASE/$OLD_DB_VERSION
|
23
|
OLD_DB_BACKUP_FILE=postgresql-$OLD_DB_VERSION.tar.gz
|
24
|
POSTGRES_USER=postgres
|
25
|
PORT=5432
|
26
|
echo "start to move database from $OLD_DB_VERSION to $NEW_DB_VERSION at"
|
27
|
echo `date`
|
28
|
|
29
|
echo "the length of argument is $#"
|
30
|
#echo $@
|
31
|
if [ $# -ne 1 ]; then
|
32
|
echo "This script should take one and only one parameter as the metacat backup file name.";
|
33
|
exit 1;
|
34
|
fi
|
35
|
METACAT_BACKUP_FILE_NAME=$1
|
36
|
echo "the backup file name is $METACAT_BACKUP_FILE_NAME"
|
37
|
|
38
|
if [ -f $METACAT_BACKUP_DIR/$METACAT_BACKUP_FILE_NAME ]; then
|
39
|
echo "the metacat backup file $METACAT_BACKUP_DIR/$METACAT_BACKUP_FILE_NAME exists.";
|
40
|
else
|
41
|
echo "the metacat backup file $METACAT_BACKUP_DIR/$METACAT_BACKUP_FILE_NAME doesn't exist, please double check the name.";
|
42
|
exit 1;
|
43
|
fi
|
44
|
|
45
|
DECOMPRESS_DIR_NAME=${METACAT_BACKUP_FILE_NAME%%.*}
|
46
|
echo "the decmporessed dir is $DECOMPRESS_DIR_NAME"
|
47
|
|
48
|
if [ -f "$DB_BASE/$OLD_DB_BACKUP_FILE" ]; then
|
49
|
echo "$DB_BASE/$OLD_DB_BACKUP_FILE does exist and we don't need to backup it again"
|
50
|
else
|
51
|
echo "back up the old db data at $OLD_DB_DATA_DIR"
|
52
|
su - $POSTGRES_USER -c "tar -zcvf $DB_BASE/$OLD_DB_BACKUP_FILE $OLD_DB_DATA_DIR"
|
53
|
echo "delete the data directory - $OLD_DB_DATA_DIR"
|
54
|
rm -rf $OLD_DB_DATA_DIR
|
55
|
fi
|
56
|
|
57
|
echo "stop postgresql"
|
58
|
/etc/init.d/postgresql stop
|
59
|
|
60
|
echo "remove postgresql 8.4 and 9.1"
|
61
|
apt-get remove postgresql-$OLD_DB_VERSION
|
62
|
apt-get remove postgresql-$ANOTHER_OLD_DB_VERSION
|
63
|
|
64
|
echo "modify the port to 5432 in the new db configuration file"
|
65
|
sed -i.bak --regexp-extended "s/(port =).*/\1${PORT}/;" $NEW_DB_CONFIG
|
66
|
|
67
|
if [ -d "$METACAT_BACKUP_DIR/$DECOMPRESS_DIR_NAME" ]; then
|
68
|
echo "$METACAT_BACKUP_DIR/$DECOMPRESS_DIR_NAME does exist and we don't need to decompress the metacat backup file again"
|
69
|
else
|
70
|
echo "decompress the metacat backup file"
|
71
|
tar zxvf $METACAT_BACKUP_DIR/$METACAT_BACKUP_FILE_NAME -C $METACAT_BACKUP_DIR
|
72
|
fi
|
73
|
|
74
|
echo "restart postgresql"
|
75
|
/etc/init.d/postgresql start
|
76
|
|
77
|
echo "change the groupship of $METACAT_BACKUP_DIR"
|
78
|
chown -R :$POSTGRES_USER $METACAT_BACKUP_DIR
|
79
|
|
80
|
echo "restore database"
|
81
|
su - $POSTGRES_USER -c "psql -f $METACAT_BACKUP_DIR/$DECOMPRESS_DIR_NAME/$SQL_FILE postgres"
|
82
|
|
83
|
echo "end to move database from $OLD_DB_VERSION to $NEW_DB_VERSION at"
|
84
|
echo `date`
|
85
|
|
86
|
echo "start to vacuum the db at"
|
87
|
echo `date` >> /tmp/vacuumdb.out
|
88
|
su - postgres -c "/usr/lib/postgresql/$NEW_DB_VERSION/bin/vacuumdb --all"
|
89
|
echo "end to vacuum the db at "
|
90
|
echo `date`
|
91
|
exit 0
|