How to download backup PostgreSQL database. As we use digital ocean so have to log in to the server with the proper login credentials. So as I have an ssh connection turned on and my configuration file is connected with the server so I can try this.

Using this command:

scp -P [port_num] [username]@[ip]:[file_path] [localFile_Path]

I set the port number and the user also IP and file path from the server and local file path where I want to download the file.
done...

Local file path example: C:\Users\shoha\Downloads

Server file path example: /var/www/db-backup/api/api-main-db-29-07-2022-.gz

This is the easiest way how you can download your Postgres database to your local drive.