Delicious      Technorati      Blinklist      Furl      Reddit

TimeTrex Time and Attendance

TimeTrex Time and Attendance


* FAQ    * Search
* Login   * Register

All times are UTC - 8 hours [ DST ]




Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 
Author Message
 Post subject: database for TimeTrex
PostPosted: Wed Jul 25, 2012 6:02 am 
Offline

Joined: Wed Jul 25, 2012 5:49 am
Posts: 3
Hello,

I have install TimeTrex on our Ubuntu 12.04 Desktop Version.
I want to know which database is used by TimeTrex? and How do I get backup of that database in linux?

Thanks in advance,
Nitin


Top
 Profile  
 
PostPosted: Wed Jul 25, 2012 8:09 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7228
The TimeTrex automated installer uses PostgreSQL by default and also automatically creates a backup of the database in the TimeTrex directory each night.


Top
 Profile  
 
PostPosted: Wed Jul 25, 2012 8:27 am 
Offline

Joined: Wed Jul 25, 2012 5:49 am
Posts: 3
Thanks Shaun for your reply,

can you please know me full path of the database backup file?


Top
 Profile  
 
PostPosted: Wed Jul 25, 2012 8:41 am 
Offline

Joined: Tue Sep 19, 2006 2:22 pm
Posts: 7228
Because TimeTrex allows you to install it anywhere you like, all I can tell you is that the backup file is inside the TimeTrex directory, where ever you installed it.


Top
 Profile  
 
PostPosted: Sat Feb 09, 2013 11:25 pm 
Offline

Joined: Sat Feb 09, 2013 9:31 pm
Posts: 5
A quick question about the backup, does your setup take into account aging out the backups that the system makes every night? Or should the average user setup something like find /home/timetrex/timetrex/timetrex_database*.sql +mtime=8 -delete in a cron job?


Top
 Profile  
 
PostPosted: Sun Feb 10, 2013 11:21 pm 
Offline

Joined: Sat Feb 09, 2013 9:31 pm
Posts: 5
A correction to my own post

find /home/timetrex/timetrex/timetrex_database*.sql -mtime+8 -delete

this searches the timetrex directory (in my case under user timetrex in /home/timetrex) for the file pattern timetrex_database*.sql (the naming scheme this install is using by default) and deletes them if they are more than 8 days old.

Ignore my first post, I have no idea where my mind was when I typed that first example command.


Top
 Profile  
 
PostPosted: Thu Jun 13, 2013 8:16 pm 
Offline

Joined: Thu Sep 13, 2012 2:30 pm
Posts: 45
I'm more familiar with the windows version (I have installed on*buntu once, just for future reference, and to make sure the database restore from windows to linux and vice-versa would work properly {it does!} and because I would prefer to have it running on linux, but all of the available servers I had at the time were windows based....)

BUT... (after the long tangent) Timetrex by default keeps a rolling 5 days of database backups. I personally also setup a small bat file to copy those backups to an offsite backup location, and there I keep a rolling 30 days (If I'm going to make backups, I prefer to err on the paranoid side... But the thought of actually having to roll back a month in the time system scares me as much not having the backups!)


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic This topic is locked, you cannot edit posts or make further replies.  [ 7 posts ] 

All times are UTC - 8 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Time and Attendance




Powered by phpBB® Forum Software © phpBB Group