Re: restore large database

From: Richard Huxton <dev(at)archonet(dot)com>
To: Wenyan Ji <wenyan(at)flymine(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: restore large database
Date: 2005-06-20 13:54:44
Message-ID: 42B6CAA4.6030904@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-06-20 13:57:26 Re: Help! What has changed in the internal structure of
Previous Message O.B. 2005-06-20 13:43:01 Re: Access is denied during initdb