Re: Table has 22 million records, but backup doesn't see them

Поиск

Список

Период

Сортировка

От	Steve Crawford
Тема	Re: Table has 22 million records, but backup doesn't see them
Дата	8 апреля 2009 г. 12:25:27
Msg-id	49DCC1E0.6090609@pinpointresearch.com обсуждение исходный текст
Ответ на	Table has 22 million records, but backup doesn't see them (Radcon Entec <radconentec@yahoo.com>)
Список	pgsql-general

Дерево обсуждения

Radcon Entec wrote:

Greetings!

I'm running PostgreSQL 8.1 under Windows XP, looking at a database hosted on a machine running PostgreSQL under Windows Server 2003.

The database has a table with three simple columns and 22 million rows. I am trying to back up that table by itself. However, pg_dump finishes almost instantly, obviously not backing up any data from the table. I've tried it from the DOS command line with and without the -a (data only) option, and from inside PGAdmin. Can anyone suggest what might cause this behavior?

What is the exact command and what is the output (I'll be surprised if there is no output at all to either stdout or stderr)? Does pg_dumpall run fine from the same machine? How about psql? Are you sure you are hitting a base-table and not a view? Do the server logs show anything interesting?

Cheers,
Steve

В списке pgsql-general по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Re: Table has 22 million records, but backup doesn't see them