Hi Dirk,
Yes, this will work fine. You can use the existing backup to restore it on
the new node and use the WAL archives from new node for the recovery
purpose. As a best practice, I would suggest setting the parameter
"recovery_target_timeline=latest" in your recovery command to ensure the
recov
On 7/13/20 7:37 PM, Adrian Klaver wrote:
On 7/13/20 2:56 PM, Ron wrote:
On 7/13/20 2:32 PM, Adrian Klaver wrote:
On 7/13/20 12:12 PM, Julie Nishimura wrote:
Hello there,
One of our PostgreSQL 9.4.1 databases has been backed up as *.gz file
with the compression 9 "pg_dump -Z 9". What is the r
On 7/13/20 2:56 PM, Ron wrote:
On 7/13/20 2:32 PM, Adrian Klaver wrote:
On 7/13/20 12:12 PM, Julie Nishimura wrote:
Hello there,
One of our PostgreSQL 9.4.1 databases has been backed up as *.gz
file with the compression 9 "pg_dump -Z 9". What is the right format
of restore this file when nee
On 7/13/20 2:32 PM, Adrian Klaver wrote:
On 7/13/20 12:12 PM, Julie Nishimura wrote:
Hello there,
One of our PostgreSQL 9.4.1 databases has been backed up as *.gz file
with the compression 9 "pg_dump -Z 9". What is the right format of
restore this file when needed? Can I run the restore from
On 7/13/20 12:12 PM, Julie Nishimura wrote:
Hello there,
One of our PostgreSQL 9.4.1 databases has been backed up as *.gz file
with the compression 9 "pg_dump -Z 9". What is the right format of
restore this file when needed? Can I run the restore from a compressed
file or I need to unzip the
sivapostg...@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/
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 &
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
Greetings,
* sivapostg...@yahoo.com (sivapostg...@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
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
wrote:
Greetings,
* Dor Ben Dov (dor.ben-...@amdocs.com) wrote:
> What is your
Greetings,
* Dor Ben Dov (dor.ben-...@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
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
12 matches
Mail list logo
