Re: Postgresql 17 incremental backup

public inbox for [email protected]  
help / color / mirror / Atom feed

From: Mauricio Fernandez <[email protected]>
To: Guillaume Lelarge <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: Postgresql 17 incremental backup
Date: Mon, 6 Jan 2025 17:30:06 -0300
Message-ID: <CAMdfv4Ut6o=BBMCz=B8D_oUai9rFhurBxfKrDccG+Dp_zDAe_A@mail.gmail.com> (raw)
In-Reply-To: <CAECtzeU81ngoyRAiFu=_8bDD1P599FVc4Ht6W4kdDU_Ap2auVg@mail.gmail.com>
References: <CAMdfv4WBiMMEwc2JiMcgBctQETOFDUtaODZvUy4FvLVZrRZV6A@mail.gmail.com>
	<CAECtzeXxEWKcoOD_+Cu80FDEBJ45f7P7SMO52_pusT7ZEESdQw@mail.gmail.com>
	<CAMdfv4Vw_EYJhmGddd6UD728nbpb0oY3vUkorVqG961JLFTXbA@mail.gmail.com>
	<CAECtzeVVyMd2fUhQNMVM=ekO+X0fjdCARt3perWyGiOQu3C6Pw@mail.gmail.com>
	<CAMdfv4XUGDr8B2yJEAF968SLr5ThiKF2pf9NAVxpJ=8Ns+2wjg@mail.gmail.com>
	<CAECtzeU81ngoyRAiFu=_8bDD1P599FVc4Ht6W4kdDU_Ap2auVg@mail.gmail.com>

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@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@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 (<[email protected]>)
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 <
> [email protected]> 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@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@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 (<
>> [email protected]>) escribió:
>>
>>> Hi,
>>>
>>> Reply to the list, not only to me.
>>>
>>> Le lun. 6 janv. 2025 à 20:52, Mauricio Fernandez <
>>> [email protected]> 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@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@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 (<
>>>> [email protected]>) escribió:
>>>>
>>>>> Hi,
>>>>>
>>>>> Le lun. 6 janv. 2025 à 20:23, Mauricio Fernandez <
>>>>> [email protected]> a écrit :
>>>>>
>>>>>> Hi admins, I'm trying to execute an incremental backup and I'm
>>>>>> getting the following error
>>>>>>
>>>>>> *[postgres@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.
>

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Postgresql 17 incremental backup
  In-Reply-To: <CAMdfv4Ut6o=BBMCz=B8D_oUai9rFhurBxfKrDccG+Dp_zDAe_A@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox