Message-ID: <4BB5F8F0.10908@lelarge.info>
Date: Fri, 02 Apr 2010 16:02:24 +0200
From: Guillaume Lelarge <guillaume@lelarge.info>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; fr;
	rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
CC: pgsql-admin@postgresql.org, gnanam@zoniac.com
Subject: Re: Database clone stuck in the middle
References: <009e01cad22e$a3121400$e9363c00$@com>
	<4BB5AD0C0200002500030365@gw.wicourts.gov>
In-Reply-To: <4BB5AD0C0200002500030365@gw.wicourts.gov>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit

Le 02/04/2010 15:38, Kevin Grittner a écrit :
> "Gnanakumar" <gnanam@zoniac.com> wrote:
>  
>> I connect to our database which is hosted remotely using PuTTY
>> thro SSH protocol.  
>  
>> my Internet got disconnected in the middle,
>> so database cloning was also stuck in the middle.
>  
>> 4. Considering this Internet disconnection problem, what is the
>> safest way to clone a database using CREATE DATABASE WITH TEMPLATE
>> command, so that this will not happen in the future?
>  
> You putty to the server and run psql from a shell on the database
> server?
>  
> If so, try putting the word "nohup" in front of "psql" -- that tells
> the program to keep running even if the connection is lost.  (It is
> short for "no hangup", I believe.)
>  

Or use screen.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com