Re: Restaring a dumped database

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mohlomi Moloi <mmoloi(at)khulisa(dot)com>
Cc: Frank Bax <fbax(at)sympatico(dot)ca>, PostgreSQL List - Novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Restaring a dumped database
Date: 2010-11-10 15:11:32
Message-ID: 3740.1289401892@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mohlomi Moloi 2010-11-10 15:40:39 Re: Restaring a dumped database
Previous Message Devrim GÜNDÜZ 2010-11-10 14:59:02 Re: ODBC driver for PostgreSQL 9.0