restore large database

[Wenyan Ji <wenyan@xxxxxxxxxxx>]

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,

wenyan

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org