blob: e06c810f7f22d1eda10bdbae257a7e8bfa1fd5e6 (
plain)
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
|
#!/bin/bash
# Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
#
# Licensed under the Apache License, Version 2.0 (the "License");
# you may not use this code except in compliance
# with the License. You may obtain a copy of the License
# at http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing, software
# distributed under the License is distributed on an "AS IS" BASIS,
# WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
# implied. See the License for the specific language governing
# permissions and limitations under the License.
# update a secondary database
set -x
die()
{
echo $0: "$@" 1>&2
echo $0: "$@"
umask 022
echo $0: "$@" >> /tmp/pgaas-failures
exit 1
}
[ -n "$MASTER" ] || die "MASTER is not set"
[ -n "$PGDIR" ] || die "PGDIR is not set"
[ -n "$DBROOT" ] || die "DBROOT is not set"
[ -n "$CFGDIR" ] || die "CFGDIR is not set"
cd $CFGDIR/main || die "Cannot cd $CFGDIR/main"
PATH=${INSTALL_ROOT}/opt/app/pgaas/bin:$CFGDIR/etc:$PGDIR/bin:$PATH
umask 077
TMP=$(mktemp /tmp/tmp.uds1.XXXXXXXXXX)
trap 'rm -f $TMP' 0 1 2 3 15
# update postgresql.conf - got new ones
# update pg_hba.conf - got new ones
# set up repmgr.conf - in common
# replace/update recovery.conf
if [ -f $DBROOT/recovery.conf ];then mv $DBROOT/recovery.conf $DBROOT/recovery.conf.upgraded;fi
$CFGDIR/etc/gen-recovery.conf
# wait until master DB is active and has repmgr available
max=40
for s in `seq $max`
do
echo "$s of $max: Asking master $MASTER if repmgr is ready"
pgwget --progress=dot:giga -O$TMP http://$MASTER:8000/hasrepmgr
if [ -s $TMP ]
then
msg=$(cat $TMP)
case $msg in
OK* )
echo "Master has repmgr ready"
done=yes
break
;;
* )
echo "Master does not have repmgr ready, msg=$msg"
;;
esac
fi
rm -f $TMP
sleep 15
done
[ "$done" = "yes" ] || die "Master never had repmgr available"
$CFGDIR/etc/start-db
sleep 10
# make sure the postgres password is right
$CFGDIR/etc/update-postgres-user
# register as standby
repmgr -f $CFGDIR/main/repmgr.conf standby register
echo repmgr ret=$?
sleep 10
# start repmgrd
# start repmgrd (verbose logging for testing)
umask 07
repmgrd -f $CFGDIR/main/repmgr.conf -d --verbose
echo repmgrd ret=$?
# start repmgrd (normal logging)
# repmgrd -f $CFGDIR/main/repmgr.conf -d
chmod 600 recovery.conf
|