Wed, 19 Dec 2012 00:03:43 -0800 (PST)
Received: by 10.49.127.198 with SMTP id ni6mr757036qeb.23.1355904223562; Wed,
19 Dec 2012 00:03:43 -0800 (PST)
X-Newsgroups: pgsql.general
Date: Wed, 19 Dec 2012 00:03:43 -0800 (PST)
Complaints-To: groups-abuse(at)google(dot)com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=78.125.169.178;
posting-account=pYzPGgoAAAAC0dQ98Mj0cSM3RRz4sF8G
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <245b4d77-eb37-4888-a1cc-e27487de9436(at)googlegroups(dot)com>
Subject: pg_dump on 8.3, restore on 9.1 takes hours
From: martyn(dot)clement(at)gmail(dot)com
Injection-Date: Wed, 19 Dec 2012 08:03:43 +0000
Content-Type: text/plain; charset=ISO-8859-1
To: pgsql-general(at)postgresql(dot)org

Hi,

I'm currently replacing an old server and I am thinking about upgrading postgresql which is actually a 8.3 version.
I freshly installed a Ubuntu 12.04 and installed postgresql 9.1 via apt-get.

My dump size is about 40Mo and was made with :
>> pg_dump -d mydb -U myuser | gzip > pgdump.zip

On the otherside I restore my dump with :
>> gunzip -c pgdump.zip | psql mynewdb -U myuser -W

Then it takes **hours**. At least 8h, I didn't wait the end.
To me, 40Mo dump must be restored in less than 1h.

For information, my db is hosting datas from a django application and uses PostGis.

Thank you for your lights