Skip site navigation (1) Skip section navigation (2)

"pg_ctl -m fast stop" doesn't shut down with active COPY

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: "pg_ctl -m fast stop" doesn't shut down with active COPY
Date: 2009-03-12 18:25:47
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
This is a repost of:

I didn't get any response, and it appears to be in contradiction to the

"SIGINT -- The server disallows new connections and sends all existing
server processes SIGTERM, which will cause them to abort their current
transactions and exit promptly."

If you have an open COPY and no data is moving, it simply won't
terminate it. You can terminate it with ctrl-C from psql, but not a
SIGINT to the postmaster or a SIGINT or SIGTERM to the backend.

	Jeff Davis

pgsql-bugs by date

Next:From: Julio TavaresDate: 2009-03-13 13:43:29
Subject: Help with PostgreSql and OID missmatches when restoring database with lobs
Previous:From: Tom LaneDate: 2009-03-11 21:02:16
Subject: Re: BUG #4700: SIGSEGV with incorrect input to to_char function

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group