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

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