Re: pg_basebackup Compression Problem

[Ankur Kaushik <ankurkaushik@xxxxxxxxx>]

Postgres Version : psql (PostgreSQL) 9.4.8

On Wed, Dec 20, 2017 at 1:24 PM, Ankur Kaushik <ankurkaushik@xxxxxxxxx> wrote:

Storage Location is fine :

/dev/sda3       451G  258G  170G  61% /

tmpfs           3.9G  228K  3.9G   1% /dev/shm

/dev/sda1       190M  104M   76M  58% /boot

On Wed, Dec 20, 2017 at 1:22 PM, Ankur Kaushik <ankurkaushik@xxxxxxxxx> wrote:

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@xxxxxxxxxxx> wrote:

On Wed, Dec 20, 2017 at 2:33 AM, Ankur Kaushik <ankurkaushik@xxxxxxxxx> 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