Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4D37F64FD83 for ; Sun, 2 Nov 2008 19:29:34 -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 11628-10 for ; Sun, 2 Nov 2008 19:29:33 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.158]) by mail.postgresql.org (Postfix) with ESMTP id B40B964FD81 for ; Sun, 2 Nov 2008 19:29:33 -0400 (AST) Received: by fg-out-1718.google.com with SMTP id 16so2011180fgg.23 for ; Sun, 02 Nov 2008 15:29:32 -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:mime-version:content-type; bh=pa29IAqTYPM+9Svbee+XeShaFrVSS6V8+5odI8uSMok=; b=MNWr9/vI5E+fFCOr7kkpVkNuHrmHAgwkG4fnrcg6sV9k+/knTsVecKINeEIvaTdjNK etKaD/QflYgA/Tz3SdTgmlDwc7hz5fP/q7DqciH2T71bRzzXCFaEpG4OkbGV2Dt7VgLW SR+Ys7453H13D3uh7yi7NvsPc44FLipBUTj6E= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type; b=XACMVX+CoYEyRXzKHNS4fHDRzF1tkgLg+bXPfl1/JCzCKOtHZxbuxns4JjhZNTPvLr /np7RoP7Sm+nykfPCNYdGPKIe0/hpEoRBIwlFnc+Bk/BUDqJumWgYOAV8vD4+ONvXbWA RuafC0s6+3ESfcdVWQKzHoICs5dB+zF6LHa7I= Received: by 10.181.234.8 with SMTP id l8mr3998722bkr.105.1225668571902; Sun, 02 Nov 2008 15:29:31 -0800 (PST) Received: by 10.180.204.4 with HTTP; Sun, 2 Nov 2008 15:29:31 -0800 (PST) Message-ID: Date: Mon, 3 Nov 2008 10:29:31 +1100 From: "Daniel Punton" To: pgsql-admin@postgresql.org Subject: pg_dump's table is empty MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_24789_9875966.1225668571362" X-Archive-Number: 200811/3 X-Sequence-Number: 30657 ------=_Part_24789_9875966.1225668571362 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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? Cheers Dan ------=_Part_24789_9875966.1225668571362 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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?

Cheers
Dan
------=_Part_24789_9875966.1225668571362--