Hi Team,
We have used PG_DUMP to take backup of particular database from the PostgreSQL Server. It takes too long to restore the databases , which has Half Billion records (almost 8 Hour)
My primary need is to make the Differential and Incremental backup on the Windows Server. When I search there is a tool Barman and PG_BackRest is available. But that will be supported only for Linux based servers only...
PGSQL1
Last Activity: Feb 22 '22, 11:59 AM
Joined: Feb 21 '22
Location:
-
PGSQL1 started a topic PostgreSQL Differential and Incremental Backup for Windows based server environmentin PostgreSQLPostgreSQL Differential and Incremental Backup for Windows based server environment
-
PGSQL1 started a topic PostgreSQL Differential and Incremental Backup for Windows based server environmentin PostgreSQLPostgreSQL Differential and Incremental Backup for Windows based server environment
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...
No activity results to display