pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPgbackrest
6+ messages / 5 participants
[nested] [flat]
* Pgbackrest
@ 2018-10-12 07:05 For@ll <forall@stalowka.info>
2018-10-12 12:07 ` Re: Pgbackrest Stephen Frost <sfrost@snowman.net>
0 siblings, 1 reply; 6+ messages in thread
From: For@ll @ 2018-10-12 07:05 UTC (permalink / raw)
To: pgsql-admin
Hi,
For now I use OmniPITR for backup and replication with postgresql, but
we looking something else and I find pgbackrest, so I have a few questions:
- use OmniPITR for streaming replication I have 2 way protection, when
slave long time off,after start, postgresql restore data from wal before
switching to the streamgin replication from postgresql.
It's possible to do in pgbackrest?
- in pgbackrest streaming replication it can be only with "async state"?
Regards,
Albert.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Pgbackrest
2018-10-12 07:05 Pgbackrest For@ll <forall@stalowka.info>
@ 2018-10-12 12:07 ` Stephen Frost <sfrost@snowman.net>
0 siblings, 0 replies; 6+ messages in thread
From: Stephen Frost @ 2018-10-12 12:07 UTC (permalink / raw)
To: For@ll <forall@stalowka.info>; +Cc: pgsql-admin
Greetings,
* For@ll (forall@stalowka.info) wrote:
> For now I use OmniPITR for backup and replication with postgresql, but
> we looking something else and I find pgbackrest, so I have a few questions:
>
> - use OmniPITR for streaming replication I have 2 way protection, when
> slave long time off,after start, postgresql restore data from wal before
> switching to the streamgin replication from postgresql.
> It's possible to do in pgbackrest?
Yes, when you do a restore with pgbackrest, the recovery.conf will be
set up to pull WAL from the repository to catch up.
> - in pgbackrest streaming replication it can be only with "async state"?
Note that pgbackrest doesn't use streaming replication for WAL as it's
too slow, we use archive_command instead (and will run multiple parallel
workers to get ahead of where archive_command is at, if there's WAL
available to process and parallel workers are configured).
It doesn't matter to pgbackrest if the replication between your primary
and replica is synchronous or asycnhronous.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* PgBackrest
@ 2021-08-25 12:20 Gokan Atmaca <linux.gokan@gmail.com>
2021-08-25 13:28 ` Re: PgBackrest Ron <ronljohnsonjr@gmail.com>
2021-08-25 21:35 ` Re: PgBackrest Mladen Gogala <gogala.mladen@gmail.com>
0 siblings, 2 replies; 6+ messages in thread
From: Gokan Atmaca @ 2021-08-25 12:20 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hello
I'm backing up with PgBackrest. When backups are finished, I want it
to notify me via email. Is there a tool for this?
Thanks.
--
⢀⣴⠾⠻⢶⣦⠀
⣾⠁⢠⠒⠀⣿⡁ Debian - The universal operating system
⢿⡄⠘⠷⠚⠋⠀ https://www.debian.org
⠈⠳⣄⠀⠀⠀⠀
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PgBackrest
2021-08-25 12:20 PgBackrest Gokan Atmaca <linux.gokan@gmail.com>
@ 2021-08-25 13:28 ` Ron <ronljohnsonjr@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: Ron @ 2021-08-25 13:28 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
On 8/25/21 7:20 AM, Gokan Atmaca wrote:
> Hello
>
> I'm backing up with PgBackrest. When backups are finished, I want it
> to notify me via email. Is there a tool for this?
I'd check the return code, and send the email based on that.
--
Angular momentum makes the world go 'round.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PgBackrest
2021-08-25 12:20 PgBackrest Gokan Atmaca <linux.gokan@gmail.com>
@ 2021-08-25 21:35 ` Mladen Gogala <gogala.mladen@gmail.com>
2021-08-26 07:07 ` Re: PgBackrest Gokan Atmaca <linux.gokan@gmail.com>
1 sibling, 1 reply; 6+ messages in thread
From: Mladen Gogala @ 2021-08-25 21:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Yup. /usr/bin/bash should be able to do that, if programmed carefully.
On 8/25/21 8:20 AM, Gokan Atmaca wrote:
> Hello
>
> I'm backing up with PgBackrest. When backups are finished, I want it
> to notify me via email. Is there a tool for this?
>
>
> Thanks.
>
>
>
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PgBackrest
2021-08-25 12:20 PgBackrest Gokan Atmaca <linux.gokan@gmail.com>
2021-08-25 21:35 ` Re: PgBackrest Mladen Gogala <gogala.mladen@gmail.com>
@ 2021-08-26 07:07 ` Gokan Atmaca <linux.gokan@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Gokan Atmaca @ 2021-08-26 07:07 UTC (permalink / raw)
To: Mladen Gogala <gogala.mladen@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
> Yup. /usr/bin/bash should be able to do that, if programmed carefully.
I'll do it with bash. thanks for the answers.
On Thu, Aug 26, 2021 at 12:35 AM Mladen Gogala <gogala.mladen@gmail.com> wrote:
>
> Yup. /usr/bin/bash should be able to do that, if programmed carefully.
>
> On 8/25/21 8:20 AM, Gokan Atmaca wrote:
> > Hello
> >
> > I'm backing up with PgBackrest. When backups are finished, I want it
> > to notify me via email. Is there a tool for this?
> >
> >
> > Thanks.
> >
> >
> >
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2021-08-26 07:07 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-10-12 07:05 Pgbackrest For@ll <forall@stalowka.info>
2018-10-12 12:07 ` Stephen Frost <sfrost@snowman.net>
2021-08-25 12:20 PgBackrest Gokan Atmaca <linux.gokan@gmail.com>
2021-08-25 13:28 ` Re: PgBackrest Ron <ronljohnsonjr@gmail.com>
2021-08-25 21:35 ` Re: PgBackrest Mladen Gogala <gogala.mladen@gmail.com>
2021-08-26 07:07 ` Re: PgBackrest Gokan Atmaca <linux.gokan@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox