Re: pg_basebackup Compression Problem

Postgres Version : psql (PostgreSQL) 9.4.8

On Wed, Dec 20, 2017 at 1:24 PM, Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
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(at)gmail(dot)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(at)keithf4(dot)com> wrote:
>>
>>>
>>> On Wed, Dec 20, 2017 at 2:33 AM, Ankur Kaushik <ankurkaushik(at)gmail(dot)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
>>>
>>
>>
>