Re: [GENERAL] out of memory error with loading pg_dumpall

2011-12-21 Thread Tom Lane
"Dara Olson" writes: > This is the first 1/3 of the errors, so hopefully this will help diagnose > where my problem may be. Any help would be greatly appreciated. Well, you didn't show us the error that caused a COPY to fail, but it's pretty obvious that you're attempting to load the dump into

Re: [GENERAL] out of memory error with loading pg_dumpall

2011-12-21 Thread Dara Olson
LY spatial_ref_sys ADD CONSTRAINT spatial_ref_sys_pkey PRIMARY KEY (srid); This is the first 1/3 of the errors, so hopefully this will help diagnose where my problem may be. Any help would be greatly appreciated. Thank you in advance. Dara - Original Message - From: Tom Lane T

Re: [GENERAL] out of memory error with loading pg_dumpall

2011-12-20 Thread Tom Lane
"Dara Olson" writes: > I am attempting to create an exact copy of our production database/cluster on > a different server for development. I created a dumpall file which is 8.7GB. > When I attempt to run this in psql on the new server it seems okay and then I > got a string of "invalid command