hadoop: How to take ambari backup

AMBARI backups can be taken using posgresql backup command pg_dump.


ambari-server stop
  • Stop the original Ambari Server.
    ambari-server stop
  • Create a directory to hold the database backups.
    cd /tmp
    mkdir dbdumps
    cd dbdumps/
  • Create the database backups.
    pg_dump -U $AMBARI-SERVER USERNAME ambari > ambari.sql Password: $AMBARI-SERVER PASSWORD
    pg_dump -U $MAPRED USERNAME ambarirca > ambarirca.sql Password: $MAPRED PASSWORD

Postgresql backup commands from its man page:

To dump a database called mydb into a SQL-script file:

$ pg_dump mydb > db.sql

To reload such a script into a (freshly created) database named newdb:

$ psql -d newdb -f db.sql

To dump a database into a custom-format archive file:

$ pg_dump -Fc mydb > db.dump

To reload an archive file into a (freshly created) database named newdb:

$ pg_restore -d newdb db.dump

To dump a single table named mytab:

$ pg_dump -t mytab mydb > db.sql

To  dump  all  tables whose names start with emp in the detroit schema, except for the table
named employee_log:

$ pg_dump -t ’detroit.emp*’ -T detroit.employee_log mydb > db.sql

To dump all schemas whose names start with east or  west  and  end  in  gsm,  excluding  any
schemas whose names contain the word test:

$ pg_dump -n ’east*gsm’ -n ’west*gsm’ -N ’*test*’ mydb > db.sql

The same, using regular expression notation to consolidate the switches:

$ pg_dump -n ’(east|west)*gsm’ -N ’*test*’ mydb > db.sql

To dump all database objects except for tables whose names begin with ts_:

$ pg_dump -T ’ts_*’ mydb > db.sql

To  specify an upper-case or mixed-case name in -t and related switches, you need to double-
quote the name; else it will be folded to lower case (see Patterns  [psql(1)]).  But  double
quotes are special to the shell, so in turn they must be quoted.  Thus, to dump a single ta-
ble with a mixed-case name, you need something like

$ pg_dump -t ’”MixedCaseName”’ mydb > mytab.sql