Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooLjt-0001XK-5V for pgsql-admin@arkaria.postgresql.org; Fri, 28 Oct 2022 09:33:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ooLjq-0001Tz-MC for pgsql-admin@arkaria.postgresql.org; Fri, 28 Oct 2022 09:33:18 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooLjq-0001Tk-5y for pgsql-admin@lists.postgresql.org; Fri, 28 Oct 2022 09:33:18 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ooLjj-0003FW-63 for pgsql-admin@lists.postgresql.org; Fri, 28 Oct 2022 09:33:17 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=s31663417; t=1666949589; bh=UqyTsneJ0SQZd9Z29JC57Lt1gTCPIXp8n9IMOCu9r3o=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=sIg9x+qIl9c8a62ebKqXjfyaOGD+gLfdabfpb+p9xpZWfMrRiGB66+/xqZ2xVQVfT e2wJbRGco/AUoCAOAGLdh1aSLufTjHPQsDDen3HIO4Ty2ul2Z0z7oREi1+yQsitkAH lzz5K1E+gv4yNildqGcl1OPcOZo8RX/+U0+zofq3tqcpf0WZHWzVjnk2acuUHO53I2 zUcka9GXPbjLkZslIf58a5tsbxEq+cbmB6YwpjXCZNF6Gy7s7CtfHOka640diwNE93 MZav0sBgr0m7tLbdHgy2sI1s2nyyvoA/4COMbB8wvj/vvqWIZAru1bhVC4d6PdyUXs YSrcKmyyRx7mA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.8.0.248] ([185.40.248.10]) by mail.gmx.net (mrgmx004 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MWRVh-1oYBdX3lmt-00Xqa4 for ; Fri, 28 Oct 2022 11:33:08 +0200 Subject: Re: failed to create directory in postgresql To: pgsql-admin@lists.postgresql.org References: <20221028081039.dwo3o563enrmc3ee@jrouhaud> <20221028081818.76dtkkcfg5bivz5x@jrouhaud> From: Thomas Kellerer Message-ID: <0dc6af67-2bc7-01be-6532-20875cc5a1ec@gmx.net> Date: Fri, 28 Oct 2022 11:33:08 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:6GYFOTcHBILzWHG7hJFX6VxHq8jqhH/0C8qSjpri07PFvzamBzx bA0dePxQNDTtEp/9MUoJUutQC+eCeVsCoObXzJo9HFc1/8VtMOc+nJO+Ccv1/wrzDlc8sw0 hsRZVyVJsklMRouf87N0I/V/ImKZQyZgFy5ELFKhWqWF7A1bhix5ZHBEDL2k4hf5035eSJ6 IoZYsV2SikdaGuxJSBodg== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:nr+VFXMJwDw=;lY5xow8GJG2lVXYSBpvIYKztalU oIDoGkXRlt7lw+SgAWSNVid3qGcHSUbN+YmKmJPsywL8q35v9GXHGi19yzGRcmEYu6/etu93g 3LZf6oTj+bpZleaRYzHClJV3bQNpKnLqSXfIzXbh360BBc4a4Cum6IHZ7M3x+DZVJQxCO6Kzm goBJ3TGhPFOx+dcFrSYoJnJBzJbYJ/QUl7IcKf2J1IbqtByv5LMgfdZUkjgJRrT9s/W6fHzZG 3gLBzoljqKuYRzDACVS2zPzgqmqGVUKJbtsDfn9J1DrRac5gOppp+Gf3WeGD9TpKAyvzQrzIW kRte3lzUR8ikWIpfnw04pDZ07zSIqyDMbvG83bdfip6ub4DIKulIHA2FRqYV4LRG6fQ+ZqtIm i7ha/zPO6CoXRuCgTvUmfR6kxHlXL1yV80ndCrvLuKaqhUB8mv/RA+Ioj+q41HSB6XFnSqgLf cXV9FbU51b7h3ii0VtBWDJHW5o5ZySJEOt3OpEZCWulojm+yU2DcREHZ8q3NBflus1Fc9uijX GFSHolqoiTXKmWfxFcp/rCXDi1orXie7YjCtW2ovvhBy+MI/vjcmjQp7jBuJ2bverM4H1LkkG pvF9Ayg3/YregfmpjYWDXuGYhA8aFlsvfwDG1HcVcbWFcHEDWXeLkBao9SI1jO/YMmtzzbJJA saa85OyrOAIeO3yU+dgEMOJE2U+Q72Pq5HJUay5j7ak3jCpAXPDEQAW22qLxm9WXtpn3II3oP 8yvdhPM5O/mN24GwU0asPRHp5EIWYt1z2mLQupWMomfD3BEWTG8EgtmdvIOl7weGgTKeNP6P8 H379gymiGX8eLJMbT1Gct4jgYmCYevj6CDhYqPWLlrx3jveAbKKHulAgwj5j0fMjlIXloU7D6 H3E9nd1P0d0X7F1sNFa7PGRBXCGbGAzXWkxe2Dk7Clw8zwp8eNQgWoOZPYchswAntWZ3+CLcH 1INm7XoMVwDQrFA0MVr0KppQAHk= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Samed YILDIRIM schrieb am 28.10.2022 um 10:23: > Can you explain what you try to achieve? You probably try doing some > practices you know from Oracle experience. Why do you need to create > a directory on filesystem through PostgreSQL interface? In Oracle, CREATE DIRECTORY doesn't actually create a directory in the fil= esystem It essentially _registers_ an existing filesystem directory with Oracle so that it can be used e.g. for datapump or external tables.