From: | g(dot)hintermayer(at)inode(dot)at (Gerhard Hintermayer) |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | database shutdown with persistent client connections |
Date: | 2002-07-31 07:47:12 |
Message-ID: | bd4db85f.0207302347.10c3627a@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a database server with multiple databases (~5) and some
persistent connections using the pgtcl interface.
If I want to shutdown the database server (smart mode) my persistant
connections prevent the postmaster from shuting down (as documented),
if I user fast mode, the shutdown get's done, but without any
notification to the clients. An error is only triggered, if I issue
sql commands, but unfortunately some applications send commands at a
very low rate, but i'd like to get the shutdown information
immediatly.
using LISTEN gives me an error message immediately when issuing the
shutdown
> FATAL 1: This connection has been terminated by the administrator.
>no connection to the server
obviously there seems to be some notification, but I do not know it's
name :-(
I thought of sending notifications by hand before invoking "pg_ctl
stop -m fast" but I don't want to reinvent the wheel.
Is there a notification sen't out in either smart or fast shutdown
mode ?
Gerhard
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christian Imbeault | 2002-07-31 09:30:23 | Dataypes: performance differences? |
Previous Message | Christopher Kings-Lynne | 2002-07-31 07:24:39 | Re: [GENERAL] Stats Collector |