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 constraints
pg_dump: reading triggers
pg_dump: reading large objects
pg_dump: reading dependency data
pg_dump: saving encoding = UTF8
pg_dump: saving standard_conforming_strings = off
pg_dump: saving database definition
pg_dump: [archiver] out of memory
pg_dump: *** aborted because of error
Steps already taken:
1) PostgreSQL server log shows no messages
2) Each table can be dumped, and so can the schema
3) All data from each table, when restored into another database on the same server, can be dumped without issue.