Обсуждение: restore large database

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

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