Thread: pg_dump Error

Hi all,    while trying to dump db shcema and content, I am getting the
following error:
   [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql   PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
Segmentationfault (core dumped)
 

Any suggestion what I am doing wrong and why i am getting this error.
Thank you all in advance for your help
Regards.
Najm

Najm Hashmi <najm@mondo-live.com> writes:
>      while trying to dump db shcema and content, I am getting the
> following error:
>     [najm@localhost najm]$ pg_dump -D fliprdb > flipr.sql
>     PQgetvalue: ERROR! tuple number 0 is out of range 0..-1
>     Segmentation fault (core dumped)

Hmm, looks like you've managed to expose a bug in pg_dump.  It looks
like pg_dump is getting an empty result to some query that it's not
prepared to handle an empty result for, but there's not enough info
here to tell what that query is.

I'd suggest restarting the postmaster with -d2 and making sure its
output is going into a logfile (don't use -S switch), then rerun
pg_dump.  The last query shown in the postmaster log will be the one
that's causing a problem.  That'll give us more info to go on.

I'm thinking that the problem is something along the lines of a table
with no owner (ie, no corresponding entry in pg_shadow), but can't
tell for sure yet.
        regards, tom lane