Backing up PostgreSQL Metadata Repository

1. Login to the Controller box as the Diyotta user.

2. If the PostgreSQL database is not running then, start it using the following command

  • For embedded metadata

$DI_HOME/server/pgsql/startdb.sh

  • For external metadata
<postgres installation folder>/postgres/bin/startdb.sh

Note: To verify the status of postgreSQL, connect to postgreSQL database using ./psql -p <db port> -d <db name> -U <db username> . psql command is available in the above mentioned "bin" folder.

2. Run the PostgreSQL backup command from Controller installation

 $DI_HOME/bin/pgbackup.sh

A back up of the metadata repository is created in the directory $DI_HOME/server/pgsql/backup. This default directory can be overridden by adding environment variable DI_BACKUP and specifying the directory where the backup should be taken.

The format in which the metadata backup file is generated is direpdb_<id>_<dt>.backup.gz. Here <id> is the version id of controller & <dt> is a timestamp when backup file is generated.