Re: Shutting down pgsql

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Mark Warner <hammerhed(at)theitspecialists(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Shutting down pgsql
Date: 2003-12-11 15:53:37
Message-ID: 13628.1071158017@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Mark Warner <hammerhed(at)theitspecialists(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Nairn 2003-12-11 16:00:11 Problem connecting to psql
Previous Message Andrei Bintintan 2003-12-11 15:42:57 Re: Help---- Urgent