I am consistently running into an "out of memory" error when using pg_dump. The error occurs after the step "saving database definition". This error occurs on both windows(9.1.4) and solaris(9.0.4) against postgresql running on solaris (9.0.4). The database has about 5GB of data...not particularly large.
...pg_dump: reading constraintspg_dump: reading triggerspg_dump: reading large objectspg_dump: reading dependency datapg_dump: saving encoding = UTF8pg_dump: saving standard_conforming_strings = offpg_dump: saving database definitionpg_dump: [archiver] out of memorypg_dump: *** aborted because of error
Steps already taken:1) PostgreSQL server log shows no messages2) Each table can be dumped, and so can the schema3) All data from each table, when restored into another database on the same server, can be dumped without issue.
Thanks, Joe