Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 2EEE96E7E0C
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 16:22:22 -0400 (AST)
Received: from mail-pz0-f46.google.com ([209.85.210.46])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>) id 1Ry7qO-0008Rq-Oo
	for pgsql-sql@postgresql.org; Thu, 16 Feb 2012 20:22:22 +0000
Received: by daed14 with SMTP id d14so2392886dae.19
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 12:22:07 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding;
	bh=cn/KNGKa0uc7K/VM6e0PhNBZL3nh7q2C3IAnZoVG6OU=;
	b=GDYpQQ/trDqkC+CAl94rGxi9HrbW1yNTobOKQStkMWNf33SCmSqzZB3lr1D0z70ETf
	MklhBtCh9r0TyYOm84FDyRp5AW9w5AS2AJw64DZ8zMvkHOvgMqhG/7lQlzSa3vHVFEie
	EeXlyF5OBUUth0YsrzzsjgYuNTm4uvvfd5SY4=
Received: by 10.68.190.4 with SMTP id gm4mr16879434pbc.95.1329423727737;
	Thu, 16 Feb 2012 12:22:07 -0800 (PST)
Received: from [192.168.0.135] (c-24-17-179-185.hsd1.wa.comcast.net.
	[24.17.179.185])
	by mx.google.com with ESMTPS id z10sm3123861pbq.55.2012.02.16.12.22.06
	(version=SSLv3 cipher=OTHER); Thu, 16 Feb 2012 12:22:07 -0800 (PST)
Message-ID: <4F3D656E.50900@gmail.com>
Date: Thu, 16 Feb 2012 12:22:06 -0800
From: Adrian Klaver <adrian.klaver@gmail.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
	rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
To: "Edward W. Rouse" <erouse@comsquared.com>
CC: pgsql-sql@postgresql.org
Subject: Re: pg_dump - 8.3 - schemas
References: <06c601ccecdd$2cbeefa0$863ccee0$@com> <4F3D574A.9010709@gmail.com>
	<06ca01ccece1$8c86c120$a5944360$@com> <4F3D5B49.3000807@gmail.com>
	<06ce01ccece8$0cf851b0$26e8f510$@com>
In-Reply-To: <06ce01ccece8$0cf851b0$26e8f510$@com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201202/54
X-Sequence-Number: 36347

On 02/16/2012 12:17 PM, Edward W. Rouse wrote:
> Well, when I do a restore using the created file, reports isn't there. i.e.
> the select from reports.table gives an error and, from psql, \l doesn't list
> it and \dn doesn't show it. But that all does work on the original database.

What is the error reported?
What do the Postgres logs show when you restore the data?
Do a pg_restore -l against the dump file. This will list the contents of 
the dump. See if the schema and contents are there.


>

>


-- 
Adrian Klaver
adrian.klaver@gmail.com