On 10/15/18 5:09 PM, Benoit Lobréau wrote:
By the way, do/can they both use streaming to receive WAL records? Or
streaming is only for standby servers. For backups you have only
file-based log shipping?
barman supports streaming but it's not as magical as one might think.
See pgbarm
By the way, do/can they both use streaming to receive WAL records? Or
> streaming is only for standby servers. For backups you have only
> file-based log shipping?
>
barman supports streaming but it's not as magical as one might think.
See pgbarman's documentation for how to manager .partial files
> I am not sure what you call discrete / continuous.
>> pgBackRest doesn't seem to allow the latter: recovery to any point in
>> time, only to some discrete moments. Correct me if I'm wrong.
>
>
> Are you talking about PITR ?
Yes. I had the impression, that with pgBackRest you do backups
occasion
Hi,
I am not sure what you call discrete / continuous.
pgbackrest allows backups of different kinds: full, incremental and
differential.
It keeps the wals necessary to recover since the oldest backup until the
current time.
The retention is expressed in number of full backups. You can also specif
Hi,
Thanks for your replies. By the way, I'm now running PostgreSQL 10 :)
My idea was to start with continuous archiving, then start a
log-shipping standby, then make it use streaming replication. Since
I'm kind of overwhelmed with information, options to be considered.
Anyways, I'm now trying to
Hello
What you are doing is called "log shipping", which means that when a wal
(write-ahead log) is filled in on the database server you ship it to a backup
server via rsync. It is fine but as you said the disadvantage is that the file
is shipped only when it is full, so you could have data loss
Greetings,
* Yuri Kanivetsky (yuri.kanivet...@gmail.com) wrote:
> I'm trying to compile a basic set of instruction needed to set up
> continuous archiving and to recover from a backup. I'm running
> PostgreSQL 9.3 on Debian Stretch system.
9.3 is about to be end-of-life in just another month or s
On 9/26/18 8:20 AM, Yuri Kanivetsky wrote:
I'm trying to compile a basic set of instruction needed to set up
continuous archiving and to recover from a backup. I'm running
PostgreSQL 9.3 on Debian Stretch system.
This is an incredibly complex topic and it is very difficult to
implement correc
