From: Samir Mamun <samir.mamun.sn@fujifilm.com>
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: pg_basebackup: error: could not create directory
Thread-Topic: pg_basebackup: error: could not create directory
Thread-Index: Adr/ZmbHuh8ZR2saQYiuEflWxL22DQ==
Date: Thu, 5 Sep 2024 07:40:38 +0000
Message-ID: 
 <SY0PR01MB9296C4A820754E1CB0CB0EADD29D2@SY0PR01MB9296.ausprd01.prod.outlook.com>
Accept-Language: en-US
Content-Language: en-US
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?sZw7TRstMjrVuPuPRNtVBjSf1ID981GVpyEK/5hDmnMc+5yyr8CyVaZVDMt6?=
 =?us-ascii?Q?mM+Qu/MFw8Dn9WtCWFSOc7tYFdowFsCJk89qcbcPXlKMc/PB4BngZUQ+INd9?=
 =?us-ascii?Q?dXBJ9BNt56NK+EX+qPpi3SW9rejhb+xzXIp8fg5Ne5vlW3Xh9EWvYqjRrnmD?=
 =?us-ascii?Q?0/tgppJuR/mgcC+Eblx5/h9lbTPQ2fm2tqZbhhrZf6e2odo3SwB8ZJsaUCfN?=
 =?us-ascii?Q?vie2EnrBHskDHNsfddkidVa3vFCBNKWgz01ah6XQteONz8BVgT9P56xIUU5+?=
 =?us-ascii?Q?RtNRyeIoiPsSF1ZJ4LePFQG7TPZOD+yoPu9cLxUfPihdu+pfDzzwr8YR+CHh?=
 =?us-ascii?Q?oES+TX3+pXH2FPbL/xXGBikI4YVZdnC1HfDivQiMsHaU5lNOn3HZZ//J3URv?=
 =?us-ascii?Q?Baz5mmKn05c4KxxlvYVwt9/Vy5ETNV3W+Jn0ldFFyiotldgm3w0HnsgDZOd+?=
 =?us-ascii?Q?MadtxQd6kw8iGpCvzodVRkOX9Ti0zOT3RjE7ZZuRORNniZeOkxaICJfYFrKd?=
 =?us-ascii?Q?xZlrlz6Cj2wjZzr8iQKhglYagfIQQUNY847H+4jnYOSHsTSI8zHsVjxJa0k1?=
 =?us-ascii?Q?wa2zg1XTCetBjk9VWq9Shhq/nVGb70uBFLe06peXfS8G1u6UFQVoYkz7oC3I?=
 =?us-ascii?Q?z31PDFK3FVTfLA/+lR0eiLkvCkqWf9weij1enFtyX7sdBsx4AERdI+rTkrJa?=
 =?us-ascii?Q?2XzPHM99ZKA6xp5BXSLEJxlpbJv8Gy8Gk7U+BWqWmRSw8GNuWnQh01jXEJ/H?=
 =?us-ascii?Q?JaqovZx0J7kB/yrNuk4LMAVtIhUiV5zBCSN0CJr86O92jkYxcDWZ6v7uT/Il?=
 =?us-ascii?Q?3JFpMDYgTs7rmzJWUasmuyPG5xxu43kwIrPLM4nl+3L4rDCMOKNHs3jSLOLT?=
 =?us-ascii?Q?d45kNupPpnR3qQkzmZFecZQM7ZK0VmJ5pMGvSF2F15vdPPh5IykDhgV8lwe/?=
 =?us-ascii?Q?4DrC19mCBNUqdmbm49V+19fJCVGrQViK1M9Z7E2lgRO/65DF8gNTxcHiZr56?=
 =?us-ascii?Q?70GyMDIcPqUv1826p+0XMoxq28BsZF/PDbQL+AwXO0XSLBiD9EmqqtsLJWSb?=
 =?us-ascii?Q?29F3mEjRaeH5aBT+ukzLzYDJXgQqhC+DQylCBqYKn5D007ZiJ1J4c5zJeldL?=
 =?us-ascii?Q?cXU1A8ts3+Joyn+TqenrNIW7q4w6X/ov3VXa16mifGkATv3fVtA9LXZjjfKV?=
 =?us-ascii?Q?SuEpoWWdtdwi0UHjB+0QY7nSocSpFS9pTx71HHJmMjTQtYtbiHjdwreI8BJQ?=
 =?us-ascii?Q?Hr38LpAT56ZIbL9OVqKvYjelJrNJ960SPo1O3927sgn2zg4jzaEQ+I5c/lrU?=
 =?us-ascii?Q?ggf0W0+9wuQEyEHYZVVmw4K9Y+M0v5+odtrfATTWne0nPSS+ZtrTprKZlPF+?=
 =?us-ascii?Q?kJsKhnAT6PB/I690kC0JFeogMtwCBr92GN7Tz/KWS18GQsUMRd9QpKrC4MKJ?=
 =?us-ascii?Q?f4oA2dlOI0lp+8VSaI4EGJH6njBEkU/gtjallazjrGVY6aveX8U+hIM37tG0?=
 =?us-ascii?Q?HV621hHqX8wMGIwbOvDY4RlkqDisqry6d3aNwD7kBCtluIj2PIzp3D977Fw3?=
 =?us-ascii?Q?GlTqPLjP/oU4xd+27FNsXRyH7l7Qz/DbSRql3pX0?=
Content-Type: multipart/alternative;
	boundary="_000_SY0PR01MB9296C4A820754E1CB0CB0EADD29D2SY0PR01MB9296ausp_"
