| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)pl> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: copying database? |
| Date: | 2002-03-04 11:55:50 |
| Message-ID: | 20020304125550.A26811@depesz.pl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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]
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ioannis | 2002-03-04 11:57:44 | postgre performance question |
| Previous Message | Raymond O'Donnell | 2002-03-04 11:35:56 | Re: April 1 |