Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_basebackup Compression Problem - Mailing list pgsql-admin

From Ankur Kaushik
Subject Re: pg_basebackup Compression Problem
Date
Msg-id CALXoLqzE5ugNZJ6GPNQECetvO1nFqpKJ=jJ=Ep=qtn8wh1bGdg@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup Compression Problem  (Keith <keith@keithf4.com>)
Responses Re: pg_basebackup Compression Problem  (Ankur Kaushik <ankurkaushik@gmail.com>)
Re: pg_basebackup Compression Problem  (Magnus Hagander <magnus@hagander.net>)
List pgsql-admin
Tree view

OS Config : 

Linux  2.6.32-573.12.1.el6.i686 #1 SMP Tue Dec 15 18:25:17 UTC 2015 i686 i686 i386 GNU/Linux

CentOS release 6.7 (Final)
Kernel \r on an \m

When We do with manual gzip to to generated tar it works but problem when we do with pg_basebackup


On Wed, Dec 20, 2017 at 1:17 PM, Keith <keith@keithf4.com> wrote:

On Wed, Dec 20, 2017 at 2:33 AM, Ankur Kaushik <ankurkaushik@gmail.com> wrote:

Facing problem in taking pg_basebackup . 

File Reaches till 2 GB then failes and give below error

pg_basebackup: could not write to compressed file "/backup//base.tar.gz": File too large

Command : 

pg_basebackup -h127.0.0.1 -U base_backup_user -D /backup/inc_backup -Ft -z -P
 

Are you writing the backup to a FAT32 file system? Those have a max individual file size limit of about 2GB.

Keith

pgsql-admin by date:

Previous
From: Shreeyansh Dba
Date:
Subject: Re: pg_basebackup Compression Problem
Next
From: Ankur Kaushik
Date:
Subject: Re: pg_basebackup Compression Problem