Re: [HACKERS] pg_dump - segfault with -z option - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] pg_dump - segfault with -z option
Date
Msg-id 26339.911924746@sss.pgh.pa.us
Whole thread Raw
In response to pg_dump - segfault with -z option  (Karl Auer <auer@kom.id.ethz.ch>)
Responses Re: [HACKERS] pg_dump - segfault with -z option  (Karl Auer <auer@kom.id.ethz.ch>)
Re: [HACKERS] pg_dump - segfault with -z option  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-hackers
Karl Auer <auer@kom.id.ethz.ch> writes:
> When I use the "-z" option (dump permissions)when dumping a database I
> have, I get a segfault and no output.

Are you on Postgres 6.4?  I recall fixing several nasty problems with
permissions in pg_dump between 6.3.2 and 6.4.

If you are on 6.4, could you use gdb or something to get a backtrace
showing exactly where pg_dump dies?

FWIW, I currently use -z routinely, but my database is probably even
simpler than yours ... no triggers, for example.  My guess is pg_dump
doesn't work for permissions attached to a trigger, or something along
that line.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] Parser bug?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] pg_dump - segfault with -z option