Thank you very much for sharing this "screen" command. That's really helpful.
-----Original Message----- From: Guillaume Lelarge [mailto:guilla...@lelarge.info] Sent: Friday, April 02, 2010 7:32 PM To: Kevin Grittner Cc: pgsql-admin@postgresql.org; gna...@zoniac.com Subject: Re: [ADMIN] Database clone stuck in the middle Le 02/04/2010 15:38, Kevin Grittner a écrit : > "Gnanakumar" <gna...@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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
