Subject Re: [firebird-support] Automating Firebird maintenance on Linux
Author Steve Wiser
We would also stop xinetd, kill existing connections, and connect to the database locally


On Tue, Apr 16, 2019 at 6:13 AM Dimitry Sibiryakov sd@... [firebird-support] <firebird-support@yahoogroups.com> wrote:
15.04.2019 18:23, myles@... [firebird-support] wrote:
> End users (and end user reporting applications, scripts, etc.) that connect to this
> database are often connected when I attempt to run these maintenance tasks, so I can never
> get the database to go to "offline" mode because of these connections.  I thought about
> scripting a server reboot, but that just scares me in terms of database integrity, etc.

   You can use gfix to shutdown database to single-user maintenance mode which will
prevent other users from connecting (unless they connect as SYSDBA).


--
   WBR, SD.


------------------------------------

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu.  Try FAQ and other links from the left-side menu there.

Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/firebird-support/join
    (Yahoo! ID required)

<*> To change settings via email:
    firebird-support-digest@yahoogroups.com
    firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
    firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
    https://info.yahoo.com/legal/us/yahoo/utos/terms/