On Wed, Oct 3, 2018 at 6:21 PM Sonam Sharma <sonams1...@gmail.com> wrote:
> Hello Ben, > > When we do \l+ , it is different than source, when we load backup from > target server. > Backup is taken using pg_dump and its loaded as psql db name <backup> > > Regards, > > Sonam > > > > > > > On Wed, Oct 3, 2018 at 6:17 PM Benjamin Scherrey < > scher...@proteus-tech.com> wrote: > >> If you're talking about space on drive then you can expect the new one to >> be smaller generally as it has been straight efficient writes rather than a >> bunch of updates and deletes which create "holes" in the physical file >> space. >> >> It helps if you are more detailed as to what you've observed if you want >> a more specific answer. >> >> - - Ben Scherrey >> >> On Wed, Oct 3, 2018, 7:43 PM Sonam Sharma <sonams1...@gmail.com> wrote: >> >>> I have restored the database from backup dump but the size of source and >>> target databases are different. What can be the reason for this ? >>> >>> Regards, >>> Sonam >>> >>