Provide a PostgreSQL backup to Clarity Support

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Broadcom Clarity Support requested a PostgreSQL database backup - what are the recommendations on providing it? 

Environment

All Supported Clarity Releases with PostgreSQL

Resolution

• Broadcom Support will need a "folder backup" or "directory backup"
• Use this command to get the backup, then upload to the Support case

pg_dump -U username -F d -d your_database_name -f backup_directory

• The -F d option creates a directory-based archive, which can be useful for selective restoration of objects. The -f option specifies the output directory.