Re: Postgresql 17 incremental backup

Le lun. 6 janv. 2025 à 21:30, Mauricio Fernandez <
mmauricio(dot)fernandez(at)gmail(dot)com> a écrit :

> 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
>
>
You're welcome. Happy to know it works for you now :)

> 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.
>>
>

--
Guillaume.