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@xxxxxxxxxx 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@xxxxxxxxxxxxxxxx> Subject: pg_dump on 8.3, restore on 9.1 takes hours From: martyn.clement@xxxxxxxxx Injection-Date: Wed, 19 Dec 2012 08:03:43 +0000 Content-Type: text/plain; charset=ISO-8859-1 To: pgsql-general@xxxxxxxxxxxxxx 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
