pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Achilleas Mantzios <achill@matrix.gatewaynet.com>
To: pgsql-admin@postgresql.org
Subject: Re: Examining very large dumps
Date: Thu, 17 Apr 2008 08:46:24 +0300
Message-ID: <200804170846.24713.achill@matrix.gatewaynet.com> (raw)
In-Reply-To: <9879.1208409922@sss.pgh.pa.us>
References: <200804161235.27157.achill@matrix.gatewaynet.com>
	<200804170818.47160.achill@matrix.gatewaynet.com>
	<9879.1208409922@sss.pgh.pa.us>

Óôéò Thursday 17 April 2008 08:25:22 ï/ç Tom Lane Ýãñáøå:
> Achilleas Mantzios <achill@matrix.gatewaynet.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
> 

Ooops, now it seems i have an issue.
The whole point i went this way, was because i wanted to have a schema-only dump first,
in order to clean it from everything it had to do with contrib/tsearch2, contrib/intarray, dbsize
as well as to edit the triggers (substitute tsearch2 with tsvector_update_trigger), update the tsearch2 indexes
to use GIN.

So the plan was:
1) i take the schema-only dump
2) i edit the schema dump
3) i create the db
4) import _int.sql
5) import the schema
6) restore data
This procedure is kind of the official upgrade noted on http://www.sai.msu.su/~megera/wiki/Tsearch2_83_changes
and described on http://sql-info.de/postgresql/notes/converting-tsearch2-to-8.3.html

> http://www.postgresql.org/docs/8.3/static/populate.html
I am reading this link right away.

Any thoughts very welcome.
> 
> 			regards, tom lane
> 



-- 
Achilleas Mantzios



view thread (9+ messages)  latest in thread

Message-ID: <200804170846.24713.achill@matrix.gatewaynet.com>
Permalink:  ../200804170846.24713.achill@matrix.gatewaynet.com/
Also on:    postgresql.org/message-id/200804170846.24713.achill@matrix.gatewaynet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: achill@matrix.gatewaynet.com
  Subject: Re: Examining very large dumps
  In-Reply-To: <200804170846.24713.achill@matrix.gatewaynet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox