[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: 20220221-Clarification regarding PostgeSQL DB backup
From: Daevor The Devoted <dollien () gmail ! com>
Date: 2022-02-21 7:32:11
Message-ID: CAAZnbVqXJkLKUGo5UEY=t93dCS4e7Fd0-peczyJ_XUFjbWM+3Q () mail ! gmail ! com
[Download RAW message or body]
Hi Karthick
In that case, your are options are:
1. Continuous WAL Archiving
<https://www.postgresql.org/docs/current/continuous-archiving.html>
This is "like" using diff backups, but not quite the same.
OR
2. Use a 3rd party app, for example Barman <https://pgbarman.org/> or
pgBackRest <https://pgbackrest.org/>
Good luck!
~~Na-iem Dollie
On Mon, Feb 21, 2022 at 8:25 AM Techsupport <techsupport@sardonyx.in> wrote:
> *Hi ~~Na-iem Dollie,*
>
>
>
> Thanks for your reply,
>
>
>
> In SQL Server there is an option to take Full backup and Differential
> Backup for a particular database.
>
>
>
> Like that, we need to take the differential Backup in PostgreSQL. This is
> my primary need.
>
>
>
> *Thanks,*
>
> *Karthick Ramu*
>
>
>
>
>
> *From:* Daevor The Devoted [mailto:dollien@gmail.com]
> *Sent:* Monday, February 21, 2022 11:05 AM
> *To:* Techsupport
> *Cc:* pgsql-generallists.postgresql.org
> *Subject:* Re: 20220221-Clarification regarding PostgeSQL DB backup
>
>
>
> Hi Karthick
>
>
>
> I'm a little rusty on PG (it's been about a decade since I last worked
> intensely with it), but I seem to remember that restoring with indexes can
> be very slow. The faster approach is to restore *without* indexes, and
> then create the indexes once the data restore is complete.
>
>
>
> My knowledge may be outdated, so best to check with others that have more
> recent knowledge. However, it's probably worth investigating in the
> meantime.
>
>
>
> Okay, I just had a quick look at the documentation, and it seems there is
> an option to run multiple concurrent jobs for the time-consuming parts of a
> restore (which includes index creation):
>
>
>
> -j *number-of-jobs*
>
>
>
> see: https://www.postgresql.org/docs/current/app-pgrestore.html (or check
> the docs for whatever PG version you have)
>
>
>
> Good luck!
>
>
>
> ~~Na-iem Dollie
>
>
>
> On Mon, Feb 21, 2022 at 6:59 AM Techsupport <techsupport@sardonyx.in>
> wrote:
>
> 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
>
>
>
> Thanks,
>
> Karthick Ramu
>
>
[Attachment #3 (text/html)]
<div dir="ltr">Hi Karthick<div><br></div><div>In that case, your are options \
are:</div><div><br></div><div>1. <a \
href="https://www.postgresql.org/docs/current/continuous-archiving.html">Continuous \
WAL Archiving</a></div><div>This is "like" using diff backups, but not \
quite the same.</div><div><br></div><div>OR</div><div><br></div><div>2. Use a 3rd \
party app, for example <a href="https://pgbarman.org/">Barman</a> or <a \
href="https://pgbackrest.org/">pgBackRest</a></div><div><br></div><div><div>Good \
luck!</div><div><br></div><div>~~Na-iem Dollie</div></div></div><br><div \
class="gmail_quote"><div dir="ltr" class="gmail_attr">On Mon, Feb 21, 2022 at 8:25 AM \
Techsupport <<a href="mailto:techsupport@sardonyx.in">techsupport@sardonyx.in</a>> \
wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px \
0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div lang="EN-US"><div \
class="gmail-m_1362844317371081652WordSection1"><p class="MsoNormal"><b><span \
style="font-size:11pt;font-family:Calibri,"sans-serif";color:rgb(31,73,125)">Hi \
</span>~~Na-iem Dollie,<u></u><u></u></b></p><p class="MsoNormal"><u></u> \
<u></u></p><p class="MsoNormal">Thanks for your reply,<u></u><u></u></p><p \
class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">In SQL Server there is an \
option to take Full backup and Differential Backup for a particular database. \
<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal">Like \
that, we need to take the differential Backup in PostgreSQL. This is my primary \
need.<u></u><u></u></p><p class="MsoNormal"><u></u> <u></u></p><p \
class="MsoNormal"><b>Thanks,<u></u><u></u></b></p><p class="MsoNormal"><b>Karthick \
Ramu<u></u><u></u></b></p><p class="MsoNormal"><span \
style="font-size:11pt;font-family:Calibri,"sans-serif";color:rgb(31,73,125)"><u></u> \
<u></u></span></p><p class="MsoNormal"><span \
style="font-size:11pt;font-family:Calibri,"sans-serif";color:rgb(31,73,125)"><u></u> \
<u></u></span></p><p class="MsoNormal"><b><span \
style="font-size:11pt;font-family:Calibri,"sans-serif"">From:</span></b><span \
style="font-size:11pt;font-family:Calibri,"sans-serif""> Daevor The Devoted \
[mailto:<a href="mailto:dollien@gmail.com" target="_blank">dollien@gmail.com</a>] \
<br><b>Sent:</b> Monday, February 21, 2022 11:05 AM<br><b>To:</b> \
Techsupport<br><b>Cc:</b> <a href="http://pgsql-generallists.postgresql.org" \
target="_blank">pgsql-generallists.postgresql.org</a><br><b>Subject:</b> Re: \
20220221-Clarification regarding PostgeSQL DB backup<u></u><u></u></span></p><p \
class="MsoNormal"><u></u> <u></u></p><div><div><p class="MsoNormal">Hi \
Karthick<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> \
<u></u></p></div><p class="MsoNormal">I'm a little rusty on PG (it's been \
about a decade since I last worked intensely with it), but I seem to remember that \
restoring with indexes can be very slow. The faster approach is to restore \
<i>without</i> indexes, and then create the indexes once the data restore is \
complete.<u></u><u></u></p><div><p class="MsoNormal"><u></u> \
<u></u></p></div><div><p class="MsoNormal">My knowledge may be outdated, so best to \
check with others that have more recent knowledge. However, it's probably worth \
investigating in the meantime.<u></u><u></u></p></div><div><p \
class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Okay, I just \
had a quick look at the documentation, and it seems there is an option to run \
multiple concurrent jobs for the time-consuming parts of a restore (which includes \
index creation):<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> \
<u></u></p></div><div><p class="MsoNormal"><span \
style="font-size:11pt;font-family:"Courier \
New";color:rgb(13,10,11);background:rgb(248,249,250)">-j \
<code><b><i>number-of-jobs</i></b></code></span><u></u><u></u></p></div><div><p \
class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">see: <a \
href="https://www.postgresql.org/docs/current/app-pgrestore.html" \
target="_blank">https://www.postgresql.org/docs/current/app-pgrestore.html</a> (or \
check the docs for whatever PG version you have)<u></u><u></u></p></div><div><p \
class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Good \
luck!<u></u><u></u></p></div><div><p class="MsoNormal"><u></u> \
<u></u></p></div><div><p class="MsoNormal">~~Na-iem \
Dollie<u></u><u></u></p></div></div><p class="MsoNormal"><u></u> \
<u></u></p><div><div><p class="MsoNormal">On Mon, Feb 21, 2022 at 6:59 AM Techsupport \
<<a href="mailto:techsupport@sardonyx.in" \
target="_blank">techsupport@sardonyx.in</a>> \
wrote:<u></u><u></u></p></div><blockquote \
style="border-top:none;border-right:none;border-bottom:none;border-left:1pt solid \
rgb(204,204,204);padding:0in 0in 0in 6pt;margin:5pt 0in 5pt 4.8pt"><div><div><p \
class="MsoNormal">Hi Team, <u></u><u></u></p><p \
class="MsoNormal"> <u></u><u></u></p><p class="MsoNormal">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)<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p \
class="MsoNormal">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<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p \
class="MsoNormal">Please suggest me a tool to make differential \
backup<u></u><u></u></p><p class="MsoNormal"> <u></u><u></u></p><p \
class="MsoNormal">Thanks,<u></u><u></u></p><p class="MsoNormal">Karthick \
Ramu<u></u><u></u></p></div></div></blockquote></div></div></div></blockquote></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic