aboutsummaryrefslogtreecommitdiffstats
path: root/postgresql-config/src/stage/opt/app/postgresql-config/etc/create-db-backup
blob: 625ce576bddc8a81bb5d6ff36198cbfda8b659f3 (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
#!/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. 


if [ -d /opt/app/postgresql-9.5.2 ]
then PGDIR=/opt/app/postgresql-9.5.2
else PGDIR=/usr/lib/postgresql/9.5
fi

$PGDIR/bin/psql <<-EOF
	SELECT pg_start_backup('backup');
EOF

cd /dbroot/pgdata &&
{
    find main | grep -v main/pg_xlog/
    find main/pg_xlog -type d
} | cpio -oc | gzip > main.cpio.gz.$$ && mv main.cpio.gz.$$ main.cpio.gz

$PGDIR/bin/psql <<-EOF
	SELECT pg_stop_backup();
EOF
echo /dbroot/pgdata/main.cpio.gz created