Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUtoA-003g6y-0D for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 20:34:42 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tUto9-00CZ34-97 for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 20:34:40 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUto8-00CZ2v-M5 for pgsql-admin@lists.postgresql.org; Mon, 06 Jan 2025 20:34:40 +0000 Received: from mail-qv1-xf29.google.com ([2607:f8b0:4864:20::f29]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tUto6-000Cyr-03 for pgsql-admin@lists.postgresql.org; Mon, 06 Jan 2025 20:34:39 +0000 Received: by mail-qv1-xf29.google.com with SMTP id 6a1803df08f44-6d89a727a19so139448516d6.0 for ; Mon, 06 Jan 2025 12:34:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=lelarge-info.20230601.gappssmtp.com; s=20230601; t=1736195677; x=1736800477; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=jGJvn1paC1mfNlzHy6LMLa9p4FFyEY/GHVhNGpGTfpk=; b=meX5Ad40+7hs+mLKmwLTuOyFe1WeBJNiCU31T78kP9JiGyZbm9cJYWKzRjrGuxqCiC LTL3rHhZaPmVOjwkEBaYu8dOHtJncYAnUu8fQhv/qnIGPBAuictq20Hiwe/DxkOXP8uo s0muRQCgU8+XOWygEy6U7pt6YNrn3XQVAj7lpbJ4HqAlQmFJKGbIjc7o9ckpYJc7482l qTWq8Hc9vnbLE4CrDKthXKjUe1OKaLznjvMUlXhoV/viPENIXapWmp0ByME6DVQRrFDf 6cys/1llmtJXNAAtbJTMot03rjJKUR3/DFcWLjJVRivhb2OoIKFCGSUjnfwPALbC+Jt1 immg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736195677; x=1736800477; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=jGJvn1paC1mfNlzHy6LMLa9p4FFyEY/GHVhNGpGTfpk=; b=hct8DhATej71NbToVhN++xXZjPdLM6uqKKbyzPZZY9yqVNa+Vg98btYVk918YJlB5N 3twgZPf6K06KqZ1W05cLaH0ZrQVqFQoRfCeAJszPbzpOlX2bAnJwm/gB7peKdJc+yAll grkAmJ9d1kjBFgHzn0xWA3NCXYdycyRRUDb6ZwkKZ4WrwlWVCZzSdSnPAYcL+fhNasL4 y1UbRmmxpqMKGRGkS65gOuvP8GBdtEZoQG0gGY+0Fsk71KHEA24xcO1/UGX0tYvpXKWm hSiLSOfWczySyhidukBkpREIvIoYdBWpe5DdZpIfzBxlbkWSQ1ocgVOrwyc94uRr0ZYJ STIA== X-Gm-Message-State: AOJu0YyNY6NeFFY+AM4rKeuckcM9EVkNELbelRvgDnqhim7wVpQL2YEw GxSyYN/FCoCrUuAEjPMEkTDPUvo1nfRvrZfGj6jT92GGRTFmoZ6XOw5fJL1ZkbRONZxVRzTq1+F x6Qsm49dRpYGge0gXnA9kPYmFI0lfrnlfvef5nQ== X-Gm-Gg: ASbGncsvQ44GobtFTLlHALYjf47Nj40s7Aj+AavyIgp4bmDTTlwhwOaDI+9oKww7DSF eL8Wk5svVIiMgQ+pUANO9cydIpYV91oFEQaeqJOc= X-Google-Smtp-Source: AGHT+IH5Bwp/PsQyMy9yesOKvpyrWbm9DJbf3YyQSXswqpEBYdfHgA3JY38krZV2ON/HWYj4FQljZav678+ZjvqQNSU= X-Received: by 2002:ad4:5969:0:b0:6d9:162a:27a2 with SMTP id 6a1803df08f44-6df8e89a962mr9901266d6.21.1736195677490; Mon, 06 Jan 2025 12:34:37 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Guillaume Lelarge Date: Mon, 6 Jan 2025 21:34:27 +0100 Message-ID: Subject: Re: Postgresql 17 incremental backup To: Mauricio Fernandez Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000009e2175062b0f8ebb" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000009e2175062b0f8ebb Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Le lun. 6 janv. 2025 =C3=A0 21:30, Mauricio Fernandez < mmauricio.fernandez@gmail.com> a =C3=A9crit : > 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=3D/var/lib/pgsql/datos/17/tbs_laboratorio_02=3D$PGBK= P/fisicos/viernes/tbs_laboratorio_02 > \ > > > --tablespace-mapping=3D/var/lib/pgsql/datos/17/tbs_recetas=3D$PGBKP/fisic= os/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 > > 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 () > escribi=C3=B3: > >> Have you read what I said inline? Doesn't look like you did, so I'll cop= y >> 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 =C3=A0 21:07, Mauricio Fernandez < >> mmauricio.fernandez@gmail.com> a =C3=A9crit : >> >>> 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 "=3D" >>> >>> [postgres@buda viernes]$ pg_basebackup -c fast -P -D >>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93-incrementa= l >>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest >>> >>> pg_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3=B3r= denes (el >>> primero es =C2=AB=E2=80=93-incremental=C2=BB) >>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para ma= yor >>> informaci=C3=B3n. >>> >>> [postgres@buda viernes]$ pg_basebackup -c fast -P -D >>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93i >>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest >>> pg_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3=B3r= denes (el >>> primero es =C2=AB=E2=80=93i=C2=BB) >>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para ma= yor >>> informaci=C3=B3n. >>> >>> regards >>> >>> MF >>> >>> El lun, 6 ene 2025 a las 17:01, Guillaume Lelarge (< >>> guillaume@lelarge.info>) escribi=C3=B3: >>> >>>> Hi, >>>> >>>> Reply to the list, not only to me. >>>> >>>> Le lun. 6 janv. 2025 =C3=A0 20:52, Mauricio Fernandez < >>>> mmauricio.fernandez@gmail.com> a =C3=A9crit : >>>> >>>>> Hi Guillaume, thanks for the answer. >>>>> >>>>> I've tried with -i and --incremental , and the results are the same. >>>>> In both cases without "=3D" >>>>> >>>>> [postgres@buda viernes]$ pg_basebackup -c fast -P -D >>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93-incremen= tal >>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifes= t >>>>> >>>>> pg_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3= =B3rdenes (el >>>>> primero es =C2=AB=E2=80=93-incremental=C2=BB) >>>>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para = mayor >>>>> informaci=C3=B3n. >>>>> >>>>> [postgres@buda viernes]$ pg_basebackup -c fast -P -D >>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93i >>>>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest >>>>> pg_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3= =B3rdenes (el >>>>> primero es =C2=AB=E2=80=93i=C2=BB) >>>>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para = mayor >>>>> informaci=C3=B3n. >>>>> >>>>> >>>> I've tried your command line, and I have the same error. The minus sig= n >>>> 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@lelarge.info>) escribi=C3=B3: >>>>> >>>>>> Hi, >>>>>> >>>>>> Le lun. 6 janv. 2025 =C3=A0 20:23, Mauricio Fernandez < >>>>>> mmauricio.fernandez@gmail.com> a =C3=A9crit : >>>>>> >>>>>>> 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 >>>>>>> =E2=80=93-incremental=3D$PGBKP/fisicos/base_plano/backup_manifest* >>>>>>> pg_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3= =B3rdenes >>>>>>> (el primero es >>>>>>> =C2=AB=E2=80=93-incremental=3D/var/lib/pgsql/17/backups/devadv01/fi= sicos/base_tar/backup_manifest=C2=BB) >>>>>>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB par= a mayor >>>>>>> informaci=C3=B3n. >>>>>>> >>>>>>> *The literal translation of the error message is: pg_basebackup: >>>>>>> error: too many arguments in the command line (the first is >>>>>>> =C2=AB=E2=80=93-incremental=3D/var/lib/pgsql/17/backups/devadv01/fi= sicos/base_tar/backup_manifest=C2=BB)* >>>>>>> >>>>>>> >>>>>> It looks like it thinks that >>>>>> "--incremental=3D/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar= /backup_manifest" >>>>>> is one argument rather than an argument and its value. Try getting r= id of >>>>>> the equal value. Maybe it will help. >>>>>> >>>>>> >>>>>> -- >>>>>> Guillaume. >>>>>> >>>>> >>>> >>>> -- >>>> Guillaume. >>>> >>> >> >> -- >> Guillaume. >> > --=20 Guillaume. --0000000000009e2175062b0f8ebb Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Le=C2=A0lun. 6 janv. 2025 =C3=A0=C2=A021:30, = Mauricio Fernandez <mma= uricio.fernandez@gmail.com> a =C3=A9crit=C2=A0:
I really did what y= ou implied, but I tried=C2=A0copy/paste your example and it's show=C2= =A0me another error, about an directory not empty.

Then = I remember=C2=A0some troubles trying to make a base backup because I have t= wo extra tablespace, and this works fine

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

Always the= problem was a misleading character in the "--"=C2=A0 like you sa= id. Too much copy/paste I think

Thank you very muc= h for your help


= You're welcome. Happy to know it works for you now :)
=C2=A0<= br>
Kind regards=C2=A0

MF
= =C2=A0

El lun, 6 ene 2025 a las 17:10, Guillaume Lelarge (<guillaume@lelarge.i= nfo>) escribi=C3=B3:
Have you read what I said inline? Doesn&#= 39;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/vierne= s --incremental =C2=A0/var/lib/pgsql/17/backups/devadv01/fisicos/base_plano= /backup_manifest


Le=C2=A0lun. 6 janv. 2025 =C3=A0= =C2=A021:07, Mauricio Fernandez <mmauricio.fernandez@gmail.com> a =C3=A9c= rit=C2=A0:
Ups, thanks for the warning

Hi Guillaume, th= anks for the answer.

I've tried with -i and --increm= ental , and the results are the same. In both cases without "=3D"= =C2=A0=C2=A0

[postgres@buda viernes]$ pg_basebackup -c fa= st -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93-incre= mental =C2=A0/var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_m= anifest

pg_basebackup: error: demasiados argumentos = en la l=C3=ADnea de =C3=B3rdenes (el primero es =C2=AB=E2=80=93-incremental= =C2=BB)
pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB = para mayor informaci=C3=B3n.

[postgres@buda viernes]$ pg_basebackup = -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93i= /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest
p= g_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3=B3rdenes= (el primero es =C2=AB=E2=80=93i=C2=BB)
pg_basebackup: consejo: Pruebe = =C2=ABpg_basebackup --help=C2=BB para mayor informaci=C3=B3n.

regards

MF
=
El lun= , 6 ene 2025 a las 17:01, Guillaume Lelarge (<guillaume@lelarge.info>) escribi= =C3=B3:
Hi,

Reply to the li= st, not only to me.

Le=C2=A0lun. 6 janv. 2025 =C3=A0=C2=A020:52, = Mauricio Fernandez <mmauricio.fernandez@gmail.com> a =C3=A9crit=C2=A0:
H= i Guillaume, thanks for the answer.

I've tried with = -i and --incremental , and the results are the same. In both cases without = "=3D"=C2=A0=C2=A0

[postgres@buda viernes]$ pg_b= asebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes = =E2=80=93-incremental =C2=A0/var/lib/pgsql/17/backups/devadv01/fisicos/base= _plano/backup_manifest

pg_basebackup: error: demasia= dos argumentos en la l=C3=ADnea de =C3=B3rdenes (el primero es =C2=AB=E2=80= =93-incremental=C2=BB)
pg_basebackup: consejo: Pruebe =C2=ABpg_basebacku= p --help=C2=BB para mayor informaci=C3=B3n.

[postgres@buda viernes]$= pg_basebackup -c fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/vie= rnes =E2=80=93i /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backu= p_manifest
pg_basebackup: error: demasiados argumentos en la l=C3=ADnea = de =C3=B3rdenes (el primero es =C2=AB=E2=80=93i=C2=BB)
pg_basebackup: co= nsejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para mayor informaci=C3=B3n.=


I'= ;ve tried your command line, and I have the same error. The minus sign is n= ot the good one. Try:

pg_basebackup -c fast -P -D = /var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incremental =C2=A0/var= /lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest

=C2=A0
regards

MF=


El lun, 6 ene 2025 a las 16:42, Guillaume Lelarge (<= ;guillaume@lela= rge.info>) escribi=C3=B3:
Hi,

Le=C2=A0lun. 6 ja= nv. 2025 =C3=A0=C2=A020:23, Mauricio Fernandez <mmauricio.fernandez@gmail.com> a =C3=A9crit=C2=A0:



--
Guillaume.


--
Guillaume.
<= /div>


--
Guillaume.
<= /div>


--
Guillaume.
<= /div>
--0000000000009e2175062b0f8ebb--