Re: pg_dump on Postgres 9.1

On this issue, instead of going for a newer version of xlc, as suggested, I opted to get a newer version of the Postgres source code, 9.1.4. After compiling it with the same xlc version, I found that pg_dump works as expected. So, the problem appears to be somewhere in the 9.1 source code, at least for binaries created from it for AIX (6.1).

Regards.

Alanoly.

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, July 27, 2012 12:13 PM
To: Alanoly Andrews
Cc: 'pgsql-admin(at)postgresql(dot)org'
Subject: Re: [ADMIN] pg_dump on Postgres 9.1

Alanoly Andrews <alanolya(at)invera(dot)com> writes:
> Is there any reported bug with pg_dump in Postgres 9.1, on AIX ? The following command hangs for "ever" and has to be interrupted. It creates a zero-length file.

We had a recent report of strange server-side behavior on AIX that went away after rebuilding with a newer version of xlc, suggesting that the code was getting bitten by an xlc optimization bug. Perhaps this is the same thing inside pg_dump. If you're not using the latest xlc, try updating. If you are, does rebuilding with -O0 change the behavior?

regards, tom lane
****************************************************
This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courriel est confidentiel et protg. L'expditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) dsign(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immdiatement, par retour de courriel ou par un autre moyen.
****************************************************