Hello, 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.
pg_dump -Fc alan1 > alan1.dmp If I run the command in the verbose mode, I see that it stops at "saving database definition". See below: ares> pg_dump -Fc alan1 -v > alan1.dmp pg_dump: too many command-line arguments (first is "-v") Try "pg_dump --help" for more information. /u/postgres ares> pg_dump -v -Fc alan1 > alan1.dmp pg_dump: reading schemas pg_dump: reading user-defined tables pg_dump: reading extensions pg_dump: reading user-defined functions pg_dump: reading user-defined types pg_dump: reading procedural languages pg_dump: reading user-defined aggregate functions pg_dump: reading user-defined operators pg_dump: reading user-defined operator classes pg_dump: reading user-defined operator families pg_dump: reading user-defined text search parsers pg_dump: reading user-defined text search templates pg_dump: reading user-defined text search dictionaries pg_dump: reading user-defined text search configurations pg_dump: reading user-defined foreign-data wrappers pg_dump: reading user-defined foreign servers pg_dump: reading default privileges pg_dump: reading user-defined collations pg_dump: reading user-defined conversions pg_dump: reading type casts pg_dump: reading table inheritance information pg_dump: reading rewrite rules pg_dump: finding extension members pg_dump: finding inheritance relationships pg_dump: reading column info for interesting tables pg_dump: finding the columns and types of table "student" pg_dump: finding the columns and types of table "a_rec" pg_dump: finding the columns and types of table "course" pg_dump: finding the columns and types of table "takes" pg_dump: flagging inherited columns in subtables pg_dump: reading indexes pg_dump: reading constraints pg_dump: reading triggers pg_dump: reading large objects pg_dump: reading dependency data pg_dump: saving encoding = LATIN1 pg_dump: saving standard_conforming_strings = on pg_dump: saving database definition ------------ Thanks. A.J.Andrews. **************************************************** 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 protégé. L'expéditeur 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) désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen. ****************************************************