Re: Postgresql 17 incremental backup

I really did what you implied, but I tried copy/paste your example and it's
show me another error, about an directory not empty.

Then I remember some troubles trying to make a base backup because I have
two extra tablespace, and this works fine

[postgres(at)buda viernes]$ pg_basebackup -c fast -P -D
/var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incremental
/var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest \
>
--tablespace-mapping=/var/lib/pgsql/datos/17/tbs_laboratorio_02=$PGBKP/fisicos/viernes/tbs_laboratorio_02
\
>
--tablespace-mapping=/var/lib/pgsql/datos/17/tbs_recetas=$PGBKP/fisicos/viernes/tbs_recetas
13685/3975886 kB (0%), 3/3 tablespaces
[postgres(at)buda viernes]$

Always the problem was a misleading character in the "--" like you said.
Too much copy/paste I think

Thank you very much for your help

Kind regards

MF

El lun, 6 ene 2025 a las 17:10, Guillaume Lelarge (<guillaume(at)lelarge(dot)info>)
escribió:

> Have you read what I said inline? Doesn't look like you did, so I'll copy
> it here:
>
> I've tried your command line, and I have the same error. The minus sign is
> not the good one. Try (by copy/paste):
>
> pg_basebackup -c fast -P -D
> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incremental
> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
>
>
> Le lun. 6 janv. 2025 à 21:07, Mauricio Fernandez <
> mmauricio(dot)fernandez(at)gmail(dot)com> a écrit :
>
>> Ups, thanks for the warning
>>
>> Hi Guillaume, thanks for the answer.
>>
>> I've tried with -i and --incremental , and the results are the same. In
>> both cases without "="
>>
>> [postgres(at)buda viernes]$ pg_basebackup -c fast -P -D
>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –-incremental
>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
>>
>> pg_basebackup: error: demasiados argumentos en la línea de órdenes (el
>> primero es «–-incremental»)
>> pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor
>> información.
>>
>> [postgres(at)buda viernes]$ pg_basebackup -c fast -P -D
>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –i
>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
>> pg_basebackup: error: demasiados argumentos en la línea de órdenes (el
>> primero es «–i»)
>> pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor
>> información.
>>
>> regards
>>
>> MF
>>
>> El lun, 6 ene 2025 a las 17:01, Guillaume Lelarge (<
>> guillaume(at)lelarge(dot)info>) escribió:
>>
>>> Hi,
>>>
>>> Reply to the list, not only to me.
>>>
>>> Le lun. 6 janv. 2025 à 20:52, Mauricio Fernandez <
>>> mmauricio(dot)fernandez(at)gmail(dot)com> a écrit :
>>>
>>>> Hi Guillaume, thanks for the answer.
>>>>
>>>> I've tried with -i and --incremental , and the results are the same. In
>>>> both cases without "="
>>>>
>>>> [postgres(at)buda viernes]$ pg_basebackup -c fast -P -D
>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –-incremental
>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
>>>>
>>>> pg_basebackup: error: demasiados argumentos en la línea de órdenes (el
>>>> primero es «–-incremental»)
>>>> pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor
>>>> información.
>>>>
>>>> [postgres(at)buda viernes]$ pg_basebackup -c fast -P -D
>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes –i
>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
>>>> pg_basebackup: error: demasiados argumentos en la línea de órdenes (el
>>>> primero es «–i»)
>>>> pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor
>>>> información.
>>>>
>>>>
>>> I've tried your command line, and I have the same error. The minus sign
>>> is not the good one. Try:
>>>
>>> pg_basebackup -c fast -P -D
>>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incremental
>>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
>>>
>>>
>>>
>>>> regards
>>>>
>>>> MF
>>>>
>>>>
>>>> El lun, 6 ene 2025 a las 16:42, Guillaume Lelarge (<
>>>> guillaume(at)lelarge(dot)info>) escribió:
>>>>
>>>>> Hi,
>>>>>
>>>>> Le lun. 6 janv. 2025 à 20:23, Mauricio Fernandez <
>>>>> mmauricio(dot)fernandez(at)gmail(dot)com> a écrit :
>>>>>
>>>>>> Hi admins, I'm trying to execute an incremental backup and I'm
>>>>>> getting the following error
>>>>>>
>>>>>> *[postgres(at)buda ~]$ pg_basebackup -c fast -P -D
>>>>>> $PGBKP/fisicos/viernes
>>>>>> –-incremental=$PGBKP/fisicos/base_plano/backup_manifest*
>>>>>> pg_basebackup: error: demasiados argumentos en la línea de órdenes
>>>>>> (el primero es
>>>>>> «–-incremental=/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar/backup_manifest»)
>>>>>> pg_basebackup: consejo: Pruebe «pg_basebackup --help» para mayor
>>>>>> información.
>>>>>>
>>>>>> *The literal translation of the error message is: pg_basebackup:
>>>>>> error: too many arguments in the command line (the first is
>>>>>> «–-incremental=/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar/backup_manifest»)*
>>>>>>
>>>>>>
>>>>> It looks like it thinks that
>>>>> "--incremental=/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar/backup_manifest"
>>>>> is one argument rather than an argument and its value. Try getting rid of
>>>>> the equal value. Maybe it will help.
>>>>>
>>>>>
>>>>> --
>>>>> Guillaume.
>>>>>
>>>>
>>>
>>> --
>>> Guillaume.
>>>
>>
>
> --
> Guillaume.
>