CSS Tools - Backup - Fatal Error - Postgres backup fails with an out of memory error
Description
When performing a cssbackup or postgres backup on a 32-bit machine, you may get a message for an out of memory error.
The error in the backup log will be something like this:
pg_dump: out of memory
Observed in CAST AIP
| Release | Yes/No |
|---|---|
| 8.3.x | ✅ |
Observed on RDBMS
| RDBMS | Yes/No |
|---|---|
| CSS | ✅ |
Impact on Analysis Results and Dashboard
Out of memory error when doing a backup operation.
Action Plan
The problem is due to the fact of using a 32-bit server to do the backup operation. The 32-bit OS has a limitation of only using 2 G of memory, so if you have a backup which is taking up a lot of memory you can hit this limit.
The solution is to
- Do the backup on the 64-bit database server either with the CAST CSS administration tools on windows or the postgres backup tools on Linux. CAST 7.2 and above requires that you use a 64-bit database server for CSS and Postgres.
Notes/comments
Related Pages