Re: Dump

Mihai Gheorghiu <tanhq(at)bigplanet(dot)com> writes:
> pg_dump... outputs nothing!? I did it with -f filename too, and the file is
> empty.
> Size of the file in question: 5MB, 7062 rows. Name of table:
> tblReservations.

Mixed case huh? It's a little tricky to get pg_dump's -t switch to work
with that; I think you have to write
pg_dump -s -t '"tblReservations"' dbname ...
Without the quoting, pg_dump lowercases the given name.

> I wanted to re-create the error today, but I got something different:
> pg_dump tantest > tantest.bak
> pqWait() -- connection not open
> PQendcopy: resetting connection

Hmm, that looks like a backend coredump. Did you find a core file in
the database directory? If so, can you get a backtrace from it?

regards, tom lane