Re: pg_basebackup --wal-method=fetch

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Feb 8, 2024 at 12:48 PM Magnus Hagander <magnus@xxxxxxxxxxxx> wrote:


On Thu, Feb 8, 2024, 17:05 Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:
(PG 14, if it matters.)

What's the purpose of fetch mode, as opposed to streaming mode?  Is it a legacy of bygone days that just hasn't been deprecated, or is there something I don't understand from reading https://www.postgresql.org/docs/14/app-pgbasebackup.html?



Your backup can go to a single file with it, which it can't do in streaming. Which means it can also be sent through a pipe. 

But isn't the whole purpose of pg_basebackup (running it on Node B, when the database instance is Node A)?
 
It also needs one connection instead of two to the server, if that's limited. 

It's 2024, not 2011.  Who can't spare an extra connection?
 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux