Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 1276164FC77
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  2 Nov 2008 19:35:06 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 12767-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sun,  2 Nov 2008 19:35:05 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from wa-out-1112.google.com (wa-out-1112.google.com
 [209.85.146.180])
	by mail.postgresql.org (Postfix) with ESMTP id 84C1764FC18
	for <pgsql-admin@postgresql.org>; Sun,  2 Nov 2008 19:35:05 -0400 (AST)
Received: by wa-out-1112.google.com with SMTP id j4so1202732wah.19
	for <pgsql-admin@postgresql.org>; Sun, 02 Nov 2008 15:35:04 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:cc:in-reply-to:mime-version:content-type
	:content-transfer-encoding:content-disposition:references;
	bh=nu9jd591FLQd3azT0rY51GY/IG6fMMblXLaB0F3c0gM=;
	b=hu3T69w0JHEw84wh8fHR+Pv/EOjcIH5NNHp+8a1y9gRQBLxtCtnwszwfTh8xOJ7Lt8
	wT89zkKSeOKJSX90LbRtCarM4OhF6h4DvzIAF5E9IhmWM7UsrFyLEma5gIKvGb1S1WlW
	6eyvqi69PkfTomwJAyM4IkwSqPlQ/+tFr3Z6E=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version
	:content-type:content-transfer-encoding:content-disposition
	:references;
	b=dy9WN4vhbJG8Eh4RMqtQp7Ll8RdcsEiJWf4NvEOL/UbtlC1lSHgtDrsvJsH7d8RUVZ
	brbvUFsamr71qnfOullspFS40jljSZanm38bzNEqyV34CwoHGXp0BpaXjsQdW47pcbQE
	lI8vXIQFfLr/aLpJH8f/KxhO3ChrGO7gIZGwo=
Received: by 10.114.170.2 with SMTP id s2mr4191279wae.23.1225668904106;
	Sun, 02 Nov 2008 15:35:04 -0800 (PST)
Received: by 10.114.39.11 with HTTP; Sun, 2 Nov 2008 15:35:04 -0800 (PST)
Message-ID: <dcc563d10811021535w7265e4dcl48739e7cfd6310af@mail.gmail.com>
Date: Sun, 2 Nov 2008 16:35:04 -0700
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Daniel Punton" <compass2k@gmail.com>
Subject: Re: pg_dump's table is empty
Cc: pgsql-admin@postgresql.org
In-Reply-To: <e969e33c0811021529w367956b6ta01e346461f4642c@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <e969e33c0811021529w367956b6ta01e346461f4642c@mail.gmail.com>
X-Archive-Number: 200811/4
X-Sequence-Number: 30658

On Sun, Nov 2, 2008 at 4:29 PM, Daniel Punton <compass2k@gmail.com> wrote:
> I am dumping postgres 7 tables under the postgres account  mydb# pg_dump -O
> -a -t mytable > mytable.out and am getting either
> empty dumps ( actual db tables are populated) or no dump at all.
> I have file write permissions and this process has worked in the past.
> Any suggestions what might be wrong?

Can you post an empty dump, or describe it more thoroughly?