Re: pg_dump's table is empty

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Daniel Punton" <compass2k(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_dump's table is empty
Date: 2008-11-02 23:35:04
Message-ID: dcc563d10811021535w7265e4dcl48739e7cfd6310af@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Sun, Nov 2, 2008 at 4:29 PM, Daniel Punton <compass2k(at)gmail(dot)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?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Matthieu Roger 2008-11-03 07:41:50 Crash with pg_clog file not found
Previous Message Daniel Punton 2008-11-02 23:29:31 pg_dump's table is empty