Postgres Pro
Downloads
Home   >   mailing lists

restore large database - Mailing list pgsql-general

From Wenyan Ji
Subject restore large database
Date
Msg-id 42B6BEA7.1050500@flymine.org
Whole thread Raw
Responses Re: restore large database  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: John Burger
Date:
Subject: Re: plpgsql constraint checked data fails to restore
Next
From: "Ilja Golshtein"
Date:
Subject: (2) failed to find conversion function from "unknown" to ...