How to generate a PostgreSQL Database Backup

Scenario

I have been asked by the BOC technical support to create and upload a Database Backup to reproduce and further test a reported issue on internal secured machines.

Procedure

There are multiple ways to generate a PostgreSQL Database Backup. The following Article explains the process while using pgAdmin, which is the leading Open Source graphical management tool for PostgreSQL.

Open your Windows menu and search for pgAdmin. Start your application and enter your Database Admins Master password.

In the Object Explorer pane, under Servers<my-server-name>\Databases, right-click your database (1), followed by a left-click on Backup (2).

In the General tab, enter a target Filename (1), select Custom (2) as Format with a Compression ratio of 9 (3)

Afterward, click the Button Backup (4) in the bottom right corner to generate the Database Backup, which can now be shared with BOC technical support. Since the Database Backup does contain sensible data, only upload it to an authenticated aFFE-Link provided by the BOC technical support. A detailed description how to use it, please consult How do I use the file sharing platform "aFFE"?

Useful Links

Further information on PostgreSQL database backups can be found in the official pgAdmin documentation.