Re: Postgresql 17 incremental backup

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Mauricio Fernandez <mmauricio(dot)fernandez(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Postgresql 17 incremental backup
Date: 2025-01-06 20:10:01
Message-ID: CAECtzeU81ngoyRAiFu=_8bDD1P599FVc4Ht6W4kdDU_Ap2auVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mauricio Fernandez 2025-01-06 20:30:06 Re: Postgresql 17 incremental backup
Previous Message Mauricio Fernandez 2025-01-06 20:07:26 Re: Postgresql 17 incremental backup