binodprasai
2 Bronze

Protecting Avamar PostgreSQL database

Jump to solution

Hi All,

How do we protect the configuration and other information (PostgreSQL DB) of the Avamar Utility node?

Regards, Binod

0 Kudos
1 Solution

Accepted Solutions
ionthegeek
4 Ruthenium

Re: Protecting Avamar PostgreSQL database

Jump to solution

The Avamar software has built-in mechanisms to protect the databases on the utility node. There is no need to configure manual protection for the utility node.

As Amol stated above, the MCS database and configuration are backed up to the MC_BACKUPS account on the Avamar storage nodes. If the system is configured for replication, these backups will be replicated to the replication partner so the configuration is still protected in case of a disaster.

View solution in original post

9 Replies
christopher_ime
4 Ruthenium

Re: Protecting Avamar PostgreSQL database

Jump to solution

Binod,

Please consider moving this question as-is (no need to recreate) to the proper forum for maximum visibility.  Questions written to the users' own "Discussions" space don't get the same amount of attention and questions can go unanswered for a long time. 

You can do so by selecting "Move" under ACTIONS along the upper-right.  Then search for and select: "Avamar Support Forum" which would be the most relevant for this question.

Seeing though that over a month has elapsed since you posted, maybe you have already found the answer (possibly opened up a ticket with support)?  If so, once relocated, consider sharing the resolution and also marking the question as "Answered" so that it can help others that have the same question.  If not, once relocated, it will then have more visibility by the community of dedicated customers, partners, and EMC employees that are eager to assist.

0 Kudos
LeoLi
MOD
MOD

Re: Protecting Avamar PostgreSQL database

Jump to solution

Hi bpras,

Avamar uses a PostgreSQL database to store various kinds of data, such as backup and restore activities, events, defined groups and clients. This information is available for reporting using third-party reporting tools such as Crystal Reports, MS Query, and Microsoft Excel. PostgreSQL is a highly regarded open-source Relational Database Management System (RDMS). Information in the Avamar database is accessible through any PostgreSQL-compliant Open DataBase Connectivity (ODBC) interface.

Actually, Avamar Server will maintenance PostgreSQL DB. So, I think the you do not need to worry about it. If you still need to protect it, maybe you can backup the PostgreSQL DB. But, I'm not sure how to backup PostgreSQL DB.

binodprasai
2 Bronze

Re: Protecting Avamar PostgreSQL database

Jump to solution

Thanks Leo,

I am actually looking for the procedure to backup the PostgreSQL DB.

0 Kudos
LeoLi
MOD
MOD

Re: Protecting Avamar PostgreSQL database

Jump to solution

OK. Hope other peers can help you for PostgreSQL DB backup.

0 Kudos
Amol
3 Argentum

Re: Protecting Avamar PostgreSQL database

Jump to solution

You don't need to backup the database manually, Avamar backups up MCS database and configuration every 1 hour and stores on the GSAN, you can list the content of last MC_BACKUPS using following command on utility node

avtar --list --path=/MC_BACKUPS

Default database dump is stored on following location which is update every hour

/usr/local/avamar/var/mc/server_data/mcs_data_dump.sql

If you still want to backup database manually, run the following command as user admin

pg_dump -p 5555 mcdb >/tmp/mc_database_backup.sql

This will dump the database schema and content in "/tmp/mc_database_backup.sql" file

0 Kudos
binodprasai
2 Bronze

Re: Protecting Avamar PostgreSQL database

Jump to solution

Thanks Amol, Is there a way to redirect the backup to other storage device (other then Avamar)?

0 Kudos
ionthegeek
4 Ruthenium

Re: Protecting Avamar PostgreSQL database

Jump to solution

The Avamar software has built-in mechanisms to protect the databases on the utility node. There is no need to configure manual protection for the utility node.

As Amol stated above, the MCS database and configuration are backed up to the MC_BACKUPS account on the Avamar storage nodes. If the system is configured for replication, these backups will be replicated to the replication partner so the configuration is still protected in case of a disaster.

View solution in original post

martingoh
2 Bronze

Re: Protecting Avamar PostgreSQL database

Jump to solution

If there is no replication server, and if the utility node goes down, how do you recover it?

Can I say there is no redundancy protection like the storage nodes?

0 Kudos
umichklewis
4 Beryllium

Re: Protecting Avamar PostgreSQL database

Jump to solution

As mentioned above, the MCS database is stored on the GSAN itself.  That means, when the utility node is replaced, EMC Support can recover the MCS database from the GSAN back to the newly-replaced node.

0 Kudos