Re: 20220221-Clarification regarding PostgeSQL DB backup - Mailing list pgsql-general

From Ron
Subject Re: 20220221-Clarification regarding PostgeSQL DB backup
Date
Msg-id 285ac8ae-af7f-7756-f8a2-f3b4371680d2@gmail.com
Whole thread Raw
In response to 20220221-Clarification regarding PostgeSQL DB backup  ("Techsupport" <techsupport@sardonyx.in>)
List pgsql-general
On 2/20/22 10:59 PM, Techsupport wrote:
@font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4;}@font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;}p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:11.0pt; font-family:"Calibri","sans-serif";}a:link, span.MsoHyperlink {mso-style-priority:99; color:#0563C1; text-decoration:underline;}a:visited, span.MsoHyperlinkFollowed {mso-style-priority:99; color:#954F72; text-decoration:underline;}span.EmailStyle17 {mso-style-type:personal-compose; font-family:"Calibri","sans-serif"; color:windowtext;}.MsoChpDefault {mso-style-type:export-only; font-family:"Calibri","sans-serif";}div.WordSection1 {page:WordSection1;}

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

 

Please suggest me a tool to make differential backup


Please show us the full pg_dump command, including all parameters.

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Daevor The Devoted
Date:
Subject: Re: 20220221-Clarification regarding PostgeSQL DB backup
Next
From: "Techsupport"
Date:
Subject: RE: 20220221-Clarification regarding PostgeSQL DB backup