pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Wells Oliver <wells.oliver@gmail.com>
Cc: Mladen Gogala <gogala.mladen@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: PG_Base Backup take 8 to 9Hrs
Date: Thu, 10 Feb 2022 10:16:14 -0500
Message-ID: <c8874d97-f835-d8f6-4a20-57f9d6c0ebdf@sqlexec.com> (raw)
In-Reply-To: <CAOC+FBUggZCL+xGkbqUW1s0GD=CwcdRKNRfoH6HFrgdqH-kgHw@mail.gmail.com>
References: <KL1PR0601MB44331141771E87939CAB3B91F02D9@KL1PR0601MB4433.apcprd06.prod.outlook.com>
	<91f9d08c-fb4b-5847-4663-e96994c1f460@gmail.com>
	<627d342b-6054-bb08-86d0-15c0a8e58887@sqlexec.com>
	<CAOC+FBUggZCL+xGkbqUW1s0GD=CwcdRKNRfoH6HFrgdqH-kgHw@mail.gmail.com>

Just keep in mind that logical dumps and loads do not support Point In 
Time Recovery (PITR).

Wells Oliver wrote on 2/10/2022 9:36 AM:
> Can you just try good ole pg_dump with --format=directory and --jobs=X 
> where X is some decent number, e.g. 16? We just packed up a 700GB DB 
> using 16 jobs and it took maybe 80 minutes.






view thread (11+ messages)  latest in thread

Message-ID: <c8874d97-f835-d8f6-4a20-57f9d6c0ebdf@sqlexec.com>
Permalink:  ../c8874d97-f835-d8f6-4a20-57f9d6c0ebdf@sqlexec.com/
Also on:    postgresql.org/message-id/c8874d97-f835-d8f6-4a20-57f9d6c0ebdf@sqlexec.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: MichaelDBA@sqlexec.com, wells.oliver@gmail.com, gogala.mladen@gmail.com, pgsql-admin@lists.postgresql.org
  Subject: Re: PG_Base Backup take 8 to 9Hrs
  In-Reply-To: <c8874d97-f835-d8f6-4a20-57f9d6c0ebdf@sqlexec.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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