MIME-Version: 1.0
X-OriginatorOrg: fujifilmdms.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: SY0PR01MB9296.ausprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 4248f03c-c298-4a0d-aa67-08dccd7e096e
X-MS-Exchange-CrossTenant-originalarrivaltime: 05 Sep 2024 07:40:38.7376
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 9d3fe9c8-fb68-40e1-9189-2c3b54d5e658
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 HwZVKG473i8+iBeUdh2AkTeHsbvADUBCLh9o3hphKUYOLmHJlfSkMY6o6Kbksr+ld8PMWTJMqWHUd7YEA2GPnw==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY7PR01MB8877
X-Proofpoint-GUID: CJY8C0ZZ6EYyRnfhAAL-VVzK7oW3Y1YW
X-Proofpoint-ORIG-GUID: CJY8C0ZZ6EYyRnfhAAL-VVzK7oW3Y1YW
X-Proofpoint-Virus-Version: vendor=baseguard
 engine=ICAP:2.0.293,Aquarius:18.0.1039,Hydra:6.0.680,FMLib:17.12.60.29
 definitions=2024-09-05_04,2024-09-04_01,2024-09-02_01
X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0
 bulkscore=0 mlxlogscore=452
 spamscore=0 adultscore=0 impostorscore=0 lowpriorityscore=0
 priorityscore=1501 malwarescore=0 clxscore=1011 mlxscore=0 phishscore=0
 suspectscore=0 classifier=spam adjust=0 reason=mlx scancount=1
 engine=8.12.0-2407110000 definitions=main-2409050055
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/SY0PR01MB9296C4A820754E1CB0CB0EADD29D2%40SY0PR01MB9296.ausprd01.prod.outlook.com>
Precedence: bulk

--_000_SY0PR01MB9296C4A820754E1CB0CB0EADD29D2SY0PR01MB9296ausp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

Need help with replication setup, pg_basebackup failing with:

pg_basebackup -P -R -X stream -c fast -h <node_name> -U <user_name> -p <por=
t#> -D  <dat_location> -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 "......": File exists
pg_basebackup: removing contents of data directory "............"
pg_basebackup: changes to tablespace directories will not be undone


Kind Regards
Samir

IMPORTANT NOTE: FUJIFILM Business Innovation Corp.'s and its affiliates' em=
ail transmission, including any attachments, is private and confidential an=
d may contain legally privileged information. It is for the addressee's att=
ention only. If you are not the intended recipient and have received this t=
ransmission, you must not use, edit, print, copy or disclose its contents t=
o any person or disseminate the information contained herein or hereto atta=
ched, and you must notify sender immediately by return email and delete thi=
s transmission from your system. Any confidentiality, privilege or copyrigh=
t is not waived or lost because this e-mail has been sent to you in error. =
We have used reasonable efforts to protect this transmission from computer =
viruses and other malicious software, but no warranty is made and the sende=
r takes no responsibility for any loss or damage incurred from using this e=
mail or the information contained in this email.

--_000_SY0PR01MB9296C4A820754E1CB0CB0EADD29D2SY0PR01MB9296ausp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-micr=
osoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"http:=
//www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
	{font-family:PMingLiU;
	panose-1:2 1 6 1 0 1 1 1 1 1;}
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Aptos;}
@font-face
	{font-family:"\@PMingLiU";
	panose-1:2 1 6 1 0 1 1 1 1 1;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	font-size:12.0pt;
	font-family:"Aptos",sans-serif;
	mso-ligatures:standardcontextual;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Aptos",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-AU" link=3D"#467886" vlink=3D"#96607D" style=3D"word-wrap:=
break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">Hi,<o:p></o:p></spa=
n></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">Need help with repl=
ication setup, pg_basebackup failing with:<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup -P -R=
 -X stream -c fast -h &lt;node_name&gt; -U &lt;user_name&gt; -p &lt;port#&g=
t; -D &nbsp;&lt;dat_location&gt; -v<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">Password:<o:p></o:p=
></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: init=
iating base backup, waiting for checkpoint to complete<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: chec=
kpoint completed<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: writ=
e-ahead log start point: 6/67000028 on timeline 2<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: star=
ting background WAL receiver<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: crea=
ted temporary replication slot &quot;pg_basebackup_3720137&quot;<o:p></o:p>=
</span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: erro=
r: could not create directory &quot;&#8230;&#8230;&quot;: File exists<o:p><=
/o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: remo=
ving contents of data directory &quot;&#8230;&#8230;&#8230;&#8230;&quot;<o:=
p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt">pg_basebackup: chan=
ges to tablespace directories will not be undone<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11.0pt"><o:p>&nbsp;</o:p></=
span></p>
<p class=3D"MsoNormal" style=3D"margin-right:111.1pt"><span lang=3D"EN-US" =
style=3D"font-size:10.0pt;font-family:&quot;Arial&quot;,sans-serif;color:bl=
ack">Kind Regards<o:p></o:p></span></p>
<p class=3D"MsoNormal">Samir<o:p></o:p></p>
</div>

<DIV>
IMPORTANT NOTE: FUJIFILM Business Innovation Corp.&#39;s and its affiliates=
&#39; email transmission, including any attachments, is private and confide=
ntial and may contain legally privileged information. It is for the address=
ee&#39;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.<BR>
</DIV></body>
</html>

--_000_SY0PR01MB9296C4A820754E1CB0CB0EADD29D2SY0PR01MB9296ausp_--