Forum OpenACS Q&A: upgrading to Postgres 7.1.2

Collapse
Posted by Janine Ohmer on
Has anyone upgraded a pre-3.2.5 site to Postgres 7.1.2?  Don
left me some notes about coding changes which might be
required, but they were kinda vague.  If anyone has an actual list
of what files need to be changed I will be forever grateful!
Collapse
Posted by Patrick Giagnocavo on
I don't know about the coding changes required, however, this is probably as good a place as any to point out that pg_dump will take up a lot of RAM when dumping data (which you will then import into your new database).

I have found that at least under OpenBSD, and I am sure some other OSes as well, the default limits on max data size, etc. can cause pg_dump to be killed off by the kernel.

To fix:  look at current limits with "ulimit -a" , increase data size limits with ulimit -d {number of kbytes}, then re-run pg_dump.

For my tables, I find that pg_dump needs about 95 to 100MB to successfully dump.