|
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. Thanks, Joe |
