How to do a incremental backup
Hey, taking a full backup every day will be huge, so thinking of doing a full backup once in a month & incremental backups every day or so. I would like to know the best solution to achieve this.
I was using postgres database. Changed wal_level to replica, & turned on archive_mode. Then it started generating wal files, which I used to restore to point in time recovery.