aboutsummaryrefslogtreecommitdiffstats
path: root/pgaas/src/stage/opt/app/pgaas/etc/create-repmgr-user
blob: 35ca401fe1946304262b7e76e810c6fafb10ae4b (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
#!/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. 


set -x

die()
{
    echo $0: "$@" 1>&2
    echo $0: "$@"
    umask 022
    echo $0: "$@" >> /tmp/pgaas-failures
    exit 1
}

[ -n "$PGDIR" ] || die "PGDIR is not set"

PATH=${INSTALL_ROOT}/opt/app/pgaas/bin:$PGDIR/bin:${INSTALL_ROOT}/opt/app/cdf/bin:$PATH
pswd=$( getpropvalue -x -n repmgr )

# note: The "pgaas" in "repmgr_pgaas" must match the cluster name used in repmgr.conf

psql <<-EOF
	CREATE ROLE repmgr SUPERUSER CREATEDB CREATEROLE INHERIT LOGIN;
	DROP DATABASE repmgr;
	CREATE DATABASE repmgr OWNER repmgr;
	ALTER USER repmgr PASSWORD '$pswd';
	ALTER USER repmgr SET search_path TO repmgr_pgaas, "\$user", public;
EOF