Re: copying database? - Mailing list pgsql-general

From hubert depesz lubaczewski
Subject Re: copying database?
Date
Msg-id 20020304125550.A26811@depesz.pl
Whole thread Raw
In response to Re: copying database?  ("Holger Marzen" <holger@marzen.de>)
List pgsql-general
On Mon, Mar 04, 2002 at 12:26:50PM -0100, Holger Marzen wrote:
> > pg_dump is nto an option - due to time of inserting >1G data into new
> > database.
> You can pipe the output to gzip (makes the file probably smaller) or split
> (splits it into smaller pieces). Restore with "cat file1 file2 file2 | psql dbname".

the problem is not in transferring data, but in insert time.

depesz

--
hubert depesz lubaczewski                          http://www.depesz.pl/
------------------------------------------------------------------------
... vows are spoken to be broken ...                 [enjoy the silence]
... words are meaningless and forgettable ...             [depeche mode]

pgsql-general by date:

Previous
From: "Raymond O'Donnell"
Date:
Subject: Re: April 1
Next
From: Ioannis
Date:
Subject: postgre performance question