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 1twmho-0004Zx-J8 for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 18:39:24 +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 1twmhn-008Ei1-0Z for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 18:39: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 1twmhm-008Ed9-K6 for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 18:39:22 +0000 Received: from mail-wm1-x331.google.com ([2a00:1450:4864:20::331]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1twmhk-000vTY-0K for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 18:39:22 +0000 Received: by mail-wm1-x331.google.com with SMTP id 5b1f17b1804b1-43cfb6e9031so43512175e9.0 for ; Mon, 24 Mar 2025 11:39:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1742841559; x=1743446359; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=tUPl4JN/zSYb3IE4hwZfF6HmIz49OnyqUqcBrjbQHOM=; b=sWelEwRghTzrA7gUk4/EkusssVvdHZQyVbZP4/sBwEQ+xIoudIX3k3Do+50+aSt6Qk RSIk4GvMg5vzYpKCh/Bhba+5ZSiazFvEF6XExTxwq8x8fDGSUp3WEWlbOnQ+qjR9GDil eiIp/hY6PchI7hp+PoMxialaLt5G0NSQuNGTkbsHd4BH1RK8oPmqLR9P1IyyZ7bJsfJe Ax+Q6R0D7gdAVQQKgKwvosuvF5JNrHdBOXEhElx6IpugUsrxvXwa73YcBd1eBEEQtNHZ jEMW4uIFpCtF6uNUivdmipFBpTDn7qE0M2w8QdGcHMDg+XsY3ACqvu1Bnc2+TevGSHfK b2dQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742841559; x=1743446359; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=tUPl4JN/zSYb3IE4hwZfF6HmIz49OnyqUqcBrjbQHOM=; b=daGaYpsftpOzoJfEAfYsN+HTmIngr1+yBHJlKcPa98YcUa2Rkf889tOoAjJMs3YBSX WBcRGEl5/myI95DPfbYHEx7BNDrHoCkZNgjTyv9SgZ0xaEnbLc8zajME3ngZ0Zcd6NCG JUaSn+GQUsYd/D9AoPfy+lcwUjL40oQ+Vkx83D7D9Bcse4en4gCwyiVPSYsLv7BO8qxg LFBXdWqHrNFrxTswnEivyaODS2bPcz/2hL1y6v6IevoveLiIMegWTX6RA6WIuRfw7Uhx j93xrF0wdX9wNTBsOS2hJex7pd0oPWgNYZv9E+o0yEfKca/hH/33brxTs3aaECPy7tIW q/Ew== X-Gm-Message-State: AOJu0YzyrOXZT6Gf15bbh2SGyUfYeZP5khh0JD0bw8pVerAr1J7ISlCg dNM9f5X/DzwFfJ8ID3hFepVrMgoNKkCGFDfRtIswdO25K9TRN0PXCtcEKKQT+jQ= X-Gm-Gg: ASbGnct6LC95UHfJrJDTrOHQvxa6Tk/muG3TZsOkfh0fFqIwaNyLtATMZSy2LwxTyxO I5SHmoH4+Zbn1zwYAstQW3KE/Z7cWRaIPs1+7fdUBL6Gt5lWKfW+iDbHr2RZmkYfRQgsY4N8sRT 8uxTw3Z7QO0XrV2QSR/imEezw+mneYJY/fO5pJprKDsMzdHOWhWtYx2cNy5+0smEBIPnFfX4wbP iYpEiEf6q6GFuczWoTEUgximSxT9htgHvcXUiTVqBHx07gvuoDjaVbf1Dq0rXeFtS/kWqYVzcxD 7uLraO+s/5CzG8EIzpK2XQXYPb0U691dmg8RMjfuoXlEQiw+WzW5cpbBtiaaiqw= X-Google-Smtp-Source: AGHT+IFEyXhwZ0VKgRHBERmGHCjJ7fhVQsdn2XKYfVzDTERdzXaDOJK1W4KWS5w9Z8S2WoyWJOzANA== X-Received: by 2002:a05:6000:4012:b0:399:6dc0:f134 with SMTP id ffacd0b85a97d-3997f940865mr13328163f8f.51.1742841558678; Mon, 24 Mar 2025 11:39:18 -0700 (PDT) Received: from localhost.localdomain ([2001:871:260:9d2f:b0b3:8a:8452:71c0]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3997f9ef063sm11469755f8f.83.2025.03.24.11.39.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 24 Mar 2025 11:39:18 -0700 (PDT) Message-ID: <05d82be454567f398f9ca6a0cdd8f68ccee6bfc0.camel@cybertec.at> Subject: Re: Experience and feedback on pg_restore --data-only From: Laurenz Albe To: Dimitrios Apostolou Cc: pgsql-general@lists.postgresql.org Date: Mon, 24 Mar 2025 19:39:17 +0100 In-Reply-To: <5f1ebeda-f080-cb31-75c0-ce2211ea348f@gmx.net> References: <53760c70-4a87-a453-9e02-57abc9cb2e54@gmx.net> <455d28421ae33c73b73a6f527d2f72816ca5dd29.camel@cybertec.at> <5f1ebeda-f080-cb31-75c0-ce2211ea348f@gmx.net> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.54.3 (3.54.3-1.fc41) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2025-03-24 at 15:24 +0100, Dimitrios Apostolou wrote: > By the way do you see potential problems with using --single-transaction > to restore billion-rows tables? No. Yours, Laurenz Albe