Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7WDC-00032g-0I for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Oct 2018 01:44:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g7WD9-0002Af-Qt for pgsql-hackers@arkaria.postgresql.org; Wed, 03 Oct 2018 01:44:23 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7WD8-0002AX-CB for pgsql-hackers@lists.postgresql.org; Wed, 03 Oct 2018 01:44:23 +0000 Received: from out3-smtp.messagingengine.com ([66.111.4.27]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g7WD2-0007x4-DM for pgsql-hackers@postgresql.org; Wed, 03 Oct 2018 01:44:21 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id D83FB21EAB; Tue, 2 Oct 2018 21:44:14 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Tue, 02 Oct 2018 21:44:14 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:from:in-reply-to:message-id:mime-version :references:subject:to:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; bh=hROXUL/SzxoWDr1cRWKiZb6M8hGIx0cBlG/d0OStdII=; b=D/0U9Hop IJIlNPn/vdmVOcd3OmKnuRr6cId2l9xWx0WkjmXHGT3KZYrCEnBf/2BiSbMNGV0a L/VY0a6iVwZIAKeIMMhZTRQEEpTcREypaUNvi+wFqilbcP7rs7xyYTgEPy0R+duP gVtCDSKE/9hhRPEjymqHul8u2WGsf8arZ0ceYzuNojjNhgvf/iNa3fUJ7LF6EUXB dkrRwtAXBy7a4mSbCj+XSFXU+eyTWDFaT8WBdUdRshr4R8eWfFqWQKZtXJ6EZ5cn FFnevxHzdwvq8QIRIag+Q69DZLfwpjeK9UU/Chc93PgYWuES4asyHwm7YSMUI/CY svSRo+z6vA46fA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=fm3; bh=hROXUL/SzxoWDr1cRWKiZb6M8hGIx 0cBlG/d0OStdII=; b=mugIdu1NuCjtBUWh/bnvsm/aHrNxkCx8j+BnUR+a9IQMe GUBYpgDzcUAVvXIMdYplAwRWYt4RrssazwbyLs461MEOxAH4ekmlYBV4QKbkaWaD 6+d3nEGoPoFMCdrXQF4cEDPLkGovFOZJpt0LVhCvyY6F657lGuPqBAkj+aKAYXWB yW05dAlrk15HwWAJZLe0smGMo7EqEMNnT6XxUiUxInKL7MPwkJzIVfFzV09k8vzX v4jFCs3wTOT/AETCPp3jAqbsloePBhbol1Q62/i7QsOVur+cFuHP0cvRagFtnURb CIkpWuhcajEROaXxv+cDtAvesNgfKLHIitcN7cFlA== X-ME-Sender: X-ME-Proxy: Received: from paquier.xyz (c137162.net61215.cablenet.ne.jp [61.215.137.162]) by mail.messagingengine.com (Postfix) with ESMTPA id C9FF6E4A4A; Tue, 2 Oct 2018 21:44:12 -0400 (EDT) Date: Wed, 3 Oct 2018 10:44:09 +0900 From: Michael Paquier To: Alvaro Herrera Cc: Peter Eisentraut , pgsql-hackers , Bruce Momjian Subject: Re: file cloning in pg_upgrade and CREATE DATABASE Message-ID: <20181003014409.GC2609@paquier.xyz> References: <20181002233248.GA2609@paquier.xyz> <20181003013502.gvb5rkopfxtqk2yh@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="xesSdrSSBC0PokLI" Content-Disposition: inline In-Reply-To: <20181003013502.gvb5rkopfxtqk2yh@alvherre.pgsql> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --xesSdrSSBC0PokLI Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Tue, Oct 02, 2018 at 10:35:02PM -0300, Alvaro Herrera wrote: > I'm not clear what interface are you proposing. Maybe they would just > use the clone-or-fail mode, and note whether it fails? If that's not > it, please explain. Okay. What I am proposing is to not have any kind of automatic mode to keep the code simple, with a new option called --transfer-mode, able to do three things: - "link", which is the equivalent of the existing --link. - "copy", the default and the current behavior, which copies files. - "clone", the new mode proposed in this thread. -- Michael --xesSdrSSBC0PokLI Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAlu0HukACgkQnvQgOdby QH1BJw//f2r/tD893KcAtn/aVUFw+wPqpfGM+lpf4jYZHx5bug2krQj38Vx+TafM V7XDlUOlCh5sbELe84SvaguK3ewlj7CCZ83QVMXut3FRrkgQNGMV9kh9CL2O4Tjj 0vZa+tC5JYiUAR6rr9KO3R5J3G49PRl9I4Z3dCdeZbyr41oh3EK3NATQFhYGzTiw RAahrd+Waz5KS8AWtsE/RSAUBzJvaA26hQenuO6joDdEGrqB1PgjQI5/TPzo+plV THJYGAdp58U8Q6xl+0IH328VTdFaVVrbIFg8hUJL71Ic9mzFX3f+KjZROUWErEUj bAYZn6Va0sjOlyTsrps7QZImJE8oRN00TjqUY2UIg87Eirod7i3c0gV21kcFpNV1 cK8WFmVmBjSxTxBhTEOUGdTPsVJ6MBNLwr83V3678Mro1SlusH67EiqVxOG56DAd UyZRE6OLMvEn+t/85goiOE36oo9fVf3A2HvJSklNde3mW+HmeOX9H8YgpO6AUTzG Ir/btIGqveNvKMwxHUGX3yqhKVonIX7cVx6BrJByhQ82Uj6FdVber5rcc4S7cFaw raWUP0I+MNsaLmLMKdGseYBTyTnxo/Z7puzTk0nJcfgRpdMvWMIf1lhT7NnpUvs2 aqJpqxFY7rKxmCUR90/DfVjC1MF2wwrYYm6jpRMN8ybVhASw9jA= =DmQN -----END PGP SIGNATURE----- --xesSdrSSBC0PokLI--