Re: Restaring a dumped database

Tom Lane! Tom Lane! Tom Lane! Just checked my history to confirm and yes
I've ignored errors about objects already existing. Problem solved with
the cause known!

Best regards, Mohlomi Moloi

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: 10 November 2010 17:12
To: Mohlomi Moloi
Cc: Frank Bax; PostgreSQL List - Novice
Subject: Re: [NOVICE] Restaring a dumped database

Mohlomi Moloi <mmoloi(at)khulisa(dot)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