From: Tom Lane <tgl@sss.pgh.pa.us>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: pgsql-admin@postgresql.org
Cc: gnanam@zoniac.com
Subject: Re: Database clone stuck in the middle
Date: Fri, 02 Apr 2010 10:16:56 -0400
Message-ID: <10433.1270217816@sss.pgh.pa.us> (raw)
In-Reply-To: <4BB5AD0C0200002500030365@gw.wicourts.gov>
References: <009e01cad22e$a3121400$e9363c00$@com>
<4BB5AD0C0200002500030365@gw.wicourts.gov>
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> "Gnanakumar" <gnanam@zoniac.com> wrote:
>> my Internet got disconnected in the middle,
>> so database cloning was also stuck in the middle.
> 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.)
The whole thing is quite odd: even if the client connection failed,
I'd have expected the CREATE DATABASE command to run to completion
before noticing that. (Occasionally we get dinged for the fact that
loss of connection doesn't stop the executing command, but in contexts
like this it's a good thing.) Using nohup or not on the psql process
shouldn't have made any difference. I wonder whether the OP is doing
something weird like launching the server as a subprocess of his login
shell.
Another possibility (if the source is a really big database) is that
the copy operation is actually still going on. I'd make real sure the
old session is gone before trying to manually remove the allegedly-dead
subdirectory.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, Kevin.Grittner@wicourts.gov, gnanam@zoniac.com
Subject: Re: Database clone stuck in the middle
In-Reply-To: <10433.1270217816@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox