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 1sm7AK-003LrJ-Nd for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 07:44:29 +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 1sm7AJ-005WJt-9g for pgsql-admin@arkaria.postgresql.org; Thu, 05 Sep 2024 07:44:27 +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 1sm7AI-005WJl-TO for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 07:44:27 +0000 Received: from mail-pj1-x102e.google.com ([2607:f8b0:4864:20::102e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sm7AH-000FZ9-3z for pgsql-admin@lists.postgresql.org; Thu, 05 Sep 2024 07:44:26 +0000 Received: by mail-pj1-x102e.google.com with SMTP id 98e67ed59e1d1-2d8881850d9so359196a91.3 for ; Thu, 05 Sep 2024 00:44:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=bitnine-net.20230601.gappssmtp.com; s=20230601; t=1725522262; x=1726127062; 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=q8SWce5t92nc5Ra639AsGp6rXgZdCMFEFqBYJKXJTjQ=; b=HGrwApF18fNEXUdgAFcOcwXt1CEY+zCxtzTzR+6PBzu6SyBcZ9FbmtIq4y4uZ43dG7 F2vWn0qmum34a+VwQKxZ0eJCpY6u90NI9cQQlyY15lEPzfrKUrzZjhxle5BUEIl6AoKR 0AHCZduVLu/35oktH+2fMcVEZL12vklNgkc/0N6O7M3qrBTCQkUE0r3o7r4laMvv0gUk 6uOTERraazq1ApXEOyq3ExsIr2I68eS+e9wXjNFR1SVCR6mnVIdqVVRtcalUMkMtob3B gGRvk/rjp0/S5alp8YvjEI9B9ylVKE/C8YIRnt+ilidC+wdAPHHcH4PfkysW9mR8pWjB 54zQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1725522262; x=1726127062; 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=q8SWce5t92nc5Ra639AsGp6rXgZdCMFEFqBYJKXJTjQ=; b=ZgHjRW2zE+Ycxtvo3rrpqzp5ciZokTMji5IKbDgJk2UcCdpkzE3djJUpfttC9D555I bB8K7q8Je1aBATFjbMXGKTu695beSzZX8/xPbtL56tqCv9wXeZLAG52qRi9PQEV5mOwH O9ZPRyTe9mG3BaD8v37ClMmKoMNZgX8gL+q7KIoAhwuSsQ1LGWp70UvDP7BCNMEOvk9I KL7bM8QS+nF1hv2wWcZ5HDSytWTb1rbNvCP5rWdum79vFiEwh9h6UozYPJQ4tV7CaKg9 H/ORjusZiubtEtfNM0xKM/797ZZ36fOuZlnj2HzeVGRjctgoa8eAbQXFBdFDEsCCz2Ea 0G3g== X-Gm-Message-State: AOJu0YxrxDVRZy3SoWHkzgnytArgnuglZtaPXJnnRSLYpmhFSDOuXHha yIezrMVcnj+KMnt0gCmAhI5jN8rQOyYwP+P8oQQMl5j9rlzsds4mZn8dY2w6APiM8djCpoZMATt +e7qWJM+UyAIL4Omn6/AVu2hlvJwCCtbLt143+g== X-Google-Smtp-Source: AGHT+IF/KATx7BGvrghwZ2jVMGOMZ9H6h2BpzCV3jA7Zbcjc2NQgyEeA5ZDFY0GPxqpTf0lJrh7UpRD50zNnGvlLsqk= X-Received: by 2002:a17:90a:8c02:b0:2d8:a744:a820 with SMTP id 98e67ed59e1d1-2da6344cfedmr8644060a91.36.1725522262196; Thu, 05 Sep 2024 00:44:22 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Muhammad Usman Khan Date: Thu, 5 Sep 2024 12:44:11 +0500 Message-ID: Subject: Re: pg_basebackup: error: could not create directory To: Samir Mamun Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000007da34606215a7557" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007da34606215a7557 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi, Kindly check if the destination directory is empty and if not then first clear the directory and then run the command again. On Thu, 5 Sept 2024 at 12:40, Samir Mamun wrote: > Hi, > > > > Need help with replication setup, pg_basebackup failing with: > > > > pg_basebackup -P -R -X stream -c fast -h -U -p > -D -v > > Password: > > pg_basebackup: initiating base backup, waiting for checkpoint to complete > > pg_basebackup: checkpoint completed > > pg_basebackup: write-ahead log start point: 6/67000028 on timeline 2 > > pg_basebackup: starting background WAL receiver > > pg_basebackup: created temporary replication slot "pg_basebackup_3720137" > > pg_basebackup: error: could not create directory "=E2=80=A6=E2=80=A6": Fi= le exists > > pg_basebackup: removing contents of data directory "=E2=80=A6=E2=80=A6=E2= =80=A6=E2=80=A6" > > pg_basebackup: changes to tablespace directories will not be undone > > > > > > > > Kind Regards > > Samir > IMPORTANT NOTE: FUJIFILM Business Innovation Corp.'s and its affiliates' > email transmission, including any attachments, is private and confidentia= l > and may contain legally privileged information. It is for the addressee's > attention only. If you are not the intended recipient and have received > this transmission, you must not use, edit, print, copy or disclose its > contents to any person or disseminate the information contained herein or > hereto attached, and you must notify sender immediately by return email a= nd > delete this transmission from your system. Any confidentiality, privilege > or copyright is not waived or lost because this e-mail has been sent to y= ou > in error. We have used reasonable efforts to protect this transmission fr= om > computer viruses and other malicious software, but no warranty is made an= d > the sender takes no responsibility for any loss or damage incurred from > using this email or the information contained in this email. > --0000000000007da34606215a7557 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Hi,
Kindl= y check if the destination directory is empty and if not then first clear t= he directory and then run the command again.



On Thu, 5 Sep= t 2024 at 12:40, Samir Mamun <samir.mamun.sn@fujifilm.com> wrote:

Hi,

=C2=A0<= /span>

Need help with replic= ation setup, pg_basebackup failing with:

=C2=A0<= /span>

pg_basebackup -P -R -= X stream -c fast -h <node_name> -U <user_name> -p <port#>= -D =C2=A0<dat_location> -v

Password:

pg_basebackup: initia= ting base backup, waiting for checkpoint to complete

pg_basebackup: checkp= oint completed

pg_basebackup: write-= ahead log start point: 6/67000028 on timeline 2

pg_basebackup: starti= ng background WAL receiver

pg_basebackup: create= d temporary replication slot "pg_basebackup_3720137"

pg_basebackup: error:= could not create directory "=E2=80=A6=E2=80=A6": File exists<= /u>

pg_basebackup: removi= ng contents of data directory "=E2=80=A6=E2=80=A6=E2=80=A6=E2=80=A6&qu= ot;

pg_basebackup: change= s to tablespace directories will not be undone

=C2=A0<= /span>

=C2=A0<= /span>

=C2=A0<= /span>

Kind Rega= rds

Samir

IMPORTANT NOTE: FUJIFILM Business Innovation Corp.'s and its affiliates= ' email transmission, including any attachments, is private and confide= ntial and may contain legally privileged information. It is for the address= ee's attention only. If you are not the intended recipient and have rec= eived this transmission, you must not use, edit, print, copy or disclose it= s contents to any person or disseminate the information contained herein or= hereto attached, and you must notify sender immediately by return email an= d delete this transmission from your system. Any confidentiality, privilege= or copyright is not waived or lost because this e-mail has been sent to yo= u in error. We have used reasonable efforts to protect this transmission fr= om computer viruses and other malicious software, but no warranty is made a= nd the sender takes no responsibility for any loss or damage incurred from = using this email or the information contained in this email.
--0000000000007da34606215a7557--