Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 312E6133740B
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  9 May 2011 06:35:57 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 19045-09 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon,  9 May 2011 09:35:50 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com
	[209.85.220.174])
	by mail.postgresql.org (Postfix) with ESMTP id 1B0F6133616B
	for <pgsql-admin@postgresql.org>; Mon,  9 May 2011 06:35:49 -0300 (ADT)
Received: by vxi39 with SMTP id 39so5552088vxi.19
	for <pgsql-admin@postgresql.org>; Mon, 09 May 2011 02:35:50 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:date:message-id:subject:from:to
	:content-type; bh=tGTBxyKg1jX3Xtj8zsKjPaD9cwq2L8+JT0EhNXt5oKE=;
	b=TvKFU8L4X6QF/zQzGhJOQpDSpp1s/KRYFyu6GupPuuAuLWpyA0fMzvL0XCiMa4EBNf
	SpwQD4AITyytOtHlQkFrtWg17cmdhIEhoeuB2sAGcDz99tXA7n5UNmJKds4cmNIs2yPL
	0cLWzVVdQ2a1pM/R3ZzfGIe1VGjDBKLMUfutY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=cjnJnyZrPz6MSZ9PuNGpWkry7lQngMer0x0Nlei5Z81nrYBIcL/lqrp0M4caPH17Xw
	FFc3sRQdqYBDYaYbubMdI89SZ+g72IK8Va/6GQ4IoU2HryJjpx2HcHmc7Ftqp183X1qN
	cvrQqD97s1ahuBxEMAm87SIPo/gW6PBmqCnjY=
MIME-Version: 1.0
Received: by 10.52.76.38 with SMTP id h6mr2634993vdw.156.1304933750083; Mon,
	09 May 2011 02:35:50 -0700 (PDT)
Received: by 10.220.182.202 with HTTP; Mon, 9 May 2011 02:35:50 -0700 (PDT)
Date: Mon, 9 May 2011 11:35:50 +0200
Message-ID: <BANLkTimSYrirVHhMCpqMkEhxjKBz4Cyo+Q@mail.gmail.com>
Subject: db restore takes to long
From: =?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor.bojovic@gmail.com>
To: pgsql-admin@postgresql.org
Content-Type: multipart/alternative; boundary=20cf3071cfd0a1112e04a2d49069
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.887 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001,
	RFC_ABUSE_POST=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201105/71
X-Sequence-Number: 37508

--20cf3071cfd0a1112e04a2d49069
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi,

im trying to restore 250GB database, but indexing takes too long, so restor=
e
takes more then 12h.
Is it possible to disable indexing while restoring database?

Thanx in advance


--=20
---------------------------------------
Viktor Bojovi=C4=87
---------------------------------------
Wherever I go, Murphy goes with me

--20cf3071cfd0a1112e04a2d49069
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div>Hi,<br clear=3D"all"></div><div><br></div><div>im trying to restore 25=
0GB database, but indexing takes too long, so restore takes more then 12h.<=
/div><div>Is it possible to disable indexing while restoring database?</div=
>
<div><br></div><div>Thanx in advance</div><div><br></div><br>-- <br>-------=
--------------------------------<br>Viktor Bojovi=C4=87<br>----------------=
-----------------------<br>Wherever I go, Murphy goes with me<br>

--20cf3071cfd0a1112e04a2d49069--