Postgres - import hands
Posted: Sat Jun 23, 2012 7:11 am
Hello,
After a drive format i just installed pt4 4.01.21 version, it came with postgres 8.3.9 version not 8.4.x.
After reading instuctions it is not clear to me whether i can move from postgres 8.3 to 8.4? In any case, do i have to, for better performance?
I have a backup of my DB with postgres 8.3.9.
i tried to "Vacuum Analyze" my database and an the following error occured
"Unable to execute query: VACUUM ANALYZE;; Reason:
FAtal Error (ERROR: out of memory DETAIL: Failed on
request of size 268435452.)
I use 12GB Ram I7 cpu.
Can u help? Thanks
After a drive format i just installed pt4 4.01.21 version, it came with postgres 8.3.9 version not 8.4.x.
After reading instuctions it is not clear to me whether i can move from postgres 8.3 to 8.4? In any case, do i have to, for better performance?
I have a backup of my DB with postgres 8.3.9.
i tried to "Vacuum Analyze" my database and an the following error occured
"Unable to execute query: VACUUM ANALYZE;; Reason:
FAtal Error (ERROR: out of memory DETAIL: Failed on
request of size 268435452.)
I use 12GB Ram I7 cpu.
Can u help? Thanks