Re: Backup & Restore

From: "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>
To: Dor Ben Dov <dor(dot)ben-dov(at)amdocs(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Backup & Restore
Date: 2020-02-25 01:55:48
Message-ID: 6894011.7758830.1582595748083@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HiCan u suggest a good backup solution for a windows installation ?  Looks like the suggested two [ pgbarman, pgbackrest ] works only in Linux.
On Tuesday, 25 February, 2020, 01:46:33 am IST, Stephen Frost <sfrost(at)snowman(dot)net> wrote:

Greetings,

* Dor Ben Dov (dor(dot)ben-dov(at)amdocs(dot)com) wrote:
> What is your backup and restore solution in production when working with Postgres ?
> (+ if you can say few words why you picked this X solution instead of others)

I'd recommend pgbackrest- https://www.pgbackrest.org, it's got lots of
great features including parallel backup, incremental and differential
backups, compression, encryption, and all of those can be used together.
pgbackrest also can parallelize WAL shipping if you're writing lots of
data.

There's other options out there, of course.  In any case, I strongly
recommend that you use one of the existing solutions and don't try to
roll your own.

Just to be clear- I'm also involved in the project (though not the
primary developer, that's David, who you'll also see on this list and on
the -hackers list contributing things to PostgreSQL).

Thanks!

Stephen

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sonam Sharma 2020-02-25 08:01:13 Trigger
Previous Message Adrian Klaver 2020-02-24 20:58:20 Re: LDAP with TLS is taking more time in Postgresql 11.5