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 CALXoLqy_CNpjSEAuW3mrSMQs3Sy8rTN-Y2fuA2bwRYydggk3AA@mail.gmail.com
Whole thread Raw
In response to Re: pg_basebackup Compression Problem  (Ankur Kaushik <ankurkaushik@gmail.com>)
Responses Re: pg_basebackup Compression Problem  (Ankur Kaushik <ankurkaushik@gmail.com>)
List pgsql-admin
Tree view

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@gmail.com> 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@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: Ankur Kaushik
Date:
Subject: Re: pg_basebackup Compression Problem
Next
From: Ankur Kaushik
Date:
Subject: Re: pg_basebackup Compression Problem