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 1tUtk1-003fNG-2t for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 20:30:25 +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 1tUtjz-00CUSx-CB for pgsql-admin@arkaria.postgresql.org; Mon, 06 Jan 2025 20:30:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tUtjy-00CUSp-TQ for pgsql-admin@lists.postgresql.org; Mon, 06 Jan 2025 20:30:22 +0000 Received: from mail-ua1-x934.google.com ([2607:f8b0:4864:20::934]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tUtjv-000Dmw-27 for pgsql-admin@lists.postgresql.org; Mon, 06 Jan 2025 20:30:22 +0000 Received: by mail-ua1-x934.google.com with SMTP id a1e0cc1a2514c-85c436db302so7181983241.0 for ; Mon, 06 Jan 2025 12:30:19 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1736195418; x=1736800218; 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=YXie6uYNUqMZFvcid2Ywmg5/qBpSKasVjLlmGaYAd34=; b=cjEMa2tQaK4Z55CL/zsZl6sstl3NXnnmNT2+JCnYbRurM9v44s7Liwc5KBWhCCMwOa lc5evB+uu67Z55icVQQMDIwZ4p+ozfTyk+sLX/zr2Ys0DplZ3lYcU40bd521DfXp5RxQ 4bf0G2s3oG7xYW2GKFToY0vF8/5LsXSazqkqm5+xQD5baQbj4ZeabMaNzgpG32lgyiYF SbQubceORXzQK8qFxJT+RnrDtd8tFaLJoSiDRKW4LRcQSPLVcIyZF/Jr4cLFIQJx9h1B jTUMd4+Op4a544+UB3YV61YRhxw49pvt7C1uPPMGzjJQFU1HP+riPwMERkOA5/bhbxj3 DtiQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1736195418; x=1736800218; 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=YXie6uYNUqMZFvcid2Ywmg5/qBpSKasVjLlmGaYAd34=; b=VEoAaMtEMjHWmCEmzkNmY1wiA3AG2rRF6/zobVHReqqEjzfX2349mPxpcVt0QKR/JF d8aqZS71wn9n2yBtIy51yPlKyqBsSbaBHzV3v8A5NgHuuyK9TQJ6IT9j3xIGqTgA6sNc ErwnD0qsF0+SG6mx+wN//0FZxghXyQi+qCb0XOF21GCfY4RORDUwEyuAPxD5FoZHMbWB XfL6D0GztLCOq2TRwORbcCFFV9zXVGM3kBBmleQcoMy+/XJbZ6GDSkA+84eqs4+99GC8 TpuYQ/DQfaUSuKqvQJjP7zQZmZigdFM8gHeTZUpVQeUp6XD1Eso+s9ng14vKtNeZZt5+ Dc3Q== X-Gm-Message-State: AOJu0YyrGCaV9XpRiYGgGfIdPdZXGy62wlMb3wXFeMIO+PVK35TFOgoK 028cPgLxI/qGTGxjAfFTFW3tohFwd1PFG8Y2x/z2/2PBO324fvDTU5fp5NCMBuUxW2k0iEP4Xeh U+QYzKhyYmwA4TvoljEPGFphFtAVcxoHQ X-Gm-Gg: ASbGncsg0wosES6tKwaHW5T44AYmCy6z7xFZlX8AruXNp/UQxBgc4DNb+icGdIrzg/w i52VWo9ACVqRZsSmOYOe+1b4miKuuTrVw0sHDSiM9ii57jXU2lsabDeZGBuf71VvVKo4= X-Google-Smtp-Source: AGHT+IG1aW8ClM6Kr73+Wza65Sj8vC86Db/qpJR/2j3H3vYbCjdQvJv+U9eNz3/W/SxVIpa4lLA3sdyv+a42wZY19eY= X-Received: by 2002:a05:6102:38cb:b0:4b1:6e7:afa0 with SMTP id ada2fe7eead31-4b3c1e589c1mr752593137.5.1736195417897; Mon, 06 Jan 2025 12:30:17 -0800 (PST) MIME-Version: 1.0 References: In-Reply-To: From: Mauricio Fernandez Date: Mon, 6 Jan 2025 17:30:06 -0300 X-Gm-Features: AbW1kvYmJ-CXC4enRuUJrrMjwmhwUqkVHFTeN6wQd3Exj1RYQpe3_0ljnMjYyr4 Message-ID: Subject: Re: Postgresql 17 incremental backup To: Guillaume Lelarge Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000002501b3062b0f7f75" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000002501b3062b0f7f75 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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$PGBKP/= fisicos/viernes/tbs_laboratorio_02 \ > --tablespace-mapping=3D/var/lib/pgsql/datos/17/tbs_recetas=3D$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 (= ) escribi=C3=B3: > 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 i= s > 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-incremental >> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest >> >> pg_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3=B3rd= enes (el >> primero es =C2=AB=E2=80=93-incremental=C2=BB) >> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para may= or >> 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=B3rd= enes (el >> primero es =C2=AB=E2=80=93i=C2=BB) >> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para may= or >> 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. I= n >>>> both cases without "=3D" >>>> >>>> [postgres@buda viernes]$ pg_basebackup -c fast -P -D >>>> /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93-increment= al >>>> /var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manifest >>>> >>>> pg_basebackup: error: demasiados argumentos en la l=C3=ADnea de =C3=B3= rdenes (el >>>> primero es =C2=AB=E2=80=93-incremental=C2=BB) >>>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para m= ayor >>>> 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=B3= rdenes (el >>>> primero es =C2=AB=E2=80=93i=C2=BB) >>>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para m= ayor >>>> informaci=C3=B3n. >>>> >>>> >>> 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@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/fis= icos/base_tar/backup_manifest=C2=BB) >>>>>> pg_basebackup: consejo: Pruebe =C2=ABpg_basebackup --help=C2=BB para= 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/fis= icos/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 ri= d of >>>>> the equal value. Maybe it will help. >>>>> >>>>> >>>>> -- >>>>> Guillaume. >>>>> >>>> >>> >>> -- >>> Guillaume. >>> >> > > -- > Guillaume. > --0000000000002501b3062b0f7f75 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I really did what you implied, but I tried=C2=A0copy/paste= your example and it's show=C2=A0me another error, about an directory n= ot empty.

Then I remember=C2=A0some troubles trying to m= ake a base backup because I have two extra tablespace, and this works fine<= /div>

[postgres@buda viernes]$ 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 \
&= gt; --tablespace-mapping=3D/var/lib/pgsql/datos/17/tbs_laboratorio_02=3D$PG= BKP/fisicos/viernes/tbs_laboratorio_02 \
> --tablespace-mapping=3D/va= r/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 th= e "--"=C2=A0 like you said. Too much copy/paste I think

Thank you very much for your help

= Kind regards=C2=A0

MF
=C2=A0

El lun, 6 ene 2025 a las 17:10, Guillaume Lelarge (<= guillaume@lelarge.info>) e= scribi=C3=B3:
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 t= he good one. Try (by copy/paste):

pg_basebackup -c= fast -P -D /var/lib/pgsql/17/backups/devadv01/fisicos/viernes --incrementa= l =C2=A0/var/lib/pgsql/17/backups/devadv01/fisicos/base_plano/backup_manife= st


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

Hi Guillaume, thanks for the = answer.

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

[postgres@buda viernes]$ pg_basebackup -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: demasiados argumentos en la l=C3=AD= nea 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 in= formaci=C3=B3n.

[postgres@buda viernes]$ pg_basebackup -c fast -P -D= /var/lib/pgsql/17/backups/devadv01/fisicos/viernes =E2=80=93i /var/lib/pgs= ql/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_baseb= ackup --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 list, not only to = me.

Le=C2=A0lun. 6 janv. 2025 =C3=A0=C2=A020:52, Mauricio Fernande= z <mm= auricio.fernandez@gmail.com> a =C3=A9crit=C2=A0:
Hi Guillaume, than= ks for the answer.

I've tried with -i and --incremen= tal , 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.


I've tried your= command line, and I have the same error. The minus sign is not the good on= e. 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@lelarge.info&g= t;) escribi=C3=B3:
Hi,

Le=C2=A0lun. 6 janv. 2025 =C3= =A0=C2=A020:23, Mauricio Fernandez <mmauricio.fernandez@gmail.com> a =C3= =A9crit=C2=A0:
<= div dir=3D"ltr">Hi admins, I'm trying to execute an incremental backup = and I'm getting the following error

[postgres@bud= a ~]$ pg_basebackup -c fast -P -D $PGBKP/fisicos/viernes =E2=80=93-incremen= tal=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/fisico= s/base_tar/backup_manifest=C2=BB)
pg_basebackup: consejo: Pruebe =C2=ABp= g_basebackup --help=C2=BB para mayor informaci=C3=B3n.

=
The literal translation of the error message is: pg_basebac= kup: error: too many arguments in the command line (the first is =C2=AB=E2= =80=93-incremental=3D/var/lib/pgsql/17/backups/devadv01/fisicos/base_tar/ba= ckup_manifest=C2=BB)

<= div>
It looks like it thinks that=C2=A0 "--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 rid of= the equal value. Maybe it will help.


--
Guillaume.


--
Guillaume.
<= /div>


--
Guillaume.
<= /div>
--0000000000002501b3062b0f7f75--