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 1twkTJ-00HHBp-2R for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 16:16:17 +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 1twkTH-00697O-Rp for pgsql-general@arkaria.postgresql.org; Mon, 24 Mar 2025 16:16:15 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1twkSE-0064uR-HK for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 16:15:10 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1twkSC-000t5D-2K for pgsql-general@lists.postgresql.org; Mon, 24 Mar 2025 16:15:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1742832903; x=1743437703; i=jimis@gmx.net; bh=ev7+euWxYM7AYIpCxGsIguiqhgN+DV+JXV+kM4nkGu8=; h=X-UI-Sender-Class:Date:From:To:cc:Subject:In-Reply-To:Message-ID: References:MIME-Version:Content-Type:Content-Transfer-Encoding:cc: content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=R2u1v7IiTWzVazw9t6p+s5NnWVRv6yyuRaZdh5KQSN5wUmFpHVuFs03/FDSpwi06 0wzjb/2eI0wEGrn+nNAahb1O7sUQ0C/56QrPxvwa4fYNrowY8tantxpNT/NoS3ZOh 1QjbyJ2s3Js/F+07BH0bVpE1WoGxWDe1ayJynOsZPpTjTHa3YuVmkz42XIUBzmech SSjcoasTmnmToFDdOpnHcv2H3stXaJzB6qyRSovz3hFaXKhbi2zP7SaUS1Ibf7KGT qpBzFj9srxsbHNj9nEOhvyiYFgwaEZpS6SrCwCIz7v2Tubc4Cn/QUeAMq6wjeb1T2 u6KGbYLXRqFDguhvmA== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Received: from [10.9.70.81] ([185.55.106.54]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MS3ir-1tYwDV3zhb-00Wa1c; Mon, 24 Mar 2025 17:15:03 +0100 Date: Mon, 24 Mar 2025 17:15:01 +0100 (CET) From: Dimitrios Apostolou To: Ron Johnson cc: Laurenz Albe , Adrian Klaver , pgsql-general@lists.postgresql.org Subject: Re: Experience and feedback on pg_restore --data-only In-Reply-To: <832c1cdd-c0fe-464b-b4b9-f9d0482b9b78@aklaver.com> Message-ID: References: <53760c70-4a87-a453-9e02-57abc9cb2e54@gmx.net> <455d28421ae33c73b73a6f527d2f72816ca5dd29.camel@cybertec.at> <5f1ebeda-f080-cb31-75c0-ce2211ea348f@gmx.net> <832c1cdd-c0fe-464b-b4b9-f9d0482b9b78@aklaver.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed X-Provags-ID: V03:K1:lY1Eow7fXs2Pl2L+PI5OF+VLOzhRxHjxZpFB4R9P2wYsZ0i5y7Q EvCfUCzIGm63tql6lDFEQ5p/9bPpV09p924SFTBWUbfyGAU0XfDs8V+fEUySKZ/WlHGMAVJ +iB8frT/PFVRaRxSkjJpwFVFB7eFxkbJ1Y07g2Y+uBxFfiZHpNsKL684vQHJ9i3GVRBrl7a 0MVf9Ez2lqIa+V+rdYz0A== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:HOmwHsrfgCM=;Qrq0XL0dAcejanYWQVFWizDKVok c7qxOWrRXSZvYfJ0vD+Vywlu887+x7ItfBGYqlPPPXcfY83IL7/YKQW5VWv8lzV1c30pZmRuI ynrjg4akbtTXI6Tytha0hnE/HaYH5qyL7+5Ozs6ryvUs14RhivlznYgiBPs+DhHGD3M6WCEpG DRVoJyGG9jUhk3SKf2ljgoAJdPVnhnB+4VtLseQTLE9toKZHPjhoH8FhVCjpI8b3q8rvXYwSV KXbDz5+5gqqEGjta5WXFWivZwnOLam1kCs0ILfMWudtZfQ64AR43310sAy7HWJkk00kS7Lhyd rjlB45kyJQIfMi6GDavUuZHhvTBQWKnbS6fMEAhVc3LKc0uqjeTcNGjmHn85hUAm/y6cUg3vE SuIKH0ppof0utFP0dS91xhq5uaibsogWeoEETee5XRrW48XvYJ274lbGVPv1+gwjb+6J/K7P8 HZVOynCuTCAYlen0oFqW7rhYiSWd0lpF5F15k+gpNR7iPgibPd3Syazo0HnKsLzBEfNFFFSRd NX4fJi/ULpSk/IfOhh2WvEN4xwjLkVMU3sRhqWp3VmTSDdDTJSJD22+XtK53GWCCdpddyMIlc 6+ypKQbXwzYG6fE3YW4DFZcgDUVV/WEj3vMSpaHaO7l61sYO8QfGNY1mqhW08FZYNIaDw/tSM zt1gcpc6qrhOSr6CBudn3+hV9lVI8aJosbpFqTUF58Sde0LHp87dxia7MVh/68X3zrvo3MzLL oIqKnjUvOTY75oxOZM+l3DQxg9EbjV/rsRhL8TrGJZ34zV7kP77RUXwa0qGRlyuqKgAIdx1kP BaUTSzVcjYMGRNNy7icpEDKitZ9J8XetoskDaZXntmwxfR6GaxyxQbDv2/+2EhWEFFpsK4gLL w+GQVDPNOoYH107jTxVqCkGu+10WyAwoLG3X4p7/cZWDKZzgA5VjPJL9mmwE0Mv2QXpRjM+CS lRJ9NxyDwCtZPk4i98KqxLjgBJCg0a7mPIg2vFjcHb4kvCk3pdXC8drEtlht07Mjj7EasZn9s QB/hvkpHfq5Sy2vuBhT3tsV+3O8Erqe3ZeANCRUSMr0PbhAkzwW1UDpsJk1NlWt2uFnQ+oIZr 278SsdYOrH1mnKtJ256wpqAenXyTyXazmfXUmZcm1qT7+5RoorWwrhZa83n8IhHDhT+C0Hcw4 AwC5lB1rfbTASms3Ya4x9JFtggoO0MZQlkPexlpZLsFMrgkJ+crWVXDQtuIVTsgakNClDKla0 nZSgfNkXfmcSO8DIEp9CsavAPZaoJT4V+fp74GyXwhxcJdjjnwv/CwaG0i1ebIJVM3w9gUv1T +OdnlhXl9/XkqEZOykha9QS5zURJQTU2Gq72ml89kMHgQJpqy6IIjdsx23VtFvFi9a7DjkUgJ 6RV24ouo+W4jYIn8RYVlumQzbN8bSH1LbUXQFVPW6c2XwxFiM5RUo8L2g29msnl0L+NX3mdaA Vx6q0QA== Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Ron, I read your reply in the mailing list archives as I'm not subscribed to the list, and I'm copy-pasting a response here. Please include me as a recipient in further replies. > Why are you regularly having emergencies requiring the restoration of > multi-TB tables to databases with lots of cruft? > > Fixing that would go a long way towards eliminating your problems with > pg_restore. I don't have emergencies yet. I'm testing the process of restoring the database dump, and it takes more than 24 hours currently. A successful test is vital to approve the process. But the primary usage of pg_restore that I have is not to save me from emergencies but to populate the dev database with recent data. Regards, Dimitris