To Backup a database using pgAdmin4 (To get a data dump using a pgAdmin4):
- Open pgAdmin 4 and connect to your server.
- Select the database you wish to back up from the left sidebar.
- Right-click on the database and choose Backup.
- Specify the file path and name for the backup file in the Filename field.
- Choose the format you want (e.g., Custom, Tar, Plain, Directory) from the format dropdown.
- Click Backup
The Custom and Tar formats save the backup in binary SQL, which is more suitable for restores involving more complex data types and faster restoration.