Re: Shutting down pgsql - Mailing list pgsql-admin

From Tom Lane
Subject Re: Shutting down pgsql
Date
Msg-id 13628.1071158017@sss.pgh.pa.us
Whole thread Raw
In response to Shutting down pgsql  (Mark Warner <hammerhed@theitspecialists.net>)
List pgsql-admin
Mark Warner <hammerhed@theitspecialists.net> writes:
>     Is it possible, advisable, or terribly bad to shutdown a pgsql
> database with the do.maintenance script running?

You didn't say exactly what that script is doing ... but in general
PG queries can be shut down safely.  What I'd do is kill the client
program running the script and then send SIGINT to the backend it's
connected to.  Shutting down the whole database is the hard way.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Andrei Bintintan"
Date:
Subject: Re: Help---- Urgent
Next
From: Richard Nairn
Date:
Subject: Problem connecting to psql