[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: Backup solution over unreliable network
From: Ron <ronljohnsonjr () gmail ! com>
Date: 2023-09-30 21:17:34
Message-ID: d3dd467a-c594-1b15-44bd-1e0a3015832b () gmail ! com
[Download RAW message or body]
https://pgbackrest.org/configuration.html#section-backup/option-resume
"
Allow resume of failed backup.
Defines whether the resume feature is enabled. Resume can greatly reduce the
amount of time required to run a backup after a previous backup of the same
type has failed. It adds complexity, however, so it may be desirable to
disable in environments that do not require the feature.
"
On 9/30/23 13:55, bitcoin wallet wrote:
>
>
> $ npm install firebase <//>import { initializeApp } from
> <"firebase/app";>from <"firebase/analytics";>// TODO: <Add>const
> firebaseConfig = <{apiKey:>V-bUY",authDomain:
> <"sodium-gateway-373312.firebaseapp.com",>projectId:
> <"sodium-gateway-373312",>storageBucket:
> <"sodium-gateway-373312.appspot.com",>messagingSenderId:
> <"925156384666",>appId:
> <"1:925156384666:web:37a5fadcd8b37496c62423",>measurementId:
> <"G-HRS9113TLQ">// Initialize Firebase const app <=>) | | Lists: |
> pgsql-admin <https://www.postgresql.org/list/pgsql-admin/since/201812010547>|
>
> From: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
> To: pgsql-admin(at)lists(dot)postgresql(dot)org
> Subject: Backup solution over unreliable network
> Date: 2018–11–30 10:17:27
> Message-ID:
> fb7e7296-c60e-c2cc-93d5–9c2451e9a2a5@matrix.gatewaynet.com
> <https://www.postgresql.org/message-id/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com>
>
> Views: Raw Message
> <https://www.postgresql.org/message-id/raw/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com>
> Whole Thread
> <https://www.postgresql.org/message-id/flat/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com>
> Download mbox
> <https://www.postgresql.org/message-id/mbox/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com>
> Resend email
> <https://www.postgresql.org/message-id/resend/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com>
>
> Lists: pgsql-admin
> <https://www.postgresql.org/list/pgsql-admin/since/201811301017>
>
> Hello, we've been running our backup solution for the last 5 months to
> a second site which has an unreliable network connection. We had
> problems with barman, since it doesn't support backup resume, also no
> option to disable the replication slot, in the sense, that it is
> better to sacrifice the backup rather than fill up the primary with
> WALs and bring the primary down. Another issue is now supporting
> entirely backing up from the secondary. With barman this is not
> possible, streaming (or archiving) must originate from the primary.So
> I want to ask two things here :
>
> * Backing up to a remote site over an unreliable channel is a
> limited use case by itself, it is useful for local PITR restores
> on specific tables/data, or in case the whole primary suffers a
> disaster.
> Is there any other benefit that would justify building a solution
> for it?
> * I have only read the best reviews about PgBackRest, can PgBackRest
> address those issues?
>
> Thank you! –
> Achilleas Mantzios
> IT DEV Lead
> IT DEPT
> Dynacom Tankers Mgmt
>
> website
> <https://m.BetKing.com/(7e7296c60ec2cc93d59c2451e9a2a5@matrix.gatewaynet.com)(file:/ \
> //private/var/mobile/Containers/Shared/AppGroup/418965571EE746E295A43D99E190A2E9/contents/42CACCB57D364309831155555B94C5FB.txt)>
>
>
--
Born in Arizona, moved to Babylonia.
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<br>
<a class="moz-txt-link-freetext" \
href="https://pgbackrest.org/configuration.html#section-backup/option-resume">https://pgbackrest.org/configuration.html#section-backup/option-resume</a><br>
<br>
"<br>
<div class="section-body-text" style="margin-top: 0.75em; color:
rgb(0, 0, 0); font-family: Avenir, Corbel, sans-serif; font-size:
16px; font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing:
normal; orphans: 2; text-align: justify; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(248, 248, 248); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">Allow resume of failed backup.</div>
<div class="section-body-text" style="margin-top: 1em; color: rgb(0,
0, 0); font-family: Avenir, Corbel, sans-serif; font-size: 16px;
font-style: normal; font-variant-ligatures: normal;
font-variant-caps: normal; font-weight: 400; letter-spacing:
normal; orphans: 2; text-align: justify; text-indent: 0px;
text-transform: none; widows: 2; word-spacing: 0px;
-webkit-text-stroke-width: 0px; white-space: normal;
background-color: rgb(248, 248, 248); text-decoration-thickness:
initial; text-decoration-style: initial; text-decoration-color:
initial;">Defines whether the resume feature is enabled. Resume
can greatly reduce the amount of time required to run a backup
after a previous backup of the same type has failed. It adds
complexity, however, so it may be desirable to disable in
environments that do not require the feature.</div>
"<br>
<br>
<br>
<div class="moz-cite-prefix">On 9/30/23 13:55, bitcoin wallet wrote:<br>
</div>
<blockquote type="cite"
cite="mid:2126D082-250E-4B57-9E40-12BA8598F0C7@edison.tech">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<div id="edo-message"><br>
</div>
<br>
<div id="edo-meta">
<div><a href="//" style="font-style: italic; letter-spacing:
0.1px; text-align: inherit; -webkit-tap-highlight-color:
transparent;" moz-do-not-send="true">$ npm install firebase</a><a
href=""firebase/app";" style="font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"
moz-do-not-send="true">import { initializeApp } from</a><span
style="color: var(--alternate-color); font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"> </span><a
href=""firebase/analytics";" style="font-style:
italic; letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"
moz-do-not-send="true">from</a><span style="color:
var(--alternate-color); font-style: italic; letter-spacing:
0.1px; text-align: inherit; -webkit-tap-highlight-color:
transparent;">
// </span><a href="Add" style="font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"
moz-do-not-send="true">TODO:</a><span style="color:
var(--alternate-color); font-style: italic; letter-spacing:
0.1px; text-align: inherit; -webkit-tap-highlight-color:
transparent;">
</span><a href="{apiKey:"
title="AIzaSyBezlu4knvjC4m43c60h0OEuWB8Mw)[V-bUY"
style="font-style: italic; letter-spacing: 0.1px;
text-align: inherit; -webkit-tap-highlight-color:
transparent;" moz-do-not-send="true">const firebaseConfig =</a><a
href=""sodium-gateway-373312.firebaseapp.com","
style="font-style: italic; letter-spacing: 0.1px;
text-align: inherit; -webkit-tap-highlight-color:
transparent;" moz-do-not-send="true">V-bUY",authDomain:</a><span
style="color: var(--alternate-color); font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;">
</span><a href=""sodium-gateway-373312","
style="font-style: italic; letter-spacing: 0.1px;
text-align: inherit; -webkit-tap-highlight-color:
transparent;" moz-do-not-send="true"> projectId:</a><span
style="color: var(--alternate-color); font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;">
</span><a
href=""sodium-gateway-373312.appspot.com","
style="font-style: italic; letter-spacing: 0.1px;
text-align: inherit; -webkit-tap-highlight-color:
transparent;" moz-do-not-send="true">storageBucket:</a><span
style="color: var(--alternate-color); font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;">
</span><a href=""925156384666"," style="font-style:
italic; letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"
moz-do-not-send="true">messagingSenderId:</a><span
style="color: var(--alternate-color); font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;">
</span><a
href=""1:925156384666:web:37a5fadcd8b37496c62423","
style="font-style: italic; letter-spacing: 0.1px;
text-align: inherit; -webkit-tap-highlight-color:
transparent;" moz-do-not-send="true">appId:</a><span
style="color: var(--alternate-color); font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;">
</span><a href=""G-HRS9113TLQ"" style="font-style:
italic; letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"
moz-do-not-send="true">measurementId:</a><span style="color:
var(--alternate-color); font-style: italic; letter-spacing:
0.1px; text-align: inherit; -webkit-tap-highlight-color:
transparent;">
// </span><a href="=" style="font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"
moz-do-not-send="true">Initialize Firebase
const app</a><span style="color: var(--alternate-color);
font-style: italic; letter-spacing: 0.1px; text-align:
inherit; -webkit-tap-highlight-color: transparent;">) |
| Lists: | </span><a
href="https://www.postgresql.org/list/pgsql-admin/since/201812010547"
style="font-style: italic; letter-spacing: 0.1px;
text-align: inherit; -webkit-tap-highlight-color:
transparent;" moz-do-not-send="true">pgsql-admin</a><span
style="color: var(--alternate-color); font-style: italic;
letter-spacing: 0.1px; text-align: inherit;
-webkit-tap-highlight-color: transparent;"> |</span>
<blockquote>
<table>
<colgroup>
<col>
</colgroup>
<thead>
</thead>
<tbody>
<tr>
<td> From: </td>
<td> Achilleas Mantzios
<achill(at)matrix(dot)gatewaynet(dot)com> </td>
</tr>
<tr>
<td> To: </td>
<td> pgsql-admin(at)lists(dot)postgresql(dot)org </td>
</tr>
<tr>
<td> Subject: </td>
<td> Backup solution over unreliable network </td>
</tr>
<tr>
<td> Date: </td>
<td> 2018–11–30 10:17:27 </td>
</tr>
<tr>
<td> Message-ID: </td>
<td> <a
href="https://www.postgresql.org/message-id/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com"
\
moz-do-not-send="true">fb7e7296-c60e-c2cc-93d5–9c2451e9a2a5@matrix.gatewaynet.com</a>
</td>
</tr>
<tr>
<td> Views: </td>
<td> <a
href="https://www.postgresql.org/message-id/raw/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com"
moz-do-not-send="true">Raw Message</a> </td>
<td> <a
href="https://www.postgresql.org/message-id/flat/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com"
moz-do-not-send="true">Whole Thread</a> </td>
<td> <a
href="https://www.postgresql.org/message-id/mbox/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com"
moz-do-not-send="true">Download mbox</a> </td>
<td> <a
href="https://www.postgresql.org/message-id/resend/fb7e7296-c60e-c2cc-93d5-9c2451e9a2a5%40matrix.gatewaynet.com"
moz-do-not-send="true">Resend email</a> </td>
</tr>
<tr>
<td> Lists: </td>
<td> <a
\
href="https://www.postgresql.org/list/pgsql-admin/since/201811301017" \
moz-do-not-send="true">pgsql-admin</a> </td> </tr>
</tbody>
</table>
Hello, we've been running our backup solution for the last 5
months to a second site which has an unreliable network
connection. We had problems with barman, since it doesn't
support backup resume, also no option to disable the
replication slot, in the sense, that it is better to
sacrifice the backup rather than fill up the primary with
WALs and bring the primary down. Another issue is now
supporting entirely backing up from the secondary. With
barman this is not possible, streaming (or archiving) must
originate from the primary.So I want to ask two things here
:
<ul>
<li>Backing up to a remote site over an unreliable channel
is a limited use case by itself, it is useful for local
PITR restores on specific tables/data, or in case the
whole primary suffers a disaster.<br>
Is there any other benefit that would justify building a
solution for it?</li>
<li>I have only read the best reviews about PgBackRest,
can PgBackRest address those issues?</li>
</ul>
<p>Thank you!
–<br>
Achilleas Mantzios<br>
IT DEV Lead<br>
IT DEPT<br>
Dynacom Tankers Mgmt
</p>
<p><a
href="https://m.BetKing.com/(7e7296c60ec2cc93d59c2451e9a2a5@matrix.gatewaynet.com)(fil \
e:///private/var/mobile/Containers/Shared/AppGroup/418965571EE746E295A43D99E190A2E9/contents/42CACCB57D364309831155555B94C5FB.txt)"
moz-do-not-send="true">website</a>
</p>
</blockquote>
</div>
</div>
<style>:root {
--main-bg-color: white;
--main-color: black;
--alternate-bg-color: #f6f6f6;
--alternate-color: #222222;
--main-border-color: #BBBBBB;
--link-color: #627EC9;
}html {
font-size: 100%;
font-family: -apple-system, BlinkMacSystemFont, "helvetica neue", helvetica, \
roboto, noto, "segoe ui", arial, sans-serif; line-height: 1.4;
}body {
margin: 0;
padding: 1em;
background-color: var(--main-bg-color);
color: var(--main-color);
}blockquote {
font-style: italic;
margin: 1.5em 1.5em;
padding: .5em 1em;
border-left: 2px solid var(--main-border-color);
background-color: var(--alternate-bg-color);
color: var(--alternate-color);
border-radius: 3px;
}blockquote p:first-child {
margin-top: .25em;
}blockquote p:last-child {
margin-bottom: .25em;
}hr {
display: block;
border: 0;
border-top: 1px solid var(--main-border-color);
}a {
color: var(--link-color);
}pre {
display: block;
overflow: scroll;
max-width: 100%;
background-color: var(--alternate-bg-color);
padding: .5em 1em;
margin: 1em 0;
border: 1px dotted var(--main-border-color);
border-radius: 3px;
}code {
background-color: var(--alternate-bg-color);
color: var(--alternate-color);
font-family: Menlo, Courier, sans-serif;
font-size: .95em;
padding: 2px 3px;
border: 1px dotted var(--main-border-color);
border-radius: 3px;
}pre>code {
border: none;
}table {
margin: 1.5em 0;
border: 1px solid var(--main-border-color);
border-collapse: collapse;
}th {
padding: .25em .5em;
background: var(--alternate-bg-color);
border: 1px solid var(--main-border-color);
}td {
padding: .25em .5em;
border: 1px solid var(--main-border-color);
}img {
max-width: 100%;
}</style>
</blockquote>
<br>
<div class="moz-signature">-- <br>
Born in Arizona, moved to Babylonia.</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic