Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group