I cannot use screen, since my database server is hosted remotely. I have only command-line access to my server by PuTTY. -----Original Message----- From: Guillaume Lelarge [mailto:guillaume@xxxxxxxxxxxx] Sent: Friday, April 02, 2010 7:32 PM To: Kevin Grittner Cc: pgsql-admin@xxxxxxxxxxxxxx; gnanam@xxxxxxxxxx Subject: Re: Database clone stuck in the middle Le 02/04/2010 15:38, Kevin Grittner a écrit : > "Gnanakumar" <gnanam@xxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
