Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 98CC6B5D803
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Mon, 24 Oct 2011 21:41:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 72685-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue, 25 Oct 2011 00:41:08 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from nm20-vm0.bullet.mail.sp2.yahoo.com
	(nm20-vm0.bullet.mail.sp2.yahoo.com [98.139.91.218])
	by mail.postgresql.org (Postfix) with SMTP id 269D4B5DC5F
	for <pgsql-admin@postgresql.org>; Mon, 24 Oct 2011 21:41:08 -0300 (ADT)
Received: from [98.139.91.63] by nm20.bullet.mail.sp2.yahoo.com with NNFMP;
	25 Oct 2011 00:41:08 -0000
Received: from [98.139.91.57] by tm3.bullet.mail.sp2.yahoo.com with NNFMP;
	25 Oct 2011 00:41:08 -0000
Received: from [127.0.0.1] by omp1057.mail.sp2.yahoo.com with NNFMP;
	25 Oct 2011 00:41:08 -0000
X-Yahoo-Newman-Property: ymail-3
X-Yahoo-Newman-Id: 569877.81956.bm@omp1057.mail.sp2.yahoo.com
Received: (qmail 66579 invoked by uid 60001); 25 Oct 2011 00:41:08 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024;
	t=1319503268; bh=Wd1rgi7HIIuC6+m0LBYi8QPQKlEeoPtlXSInRPzKGAY=;
	h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=IksMgutgK0enG79veVFX5S1PTB8776Ma++blQmLm8RN0eGtmvUsaQDu9l7U9OLNYHU4t8h+wgL10RF/Eu+LErQByoDCXUMKt16xBsOKENs6uH3akQ4SwwCw6IldH9FNRKLkWMN9QCgCArhnejF4t+og2TiV+5zMEZlXfFUeAzEY=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=rrGWplTIPOGNSvFXdBQEIScuIV6K0KeCMnteIEbnrrMO7/2yIChvnvPdImwcy3j288OvMk1jvBGnGNCTf5fWOy/cHGVyxv+fMPLf1dT90llcID2Fpto7EvUYzj2LCZX8gKZrsj83+Vpz+TUJCg16pvvUr73iVHZrvcKK0hahyVc=;
X-YMail-OSG: cmwXHbEVM1kVCNCugrqP1tQmNf2.al8eidpCYHnoeKnOLVF
	xmJvaRf_pbT7udr9_NdsdQwdyMv3mw_JUnqMRkzieWvrLqR7_5EPjbbDFiz8
	5ZHxr7CN5rWbyYz1s_Xxrktt5OyGo9xnJc6PJIg91MGB0MzRT0oh7Ayfo3bi
	2IJ_fjJU9ZHHx0CuHcoJTvyGdvWNSlBELZ6icVL.gO.1EaaPBhc6_faerj_n
	6gGiTD3VA7Q05pDlpyiLR5wGELQCt4xVlaXeQMYkXSFLfKNxrK6T6K.A81qF
	VtbGB0JEA_0xchOGH.VXF6Gd.NJBlvdOHILbm1J.LmGFg7f0NhNfO8KTRg7u
	ToqF5evsnfaMJzgrpiYbMdhdpPjtXgm1C9gP3UmW7wJdnJxaR1ZTfLaebyL5
	rAko_.iDPI1wh09LVjQHtsXLJ9x8EW90FipKKy.eL
Received: from [206.80.5.2] by web46110.mail.sp1.yahoo.com via HTTP;
	Mon, 24 Oct 2011 17:41:07 PDT
X-Mailer: YahooMailWebService/0.8.114.317681
References: <1319493368.35732.YahooMailNeo@web46108.mail.sp1.yahoo.com>
	<CALnrrJQiBwb4ym1DBASzQR2pbdPnYueJmQWwOXSweKhpa-cYxA@mail.gmail.com>
Message-ID: <1319503267.66489.YahooMailNeo@web46110.mail.sp1.yahoo.com>
Date: Mon, 24 Oct 2011 17:41:07 -0700 (PDT)
From: Greg Williamson <gwilliamson39@yahoo.com>
Reply-To: Greg Williamson <gwilliamson39@yahoo.com>
Subject: Re: postgres 9.0.4, pg_restore and indexes
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: 
 <CALnrrJQiBwb4ym1DBASzQR2pbdPnYueJmQWwOXSweKhpa-cYxA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.121 tagged_above=-10 required=5
	tests=BAYES_00=-1.9, FREEMAIL_ENVFROM_END_DIGIT=0.1, FREEMAIL_FROM=0.001,
	FREEMAIL_REPLYTO_END_DIGIT=1.151, MISSING_HEADERS=1.021,
	RCVD_IN_DNSWL_NONE=-0.0001, RP_MATCHES_RCVD=-0.504,
	T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201110/110
X-Sequence-Number: 38562

Raghu Ram wrote:=0A=0A<snip>=0A=0A>=0A>Try with below work-around to restor=
e only hosts table from compressed dump file:=0A>=0A>=0A>"pg_restore -t=A0h=
osts=A0-Fc=A0/var/data/pgsql/backups/prodDB/20111017_puppet.pgdump=A0> host=
s_plaindump" [ i.e you'll get a human-readable dump ]=0A>=0A=0A=0ADid you a=
ctually try this ?=0A=0AThis does not include any references to indexes, co=
nstraints or sequences, all of which it might be useful to recreate.=0A=0AW=
hat I am I missing ? Or is pg_restore just not capable of restoring the ful=
l definition of a table ?=A0=0A=0ATIA,=0A=0AGreg WIlliamson