INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Disable Transaction Logging PSQL v9

Disable Transaction Logging PSQL v9

(OP)
Hi all, I am using PSQL v9 SP1, I would like to disable the transaction logging feature but can't seem to do so. If I uncheck the transaction logging feature in data integrity, click apply, Pervasive tells me it is restarting Services. If I then exit the Control centre - reopen I find the the transaction logging is ticked again.

Anyone else had this problem? Or more importantly know how to solve it?

Cheers

RE: Disable Transaction Logging PSQL v9

I just tried it on my PSQL 9.5 (SP2) install and it worked just fine.  Are you trying to do this through a Terminal Server (or Remote Desktop) session?  If so, try it physically at the server.  I did it both physically at the server and through VNC.  

Why are you turning it off?  

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Disable Transaction Logging PSQL v9

(OP)
Thanks for the reply, I was initially trying to disable it through RDP - I have now tried through VNC and directly at the server, all with the same result.

As to why I am turning it off, I am taking it under advisement from our application developer, I believe the application handles all of the transaction logging.

RE: Disable Transaction Logging PSQL v9

Sounds like you might have a permission or registry issue in that case.  
You could try changing the value in the registry directly.  You'd want to stop the PSQL engine (both Transactional and Relational services) on the server then change the value at
HKEY_LOCAL_MACHINE\SOFTWARE\Pervasive Software\MicroKernel Server Engine\Version 9\Settings\Transaction Logging
to No.  
I've always left it on and haven't had any problems.  
Does the app developer say that it causes problems to have it on?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: Disable Transaction Logging PSQL v9

(OP)
Thanks mirtheil that worked a treat!

As to why I have been advised to turn the transaction logging off, I don't know; but I think I will ask the question. I don't know to much about pervasive so I was just taking their advice at face value.

I know that the transaction logging is there for data integrity but I can't see how it helps - the logs appear to be pretty meaningless, how would you use them if there was any data corruption?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close