Skip site navigation (1) Skip section navigation (2)

Re: R: How to move a DB from one server to another...

From: Harald Armin Massa <haraldarminmassa(at)gmail(dot)com>
To: "Federico Simonetti (Etheye)" <flame(at)etheye(dot)com>
Cc: pgsql-hackers-win32(at)postgresql(dot)org
Subject: Re: R: How to move a DB from one server to another...
Date: 2005-06-23 10:13:41
Message-ID: 7be3f35d05062303136c44b6e0@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers-win32
Federico, 

> Of course we could use SQL (CREATE DATABASE, CREATE TABLE, INSERT 
> INTO....)
> but this would take years on large databases, while a rough "copy this
> folder to the new server" would take just a few seconds.
> 

I do copys of databases every other day. pg_dump and pg_restore work like a 
breeze on databases with around 1 gig of stuff, and I do not even use the 
binary format and use intermediate files.

Where ist the performance bottleneck you are speaking of? 

Harald

-- 
GHUM Harald Massa
persuasion python postgresql
Harald Armin Massa
Reinsburgstra├če 202b
70197 Stuttgart
0173/9409607

In response to

Responses

pgsql-hackers-win32 by date

Next:From: Andrew DunstanDate: 2005-06-23 11:47:18
Subject: Re: How to move a DB from one server to another...
Previous:From: John A MeinelDate: 2005-06-23 06:35:56
Subject: Re: R: How to move a DB from one server to

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group