How to Dump Database using DBeaver
- Download and Install DBeaver from their site
- Remove the snap version if you’re on Linux since Snap won’t allow you to access you’re root directories outside your app installation folder
- In DBeaver, right-click the database and click Tools > Backup.
- Click on Load Client and load the
pg_dump
client from your directory ( typically/usr/bin/
if you’re on Linux) - Select schemas to include and click Next.
- For Format, choose Plain.
Optional: You might choose to make the backup without ownership or privilege statements. This makes it easier to restore to a different server. However, note that the user restoring the database from SQL backup will become the new owner.
- Place a check next to these boxes:
- Do not backup privileges (GRANT/REVOKE)
- Discard objects owner
- Click Start.
Once the process is complete you should find the database dump in your desired directory.