Обсуждение: pg_dump's table is empty

Поиск
Список
Период
Сортировка

pg_dump's table is empty

От
"Daniel Punton"
Дата:
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

Re: pg_dump's table is empty

От
"Scott Marlowe"
Дата:
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?