Skip site navigation (1) Skip section navigation (2)

Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: David Schnur <dnschnur(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org,pgsql-bugs(at)postgresql(dot)org
Subject: Re: [ADMIN] Repeatable crash in pg_dump (with -d2 info)
Date: 2012-08-27 13:58:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-adminpgsql-bugs
On Tue, Jan 17, 2012 at 04:46:50PM -0500, David Schnur wrote:
> I finally had time to test this further on a variety of systems, and was unable
> to reproduce on any non-Windows platform.  The dump even works fine on Windows
> XP; just not Windows 7.
> This prompted me to do a little more research, and this time I found this
> thread from Sept. 2011:
> BUG-6233-pg-dump-hangs-with-Access-Violation-C0000005-td4851598.html
> From Tom Lane in the above thread:
>     Hmm.  I can see how that would happen if you're using one of the Windows 
>     environments wherein malloc's done inside libpq have to be free'd inside 
>     libpq.  (The PQExpBuffer support code is in libpq...) 
>     However, the flaw in that explanation is that it would basically mean 
>     pg_dump doesn't work at all on Windows, at least not if you have any 
>     user-defined functions, and probably some other cases too because there 
>     seem to be multiple instances of the dubious coding.  It's a bit hard to 
>     believe that nobody's noticed that before. 
> This appears to describe exactly the issue I'm encountering, and my build is in
> fact linked against the static runtime.  I guess the reason this hasn't come up
> sooner is because most Windows users either use the 'official' binaries rather
> than compiling from source, or link against the dynamic runtime.
> Is this something I could expect to be fixed in the near future, or is it
> enough of an edge case that I should come up with some solution or work-around
> on my own?  Thanks,

Late reply, but I don't see any way we could fix this easily.

  Bruce Momjian  <bruce(at)momjian(dot)us>

  + It's impossible for everything to be true. +

In response to


pgsql-admin by date

Next:From: Amador AlvarezDate: 2012-08-27 19:12:22
Subject: Looking for a better approach for pacemaker, DRDB VS pgsql 9.1 standby feature.
Previous:From: Andreas SchmitzDate: 2012-08-25 22:33:38
Subject: Re: Canot access PostgreSQL via psql -h (Vmware Fusion)

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2012-08-27 14:15:55
Subject: Re: BUG #6401: IS DISTINCT FROM improperly compares geomoetric datatypes
Previous:From: 沈前卫Date: 2012-08-27 06:16:01
Subject: Re: BUG #7504: corrupted statistics file "pg_stat_tmp/pgstat.stat"

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group