Re: Restaring a dumped database - Mailing list pgsql-novice

From Tom Lane
Subject Re: Restaring a dumped database
Date
Msg-id 3740.1289401892@sss.pgh.pa.us
Whole thread Raw
In response to Re: Restaring a dumped database  (Mohlomi Moloi <mmoloi@khulisa.com>)
Responses Re: Restaring a dumped database
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: ODBC driver for PostgreSQL 9.0
Next
From: "Mohlomi Moloi"
Date:
Subject: Re: Restaring a dumped database