Backup & Restore

Am 24.02.20 um 09:18 schrieb Dor Ben Dov:

Hi All,

What is your backup and restore solution in production when working
with Postgres ?

most of our customers using Barman: https://www.pgbarman.org/

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

Greetings,

* Dor Ben Dov (dor.ben-dov@amdocs.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

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@snowman.net> wrote:

Greetings,

* Dor Ben Dov (dor.ben-dov@amdocs.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

Greetings,

* sivapostgres@yahoo.com (sivapostgres@yahoo.com) wrote:

HiCan u suggest a good backup solution for a windows installation ?  Looks like the suggested two [ pgbarman, pgbackrest ] works only in Linux.

While it's certainly something we'd like to do, we haven't ported
pgbackrest to Windows yet. That said, it's now entirely written in
reasonably portable C and so it shouldn't be too much effort to port it.

Until that's done though, and I can't say exactly when that port will
happen, your best option is probably pg_basebackup.

Of course, I'd strongly recommend you consider running PG on Linux
instead, particularly for a production environment.

Thanks,

Stephen

On 24/2/20 4:18 pm, Dor Ben Dov wrote:

Hi All,

 

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)

This is the THIRD time you've asked the same question with minimal
rephrasing, and without clarifying details:

/messages/by-id/AM0PR06MB4817A7035134FD88B2C1D033CC550@AM0PR06MB4817.eurprd06.prod.outlook.com

/messages/by-id/AM0PR06MB4817DD9C64FE02410478DF65CC280@AM0PR06MB4817.eurprd06.prod.outlook.com

If you weren't satisfied with the answers you got the first two times,
kindly be clear about what you're really looking for. Thanks much!

--
Best Regards,
Adrian

We do have plans to move to Linux in the future after the successful implementation of at least 4 or 5 projects.  Till then we want to keep windows. We were (are) using SQL Server (also) and this is our first one with Postgres.   With our manpower, we feel tough to switch two things (Database & OS) at a time.  
We'll be using either pg_basebackup or pg_dump, as suitable, till we find a good backup solution.

On Tuesday, 25 February, 2020, 07:24:00 pm IST, Stephen Frost <sfrost@snowman.net> wrote:

Greetings,

* sivapostgres@yahoo.com (sivapostgres@yahoo.com) wrote:

  HiCan u suggest a good backup solution for a windows installation ?  Looks like the suggested two [ pgbarman, pgbackrest ] works only in Linux.

While it's certainly something we'd like to do, we haven't ported
pgbackrest to Windows yet.  That said, it's now entirely written in
reasonably portable C and so it shouldn't be too much effort to port it.

Until that's done though, and I can't say exactly when that port will
happen, your best option is probably pg_basebackup.

Of course, I'd strongly recommend you consider running PG on Linux
instead, particularly for a production environment.

Thanks,

Stephen

sivapostgres@yahoo.com schrieb am 25.02.2020 um 02:55:

Can u suggest a good backup solution for a windows installation ?
Looks like the suggested two [ pgbarman, pgbackrest ] works only in
Linux.

pg_probackup provides Windows binaries: https://github.com/postgrespro/pg_probackup/