Skip site navigation (1) Skip section navigation (2)

Re: Restaring a dumped database

From: "Mohlomi Moloi" <mmoloi(at)khulisa(dot)com>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us
Cc: fbax(at)sympatico(dot)ca, pgsql-novice(at)postgresql(dot)org
Subject: Re: Restaring a dumped database
Date: 2010-11-10 15:40:39
Message-ID: L4130658EB84A4aa192447729BC400896.1289403637.scalix.khulisa.com@MHS (view raw or flat)
Thread:
Lists: pgsql-novice
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



In response to

pgsql-novice by date

Next:From: Joshua TolleyDate: 2010-11-10 16:52:06
Subject: Re: PgFouine
Previous:From: Tom LaneDate: 2010-11-10 15:11:32
Subject: Re: Restaring a dumped database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group