Re: Restaring a dumped database

Mohlomi Moloi <mmoloi@khulisa.com> writes:
> Bigger measured by looking at the previous size of the database - that was 34 megabytes and the restored was 800
megabytes.What I noticed was some of my table had triple the amount of rows in contrast to the old database. :)     

Maybe you did the restore three times?  If you do that and ignore errors
about objects already existing, you could end up with multiple copies
of all rows (at least in tables without any unique indexes).

            regards, tom lane