Re: Postgres Complete backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Sridhara KB <sridhara(dot)kb(at)digitalapicraft(dot)com>
Cc: Ron <ronljohnsonjr(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Postgres Complete backup
Date: 2019-01-30 06:36:06
Message-ID: 14753.1548830166@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Sridhara KB <sridhara(dot)kb(at)digitalapicraft(dot)com> writes:
> Have gone through this url, but size of pgdata of old database and pgdata 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2019-01-30 07:47:51 Re: : : How to mask column: :
Previous Message Sridhara KB 2019-01-30 06:30:05 Re: Postgres Complete backup