Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 1874B6E7E0C
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 15:39:07 -0400 (AST)
Received: from mail-pw0-f46.google.com ([209.85.160.46])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <adrian.klaver@gmail.com>) id 1Ry7AY-0007hR-FC
	for pgsql-sql@postgresql.org; Thu, 16 Feb 2012 19:39:07 +0000
Received: by pbcun15 with SMTP id un15so2835721pbc.19
	for <pgsql-sql@postgresql.org>; Thu, 16 Feb 2012 11:38:53 -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=IRgaA+xPASVoRoC+Avo/Au/ax/FWvvELNv9Cg74x/r4=;
	b=TTFa9gw1/fX8U4uhDiflN1ZfxXvdOTCrL8uOFtJ6bn8jZ8jTMq6GiRH1AsRh9+n0Ti
	v6zOfFQqKb1x1Kcl9ymwU/ZZ+TJ4RkAb7Su2kq+qiAvcreLHyffpZq2DAAZ9lUtCeDkE
	p/MpG/GVMDv6VC3VTmFBw/+3KaOrD198s2d14=
Received: by 10.68.218.167 with SMTP id ph7mr16527400pbc.110.1329421133651;
	Thu, 16 Feb 2012 11:38:53 -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 b4sm14614422pbc.7.2012.02.16.11.38.51
	(version=SSLv3 cipher=OTHER); Thu, 16 Feb 2012 11:38:53 -0800 (PST)
Message-ID: <4F3D5B49.3000807@gmail.com>
Date: Thu, 16 Feb 2012 11:38:49 -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>
In-Reply-To: <06ca01ccece1$8c86c120$a5944360$@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/52
X-Sequence-Number: 36345

On 02/16/2012 11:31 AM, Edward W. Rouse wrote:
> To answer the second question first, yes; both as the same user.
>
> pg_dump -v -f $bkfile -F c -U $USER $DATABASE


So how are you determining that only the public schema is being dumped?
One thing to check is the search_path setting in postgresql.conf. This 
can create the illusion that only one schema is available in a database. 
One way to check is to use the fully qualified name for a table you know 
to be in the reports schema. Ex:

select * from reports.some_table;

>
>
>
>
-- 
Adrian Klaver
adrian.klaver@gmail.com