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

pg_dump's table is empty

From: "Daniel Punton" <compass2k(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump's table is empty
Date: 2008-11-02 23:29:31
Message-ID: e969e33c0811021529w367956b6ta01e346461f4642c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

Responses

pgsql-admin by date

Next:From: Scott MarloweDate: 2008-11-02 23:35:04
Subject: Re: pg_dump's table is empty
Previous:From: Guillaume LelargeDate: 2008-11-02 12:42:09
Subject: Re: autovacuum questions v2

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