Our software configurations are below
Database: PostgreSQL 14.1 Version OS: Windows Server 2019
We have taken the database backup from PgAdmin 4.0.
Per day almost 4.5 Million records will be inserted on my database, so we need the differential and incremental backup option
In Microsoft SQL Server there is an option to take differential backup and full backup. Like that is there any option is available on PostgreSQL for Windows based server environment.
When we google it, there is a tools pgbarman and pgbackrest are available to fulfill the back up needs, but both are not support for Windows server environment in production. and those are backup the entire database server, not the particular database of the PostgreSQL Database server
Give me a right suggestion to make differential and incremental backup in Windows based Server environment!
Database: PostgreSQL 14.1 Version OS: Windows Server 2019
We have taken the database backup from PgAdmin 4.0.
Per day almost 4.5 Million records will be inserted on my database, so we need the differential and incremental backup option
In Microsoft SQL Server there is an option to take differential backup and full backup. Like that is there any option is available on PostgreSQL for Windows based server environment.
When we google it, there is a tools pgbarman and pgbackrest are available to fulfill the back up needs, but both are not support for Windows server environment in production. and those are backup the entire database server, not the particular database of the PostgreSQL Database server
Give me a right suggestion to make differential and incremental backup in Windows based Server environment!