Re: Postgres Complete backup - Mailing list pgsql-admin

From Tom Lane
Subject Re: Postgres Complete backup
Date
Msg-id 14753.1548830166@sss.pgh.pa.us
Whole thread Raw
In response to Re: Postgres Complete backup  (Sridhara KB <sridhara.kb@digitalapicraft.com>)
List pgsql-admin
Sridhara KB <sridhara.kb@digitalapicraft.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


pgsql-admin by date:

Previous
From: Sridhara KB
Date:
Subject: Re: Postgres Complete backup
Next
From: Shreeyansh Dba
Date:
Subject: Re: : : How to mask column: :