On Wed, Oct 3, 2018 at 6:21 PM Sonam Sharma <sonams1209@xxxxxxxxx> 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 <scherrey@xxxxxxxxxxxxxxxx> 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 ScherreyOn Wed, Oct 3, 2018, 7:43 PM Sonam Sharma <sonams1209@xxxxxxxxx> 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
