RE: [firebird-support] Firebird Embedded on web hosting

If the computer loses power (and is turned off) when Firebird is writing to the database, the database may become corrupt. Are there any firebird settings that can make it so that there is a smaller chance of database corruption? Glenn Thomas Hvidsten From: firebird-support@yahoogroups.com

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Hi, > We have FirebirdSQL (2.1) running on a client computer (Windows). > This client has some problems with his power grid which causes the > PC to suddenly and unexpectedly shut down in infrequent intervals > (usually once or twice per day). Most of the time this doesn’t > cause any problems,

Re: [firebird-support] Firebird Embedded on web hosting

The only protection that I found until now is to use forced writes on the database. this can save you from real troubles. Without this option turned off you might lose some data even when your database is in perfect shape. With forced writes you have the guarantee that at least until the last

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Where do I find that setting? Glenn Thomas Hvidsten From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 21. september 2015 13:21 To: Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] Subject: Re: [firebird-support]

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Thanks for the link. Without specifically setting a new value, how can I check what setting is currently in use? Glenn Thomas Hvidsten From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: 21. september 2015 13:29 To: Glenn Thomas Hvidsten g...@vensafe.no

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Hi, In addition to FW On and UPS, I suggest to look at our tool FBDataGuard (http://ib-aid.com/en/fbdataguard), which is specifically designed to protect databases against corruptions (among other features). FBDataGuard stores a copy of raw metadata in the repository outside database, and if

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Hey, >> you should at least turn on forced writes so that changes are >> written to the disk immediately (just in case you have not already done >> that). > Where do I find that setting? If you do not know where to find the setting, forced writes are probably on, as this is the default

Re: [firebird-support] Securing database against corruption on systems that suddenly get turned off

Glenn, My suggestion is to connect the computer in question to an Uninterruptable Power Supply (UPS), which contains a battery as a power backup. When it senses a complete power loss (blackout), an undervolt (brownout), or an overvolt it immediately switches the source of power for your computer

[firebird-support] Securing database against corruption on systems that suddenly get turned off

Hi, We have FirebirdSQL (2.1) running on a client computer (Windows). This client has some problems with his power grid which causes the PC to suddenly and unexpectedly shut down in infrequent intervals (usually once or twice per day). Most of the time this doesn't cause any problems, but once

Re: [firebird-support] Firebird Embedded on web hosting

sorry but i didn't understand your point ... can you explain more please ? anyway, since i cannot control where fbembedded put it's lock and trace files, my only option now is to build firebird from source and change the directory by hand .

RE: [firebird-support] Securing database against corruption on systems that suddenly get turned off

At 11:34 p.m. 21/09/2015, Glenn Thomas Hvidsten g...@vensafe.no [firebird-support] wrote: >Thanks for the link. >Without specifically setting a new value, how can I check what setting is >currently in use? In Firebird's ..\bin directory, in a shell, do gstat -h path\to\database Look at the

[firebird-support] Re: Firebird Embedded on web hosting

> ---In firebird-support@yahoogroups.com, wrote : > anyway, since i cannot control where fbembedded put it's lock and trace > files, Does you read what Mark wrote about FIREBIRD_LOCK environment variable ? > my only option now is to build firebird from source and change

[firebird-support] Support for OS X 10.11 El Capitan

Hello, I currently can’t install the latest Firebird CS 2.5.4 with the provided .pkg installer. This may be related to new System Integrity Protection feature introduced in the latest OS X: https://en.wikipedia.org/wiki/System_Integrity_Protection . I hear it’s possible to disable this

[firebird-support] Using variables in ESQL select statement

We have tables and fields in a database which we need to create audit logs for (any changes to fields require the audit table to be written to). However, we do not want to create specific trigger statements for each table. Rather we want to get a list of the fields in the table from the db

Re: [firebird-support] Using variables in ESQL select statement

Den 21.09.2015 19:12, skrev john_b_bis...@yahoo.com [firebird-support]: > We have tables and fields in a database which we need to create audit > logs for (any changes to fields require the audit table to be written to). > > However, we do not want to create specific trigger statements for each