[firebird-support] RE: FB 2.5 shutdown restore question

2013-04-04 Thread Svein Erling Tysvær
We have a database that we want to wipe and replace every week, regardless of whether it is in use. ... gfix -shut single -force 1 server:/opt/firebird/db/clone.fdb Why do you use '-shut single' and not '-shut full', Rick? I apologize if my question just reveals my almost complete lack of

RE: [firebird-support] FB 2.5 shutdown restore question

2013-04-04 Thread Rick Debay
During restore DB is itself in single-user mode, so, noone can connect until restore finishes. Is this new for 2.x? I know we could connect during a restore under 1.5. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Dmitry Kuzmenko Sent:

RE: [firebird-support] RE: FB 2.5 shutdown restore question

2013-04-04 Thread Rick Debay
Why do you use '-shut single' and not '-shut full' Under 1.5 you can connect to a database while it is restoring, which breaks the restore. We were throwing everything we could think of at the problem so it wouldn't happen. If 2.x doesn't allow connections during restore we shouldn't have

RE: [firebird-support] FireBird 2.5 How can i create 1 byte (0-255) column?

2013-04-04 Thread Rick Debay
Would a backup/restore change the physical layout to match the logical? -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann Harrison Sent: Wednesday, April 03, 2013 4:54 PM To: firebird-support@yahoogroups.com Subject: Re:

Re: [firebird-support] FireBird 2.5 How can i create 1 byte (0-255) column?

2013-04-04 Thread Ann Harrison
On Thu, Apr 4, 2013 at 3:30 PM, Rick Debay rde...@accessrxs.com wrote: Would a backup/restore change the physical layout to match the logical? It could, but it doesn't. A slightly smarter restore would sort the fields by alignment, recreate the table physically from the most restrictive

[firebird-support] Permission denied error creating firebird embedded database in OSX

2013-04-04 Thread martinsearancke
Firstly I am not 100% sure I am using the embedded firebird client under OSX. The install file that I downloaded from firebirdsql.org states that it contains Classic, Superclassic Embedded. Unlike the windows version there does not appear to be a dedicated embedded library file in the package.

[firebird-support] Re: Permission denied error creating firebird embedded database in OSX

2013-04-04 Thread martinsearancke
Solved! After re-reading this document several times I finally got it: http://www.ibphoenix.com/resources/documents/how_to/doc_103 The embedded library under OSX is the same as what would be called the exe in windows. In the /Library/Framworks/Firebird.framework folder is an executable just

Re: [firebird-support] Permission denied error creating firebird embedded database in OSX

2013-04-04 Thread Helen Borrie
At 12:01 p.m. 5/04/2013, martinsearancke wrote: Firstly I am not 100% sure I am using the embedded firebird client under OSX. You're not. The install file that I downloaded from firebirdsql.org states that it contains Classic, Superclassic Embedded. Unlike the windows version there does not