Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gojW5-00042d-PC
	for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 06:38:33 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1gojW3-0004QU-Ii
	for pgsql-admin@arkaria.postgresql.org; Wed, 30 Jan 2019 06:38:31 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1gojTp-00081Y-P9
	for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 06:36:13 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1gojTn-0001Re-84
	for pgsql-admin@lists.postgresql.org; Wed, 30 Jan 2019 06:36:12 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.4/8.14.4) with ESMTP id x0U6a6Lm014754;
	Wed, 30 Jan 2019 01:36:06 -0500
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Sridhara KB <sridhara.kb@digitalapicraft.com>
cc: Ron <ronljohnsonjr@gmail.com>, pgsql-admin@lists.postgresql.org
Subject: Re: Postgres Complete backup
In-reply-to: <D495FA4A-2185-4774-BFB8-957D59913A11@digitalapicraft.com>
References: <FD085798-1199-4CE9-831E-8DF50E85E0A0@digitalapicraft.com>
 <2eb9f619-a9a5-5862-b8ce-1fdead69378a@gmail.com>
 <D495FA4A-2185-4774-BFB8-957D59913A11@digitalapicraft.com>
Comments: In-reply-to Sridhara KB <sridhara.kb@digitalapicraft.com>
	message dated "Wed, 30 Jan 2019 12:00:05 +0530"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <14752.1548830166.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Wed, 30 Jan 2019 01:36:06 -0500
Message-ID: <14753.1548830166@sss.pgh.pa.us>
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

Sridhara KB <sridhara.kb@digitalapicraft.com> writes:
> Have gone through this url, but  size of pgdata of old database and pgda=
ta of new database are not matching.

That in itself means nothing.

A freshly-reloaded table will contain no dead space, and freshly-rebuilt
indexes typically have less bloat than ones that have been used for
awhile.  So the fact that your new database is smaller per "du" does
not mean you lost data.

			regards, tom lane