jdespres
2 Iron

MAN / AER postgres db alternate storage

Jump to solution

We have a Man AER node......  We haven't used it yet...

I would like to setup a alt location to send the postgres DB exports too...  And I was thinking.  Maybe we can use

the Avamar Grid that it will backup from...

Has anyone done this?  Is this do-a-able?

Thanks...

Joe Despres

Tags (4)
0 Kudos
1 Solution

Accepted Solutions
Highlighted
arturo3
1 Nickel

Re: MAN / AER postgres db alternate storage

Jump to solution

Joe,

AER node is running an external avamar agent activated on the external grid so you could use similar previous scripting and replace scp command by avtar command and backup snapshot folder on the external server.

0 Kudos
5 Replies
arturo3
1 Nickel

Re: MAN / AER postgres db alternate storage

Jump to solution

Joe,

DR exports can be sent to another machine using scp for example. Procedure steps are documented on this KB:

https://support.emc.com/kb/192102

If you don't have access these are the steps:

• In order to be able to successfully create an AER DR copy we need first to have at least one tape with space, labelled on the Default pool

• By default the AER DR copy needs to be run manually using the command below but many customers ask support to configure this to run auto

/opt/EMC/avamarer/bin/avamar-er-dr --export --pass=<postgrespassword>

•In order to run this command automatically we can use the AER internal Avamar cron

crontab –e
 
•And add a line at the end of the cron tab (with the time and frequency we want it to run) with something like the following as an example

34 12 * * * /root/AERdisasterrecovery.sh

•Where “AERdisasterrecovery.sh” is the following script which runs the DR command and does a scp of the snapshot file to an external server in order to keep the DR snapshots safe in the case if we lose the AER server

#!/bin/bash
PATH=/usr/local/avamar/bin:/sbin:/usr/sbin:/usr/local/avamar/bin:/bin:/usr/bin:/sbin:/usr/sbin:/usr/local/bin:/usr/local/sbin:/usr/local/apache/bin:/usr/local/ssl/bin:/opt/dell/srvadmin/bin:/opt/dell/srvadmin/sbin

export PATH

SNAPSHOTDIR=/tmp/ER-DR-SNAPSHOT


#create DR copy
/opt/EMC/avamarer/bin/avamar-er-dr --export --pass=<postgrespassword>

#copies the DR snapshot outside the AER server

File=`ls -latr /opt/EMC/snapshot | grep -e avamar-er-dr-1.1.0-01-Snapshot.zip | tail -1 | awk '{print $9}'`

echo $File
cp /opt/EMC/snapshot/$File $SNAPSHOTDIR
scp $SNAPSHOTDIR/$File root@<externalserver>:$SNAPSHOTDIR 

•This way we can automatically create snapshots of the AER configuration outside the server which will allow us to fully recover the server in the case of loss


* note that for a fully server recovery we also need the Networker bootstrap which is also generated with the same command but is saved on the Default tape pool

jdespres
2 Iron

Re: MAN / AER postgres db alternate storage

Jump to solution

Is there a process to setup a trusted method of sending the DB exports to a Avamar Grid?

Joe Despres

0 Kudos
Highlighted
arturo3
1 Nickel

Re: MAN / AER postgres db alternate storage

Jump to solution

Joe,

AER node is running an external avamar agent activated on the external grid so you could use similar previous scripting and replace scp command by avtar command and backup snapshot folder on the external server.

0 Kudos
jdespres
2 Iron

Re: MAN / AER postgres db alternate storage

Jump to solution

Don't seem to have the Normal Linux plugin for a backup of the MAN AER Node ::--->

Plugin                   Linux Avamar Extended Retention Export(1024)

Initial Install Date     2015-05-08 11:44:31 EDT

Last Version Registered  2015-05-08 11:44:31 EDT

Last Successful Backup   N/A

Plugin                   Linux Avamar Extended Retention Import(1034)

Initial Install Date     2015-05-08 11:44:31 EDT

Last Version Registered  2015-05-08 11:44:31 EDT

Last Successful Backup   N/A

Plugin                   Extended Retention Restore(1025)

Initial Install Date     2015-05-08 11:44:31 EDT

Last Version Registered  2015-05-08 11:44:31 EDT

Last Successful Backup   N/A

0 Kudos
arturo3
1 Nickel

Re: MAN / AER postgres db alternate storage

Jump to solution

You are right, it is not a normal plugin since it is the DTO export and imports plugins but avtar binary is similar to any avtar running on any Linux system and it can be used to backup DR image via command line as I suggested.

Rgds

0 Kudos