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 1qwK4r-00B5nH-Nf for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 10:28:29 +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 1qwK4o-00ETAu-Mn for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 10:28:26 +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 1qwK4o-00ETAm-BC for pgsql-general@lists.postgresql.org; Fri, 27 Oct 2023 10:28:26 +0000 Received: from mail-oi1-x22f.google.com ([2607:f8b0:4864:20::22f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qwK4h-002YSu-9N for pgsql-general@lists.postgresql.org; Fri, 27 Oct 2023 10:28:24 +0000 Received: by mail-oi1-x22f.google.com with SMTP id 5614622812f47-3b2b1af09c5so1149638b6e.0 for ; Fri, 27 Oct 2023 03:28:18 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698402498; x=1699007298; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=0RGAquj1cHEQ/Gxwn5GqHrGCs4ECT1J/S0Y3C6aHZUs=; b=nkhbmUJkhYGtrAThOVgHWjRxbr2e4pfdvn/nT1EeB6+/DWZ15iaJapHr799MMoYTQ7 DGA2twRdtJ0VP0X22A5YwfRehqs9tXAUImlDpB+GytuWCOmrBzQ3523h/8R73DoljMcB g7VTOiEVUBss9So9DJKyTSpg4T+/d8pCK6qi3jV9+gaDQd2YG2e+DAWCJAseTybpbvLz BHFr6QIXY20TGaS/BLDSRsFe+JOxPWsg+hM8ZSNljS/BxYyWV2SSRTTlRpG+cu+M1UMP qC0oe1P2mqbIzdJqhLvotwgOgkBaiPN4XEabtnDO7xo0zZCUfhgEWJGxtfohqf2cHInz bJaA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698402498; x=1699007298; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=0RGAquj1cHEQ/Gxwn5GqHrGCs4ECT1J/S0Y3C6aHZUs=; b=nLoyUF79aT/YBy/Naj1CpMRSqT2jKtG4HIscJs4CeSWVHEkvpMAYZXiIoVKyUhMSfI ynp2NP6IWP2KAHvr3IDQCjImb6tziN1djMFJXCwHZQtRop3W2CFd+iyGrcXhqPqrDZuO eZccVfKtpX+6J0D6ekLMATtq0A+CGJDH94Kf7IYZy4r6mIgK3XNQM1kTpn8xDPC0RH9J mNjQ0I6Ik/c+uxH+UARSwpmgKSXfyknOJDZEFqk1J8IwAdVwLvYJfrTZMWBB39zdT+/w mwt5Ior6WhgCEzrdXWmH1Z+RVUzhqcLTCZDW7W6OQ4TIWi7K2ckFU39tVY2hPZg2j3/A pqVQ== X-Gm-Message-State: AOJu0YzT0v+tHqXmI9mqkg6qvFY3dX1f3WGNnFuzh3bWkvM5/fCifToJ INH7u4mG0FDOiauh3Vw567UI3YE/dTY= X-Google-Smtp-Source: AGHT+IF3awTiiuaSP44rxI9x9H9WRdzCHSWWHuwtsI+xrufV58KItwzHH6i2fzVQD/e66o5/l1t9lg== X-Received: by 2002:a05:6808:9a3:b0:3b2:e9ad:c01f with SMTP id e3-20020a05680809a300b003b2e9adc01fmr1998511oig.44.1698402497854; Fri, 27 Oct 2023 03:28:17 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2? ([2600:1700:bd2c:b810:e0e7:f6ad:239e:5da2]) by smtp.googlemail.com with ESMTPSA id k27-20020a25b29b000000b00d72176bdc5csm549744ybj.40.2023.10.27.03.28.17 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Fri, 27 Oct 2023 03:28:17 -0700 (PDT) Content-Type: multipart/alternative; boundary="------------KHCVbFFD4Pc2K1PIpE0kf9nR" Message-ID: <49939d78-0a8e-4e1d-b627-2eade49736db@gmail.com> Date: Fri, 27 Oct 2023 05:28:17 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: need SQL logic to find out way's to Implement check sum to validate table data is migrated correctly Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <1334708887.12132.1698396967548.ref@mail.yahoo.com> <1334708887.12132.1698396967548@mail.yahoo.com> From: Ron In-Reply-To: <1334708887.12132.1698396967548@mail.yahoo.com> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------KHCVbFFD4Pc2K1PIpE0kf9nR Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit On 10/27/23 03:56, Y_esteembsv-forum wrote: > Hi > Need SQL logic/different approach method's  to find out way's > a) to Implement check sum to validate table data is migrated correctly When migrating from Oracle to PostgreSQL, on both the Oracle side and the Postgresql side, I dumped each table (for the big ones, I split them into views) as a tab-separated value file ordered by the primary key and piped that into md5sum. Had to play a few games with capitalization in blob/bytea columns That way, I could verify that each table's data was identical. -- Born in Arizona, moved to Babylonia. --------------KHCVbFFD4Pc2K1PIpE0kf9nR Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit On 10/27/23 03:56, Y_esteembsv-forum wrote:
Hi 
Need SQL logic/different approach method's  to find out way's 
a) to Implement check sum to validate table data is migrated correctly 

When migrating from Oracle to PostgreSQL, on both the Oracle side and the Postgresql side, I dumped each table (for the big ones, I split them into views) as a tab-separated value file ordered by the primary key and piped that into md5sum.

Had to play a few games with capitalization in blob/bytea columns

That way, I could verify that each table's data was identical.

--
Born in Arizona, moved to Babylonia.
--------------KHCVbFFD4Pc2K1PIpE0kf9nR--