Automatic backup of PostgreSQL database in Ubuntu

you can use the following:

sudo crontab -e

at the end of the file add this:

0 6 * * * sudo pg_dump -U USERNAME -h REMOTE_HOST -p REMOTE_PORT NAME_OF_DB > LOCATION_AND_NAME_OF_BACKUP_FILE

This command will take an automated backup of your selected db everyday at 6:00 AM (after changing options of the command to fit to ur db)