How to make automatic database backup?

Question

PostgreSQL

How to make automatic database backup?
Let's say there are several databases on postgress on a remote server. And all of them are actively used.
You need to make a full copy on another remote server at least once a day.

Answer 1

Make a backup locally using cron and transfer it to a remote server or use the -h and -U switches from pg_dump to immediately make a backup to a remote server.

Answer 2

If the databases are actively used and the backup process interferes with this, make a replica and backup from it. But in general pg_basebackup/pg_dump.