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

Re: Examining very large dumps

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Examining very large dumps
Date: 2008-04-17 05:25:22
Message-ID: 9879.1208409922@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> writes:
>> Did you make the dump using 8.3's pg_dump?

> Yes, with 8.3.1's pg_dump (data only dump)

That would be your problem.  *Don't* use a data-only dump, it
lobotomizes all intelligence in the system and leaves it up to you
to deal with foreign-key ordering issues.  There are lots of
performance arguments against that as well.  See the advice at

http://www.postgresql.org/docs/8.3/static/populate.html

			regards, tom lane

In response to

Responses

pgsql-admin by date

Next:From: Achilleas MantziosDate: 2008-04-17 05:46:24
Subject: Re: Examining very large dumps
Previous:From: Phillip SmithDate: 2008-04-17 02:08:51
Subject: Re: Examining very large dumps

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