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 1shHxY-00FqFr-15 for pgsql-general@arkaria.postgresql.org; Fri, 23 Aug 2024 00:15:20 +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 1shHxV-007ABA-PS for pgsql-general@arkaria.postgresql.org; Fri, 23 Aug 2024 00:15:18 +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 1shHxU-007AAu-TY for pgsql-general@lists.postgresql.org; Fri, 23 Aug 2024 00:15:17 +0000 Received: from fout1-smtp.messagingengine.com ([103.168.172.144]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1shHxN-0011yv-C6 for pgsql-general@lists.postgresql.org; Fri, 23 Aug 2024 00:15:16 +0000 Received: from phl-compute-02.internal (phl-compute-02.nyi.internal [10.202.2.42]) by mailfout.nyi.internal (Postfix) with ESMTP id 4223113900BE; Thu, 22 Aug 2024 20:15:09 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-02.internal (MEProxy); Thu, 22 Aug 2024 20:15:09 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1724372109; x=1724458509; bh=Lpb3q2tyPkluanRNXNeSdA/pEUwtVFl3cDUfFZ1n+uE=; b= M5yJ9GGk54eg2qVoA81VUU90JfeAOv7cMbvAckpZ63PNlm+Eq0JTN1rJ/l6M/bsq Jm5eSR7HiqTkT/psMsAbM6m6NH8OnOfzFNsTSDZYxFV0iX3/RHlMnLyRobt+GdMk wzMfUrqeP6clcgVaAMk5hejUseNCk1Nr6wkfQTPdBmQ1bKODzVFxU1osERnjKAww 92+zFR7pe6u5w6bllAxnyK7qOaQtcYnMhFj+Wx3H4039+GbU6C1M1J/GbWAYy7JG QRb0Ri+gKLCI4qBWTCLbo7Mwdx7sNBNcadrL2LjIPsSO7GRUphyqr7ENNkMdKWVX Ycrbk6EF0B1dzIEG+ymCWg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t=1724372109; x= 1724458509; bh=Lpb3q2tyPkluanRNXNeSdA/pEUwtVFl3cDUfFZ1n+uE=; b=l kvVSEyvMRFTo6+n7ARdm2pGG1S6IRJvyLjSm2uCtNAlcgn4+WQy1Luo9NFJT2kLz PnN3NT431r+wY9VElPnOlIGRnN5ht/Yav78LS+6FlM05vSdK5ZTKEMK68ggIT36B ZZ/eaIxHlDPtSf+tCmKwMPqkkIIWJ0EPrZhOiJH4siCwXHb0hUWum3ckcmFWuzZT En6B++EItRuiEQzFhBwD6jkc7LXc2Dt7fjkfCspEPNRMdZl7aiVNx7rsRbEz48uN ZuKnfkR07QHIWRHoWCami4/AsjOn1Z9IQly87TRa6jgvQm+csHzGeKIXYM9AMsO0 7dJw5YWF5czIZuPXLLFew== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddruddvuddgfedvucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdej necuhfhrohhmpeetughrihgrnhcumfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrh esrghklhgrvhgvrhdrtghomheqnecuggftrfgrthhtvghrnhephfeviefhveelffeftdeh udekveefhfeftdegieefveetfffgfeehtdfftedutedtnecuvehluhhsthgvrhfuihiivg eptdenucfrrghrrghmpehmrghilhhfrhhomheprggurhhirghnrdhklhgrvhgvrhesrghk lhgrvhgvrhdrtghomhdpnhgspghrtghpthhtohepvddpmhhouggvpehsmhhtphhouhhtpd hrtghpthhtohepshhiphhpihhnghhonhgvshgrnhguiigvrhhoshesghhmrghilhdrtgho mhdprhgtphhtthhopehpghhsqhhlqdhgvghnvghrrghlsehlihhsthhsrdhpohhsthhgrh gvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Thu, 22 Aug 2024 20:15:08 -0400 (EDT) Message-ID: <6ba6512d-2e5f-47c6-8fb8-5689df2ad3ed@aklaver.com> Date: Thu, 22 Aug 2024 17:15:07 -0700 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: How to validate restore of backup? To: Vince McMahon Cc: "pgsql-generallists.postgresql.org" References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 8/22/24 14:31, Vince McMahon wrote: > Hi, Adrian. > > The largest one is 8 GB after compression. > > I have a window of 8 hours to handle 30 GB total of backup at various sizes. I assume by compression you mean using some form of pg_dump -Fc. As to your timeline determining whether that can be met is going to depend on a more detailed explanation on your part of what you expect from the dump/restore process. -- Adrian Klaver adrian.klaver@aklaver.com