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