Wenyan Ji wrote:
I am trying to restore a large database and use the commond
cat dumpfilename | psql dbname
I got a out of memory error when it is trying to copy a String with size
of 245,000,000
Can anyone shed some light on it? Thanks for your help,
Why are you using cat rather than just:
psql dbname < dumpfilename
or
psql -f dumpfilename dbname
Also, what was the precise error message?
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
