BackupPC.git
18 years agosmall fix
dpavlin [Sun, 11 Sep 2005 11:48:16 +0000 (11:48 +0000)]
small fix

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@114 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agomore things to do
dpavlin [Sun, 11 Sep 2005 11:48:06 +0000 (11:48 +0000)]
more things to do

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@113 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agosimplify (not to say refactor ;-) code. Also, make it actually work.
dpavlin [Thu, 1 Sep 2005 20:24:13 +0000 (20:24 +0000)]
simplify (not to say refactor ;-) code. Also, make it actually work.
Now it doesn't require files or dirs as last parametar (because we know
that we want all files in that backup).
So, run this script, pipe it to gzip (or bzip2) and you have compressed
archive of one increment.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@112 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years ago r113@athlon: dpavlin | 2005-09-01 20:38:07 +0200
dpavlin [Thu, 1 Sep 2005 18:38:49 +0000 (18:38 +0000)]
 r113@athlon:  dpavlin | 2005-09-01 20:38:07 +0200
 start gnumeric on generated .xls if found

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@111 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years ago r112@athlon: dpavlin | 2005-09-01 20:37:03 +0200
dpavlin [Thu, 1 Sep 2005 18:38:48 +0000 (18:38 +0000)]
 r112@athlon:  dpavlin | 2005-09-01 20:37:03 +0200
 include hostname in each row

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@110 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded Ivan's changes to show increment sizes and other minor fixes
dpavlin [Thu, 1 Sep 2005 18:30:51 +0000 (18:30 +0000)]
added Ivan's changes to show increment sizes and other minor fixes

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@109 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agodocument BackupPC_xls_report, merge all hosts into single sheet so you can use autofilter
dpavlin [Wed, 31 Aug 2005 21:22:48 +0000 (21:22 +0000)]
document BackupPC_xls_report, merge all hosts into single sheet so you can use autofilter
to select just some hosts, call test to install new version in xls target

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@108 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoCall HyperEstraier index update only if there are new files or directories
dpavlin [Wed, 31 Aug 2005 20:58:39 +0000 (20:58 +0000)]
Call HyperEstraier index update only if there are new files or directories
in created snapshot. Minor improvements to terminal output.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@107 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agouse sudo for install-etc target
dpavlin [Wed, 31 Aug 2005 20:33:58 +0000 (20:33 +0000)]
use sudo for install-etc target

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@106 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agodocumentation improvements
dpavlin [Wed, 31 Aug 2005 20:33:45 +0000 (20:33 +0000)]
documentation improvements

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@105 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofix parametars to execute
dpavlin [Wed, 31 Aug 2005 11:05:26 +0000 (11:05 +0000)]
fix parametars to execute

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@104 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded very complex backup query (which is slow, probably a good candidate
dpavlin [Tue, 30 Aug 2005 22:43:57 +0000 (22:43 +0000)]
added very complex backup query (which is slow, probably a good candidate
for materilaized view)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@103 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded share, nicer html
dpavlin [Tue, 30 Aug 2005 22:43:01 +0000 (22:43 +0000)]
added share, nicer html

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@102 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded BackupPC_tarIncCreate
dpavlin [Tue, 30 Aug 2005 22:42:22 +0000 (22:42 +0000)]
added BackupPC_tarIncCreate

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@101 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded Ivan's version of tarCreate which creates just one increment
dpavlin [Tue, 30 Aug 2005 20:29:26 +0000 (20:29 +0000)]
added Ivan's version of tarCreate which creates just one increment
(for later burning to archive media)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@100 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoincreased increment to 100000 files (37Mb of working memory on my system)
dpavlin [Tue, 30 Aug 2005 14:45:33 +0000 (14:45 +0000)]
increased increment to 100000 files (37Mb of working memory on my system)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@99 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoupdate HyperEstraier index in chunks of EST_CHUNK (default is 10000) to
dpavlin [Tue, 30 Aug 2005 14:19:54 +0000 (14:19 +0000)]
update HyperEstraier index in chunks of EST_CHUNK (default is 10000) to
reduce memory usage with huge backup sets (because PostgreSQL tries to load
whole result set in memory).

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@98 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded EST_SYNC_EVERY => 10000 to sync HyperEstraier database every 10000
dpavlin [Tue, 30 Aug 2005 09:55:55 +0000 (09:55 +0000)]
added EST_SYNC_EVERY => 10000 to sync HyperEstraier database every 10000
entries. Catching SIGINT and SIGQUIT and sync HyperEstraier database.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@97 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoimprovements
dpavlin [Tue, 30 Aug 2005 09:55:43 +0000 (09:55 +0000)]
improvements

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@96 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agodon't try to create HyperEstraier index if creating database
dpavlin [Tue, 30 Aug 2005 09:55:34 +0000 (09:55 +0000)]
don't try to create HyperEstraier index if creating database

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@95 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofirst try at documentation for this extension
dpavlin [Sun, 28 Aug 2005 18:29:44 +0000 (18:29 +0000)]
first try at documentation for this extension

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@94 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoremoved debugging output from index target
dpavlin [Sun, 28 Aug 2005 18:03:13 +0000 (18:03 +0000)]
removed debugging output from index target

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@93 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agonicer messages
dpavlin [Sun, 28 Aug 2005 18:02:58 +0000 (18:02 +0000)]
nicer messages

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@92 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agobug fix: require search string to be in filepath to produce same
dpavlin [Sun, 28 Aug 2005 17:53:46 +0000 (17:53 +0000)]
bug fix: require search string to be in filepath to produce same
results from HyperEstraier as from RDBMS.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@91 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agobug fix: -i option now works, file type fixed in index
dpavlin [Sun, 28 Aug 2005 17:42:25 +0000 (17:42 +0000)]
bug fix: -i option now works, file type fixed in index

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@90 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoautomatic update of HyperEstraier index after each increment,
dpavlin [Sun, 28 Aug 2005 17:04:12 +0000 (17:04 +0000)]
automatic update of HyperEstraier index after each increment,
added -i flag to force re-scan of all files and insert missing
ones into index

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@89 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agooptimization: if there is no file pattern it will fallback on database
dpavlin [Sun, 28 Aug 2005 14:15:01 +0000 (14:15 +0000)]
optimization: if there is no file pattern it will fallback on database
usages which is much faster than HyperEstraier (bacause it has indexes)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@88 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agobug fixes: date limit now works again, correct number of displayed results,
dpavlin [Sun, 28 Aug 2005 14:05:08 +0000 (14:05 +0000)]
bug fixes: date limit now works again, correct number of displayed results,
added SQL script to remove unneeded columns, dates only selection now
works with HyperEstraier (but, it's MUCH SLOWER than from database),
added ordinal number of result

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@87 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofirst cut at implemeting HyperEstraier search,
dpavlin [Sun, 28 Aug 2005 12:35:59 +0000 (12:35 +0000)]
first cut at implemeting HyperEstraier search,
shares are now formated like host:share, fix date display,
initial cut at removing unneeded database columns,
rename all fields to comply with database columns

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@86 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agorewrite pager to transfer all parametars via URL instead of form POST
dpavlin [Sun, 28 Aug 2005 10:45:51 +0000 (10:45 +0000)]
rewrite pager to transfer all parametars via URL instead of form POST

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@85 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoconnect to DB just once
dpavlin [Sun, 28 Aug 2005 10:20:31 +0000 (10:20 +0000)]
connect to DB just once

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@84 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agorefactor displaySearchGrid and related function to remove multiple calls
dpavlin [Sun, 28 Aug 2005 10:14:48 +0000 (10:14 +0000)]
refactor displaySearchGrid and related function to remove multiple calls
from BackupPC::CGI::SearchArchives to BackupPC::SearchLib.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@83 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded HyperEstraierIndex configuration option
dpavlin [Sun, 28 Aug 2005 09:12:54 +0000 (09:12 +0000)]
added HyperEstraierIndex configuration option

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@82 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded experimental HyperEstraier index creation.
dpavlin [Sun, 28 Aug 2005 08:40:06 +0000 (08:40 +0000)]
added experimental HyperEstraier index creation.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@81 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agominor tweak and new CSS theme
dpavlin [Fri, 26 Aug 2005 23:50:05 +0000 (23:50 +0000)]
minor tweak and new CSS theme

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@80 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agouse BackupPC::Lib::timeStamp in epoch_to_iso,
dpavlin [Fri, 26 Aug 2005 23:37:10 +0000 (23:37 +0000)]
use BackupPC::Lib::timeStamp in epoch_to_iso,
removed dvds from SQL (in preparation for new storage of archival media),
fix archial SQL,
use correct (I hope) CSS classes in search html

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@79 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofix restore url escaping
dpavlin [Fri, 26 Aug 2005 21:43:01 +0000 (21:43 +0000)]
fix restore url escaping

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@78 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoupdated
dpavlin [Fri, 26 Aug 2005 21:23:44 +0000 (21:23 +0000)]
updated

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@77 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoalternative implementation of fix with temporary table. must be commit-ed manually.
dpavlin [Fri, 26 Aug 2005 21:18:37 +0000 (21:18 +0000)]
alternative implementation of fix with temporary table. must be commit-ed manually.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@76 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded some useful SQL examples. They are lightly commented within each file.
dpavlin [Fri, 26 Aug 2005 20:44:24 +0000 (20:44 +0000)]
added some useful SQL examples. They are lightly commented within each file.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@75 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofixed found_in_db to prevent duplicate file insertion when restarting from
dpavlin [Fri, 26 Aug 2005 17:18:27 +0000 (17:18 +0000)]
fixed found_in_db to prevent duplicate file insertion when restarting from
non-empty database.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@74 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agomore bugs
dpavlin [Thu, 25 Aug 2005 16:01:21 +0000 (16:01 +0000)]
more bugs

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@73 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoorder shares alphabetically
dpavlin [Thu, 25 Aug 2005 11:41:58 +0000 (11:41 +0000)]
order shares alphabetically

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@72 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded known bugs
dpavlin [Wed, 24 Aug 2005 17:13:30 +0000 (17:13 +0000)]
added known bugs

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@71 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoreturn correct number of new files in each increment (just display error)
dpavlin [Wed, 24 Aug 2005 17:12:22 +0000 (17:12 +0000)]
return correct number of new files in each increment (just display error)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@70 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoxls target to make report
dpavlin [Mon, 22 Aug 2005 09:47:06 +0000 (09:47 +0000)]
xls target to make report

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@69 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agosort sheets
dpavlin [Mon, 22 Aug 2005 09:46:57 +0000 (09:46 +0000)]
sort sheets

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@68 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agosmall speedup and nicer output
dpavlin [Mon, 22 Aug 2005 08:58:59 +0000 (08:58 +0000)]
small speedup and nicer output

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@67 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agocalculate size for each backup (this is more accurate than reading meta data
dpavlin [Mon, 22 Aug 2005 00:09:59 +0000 (00:09 +0000)]
calculate size for each backup (this is more accurate than reading meta data
if you aren't staring from clean BackupPC installation).

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@66 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadd shareID to backups and fixed commit mess. Now update correctly continues
dpavlin [Sun, 21 Aug 2005 23:25:47 +0000 (23:25 +0000)]
add shareID to backups and fixed commit mess. Now update correctly continues
from last aborted backup and share.

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@65 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agosort files by date and cludge (hard-coded mess) to make TZ +1
dpavlin [Sun, 21 Aug 2005 17:08:55 +0000 (17:08 +0000)]
sort files by date and cludge (hard-coded mess) to make TZ +1

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@64 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agochange date input in search form to ISO format yyyy-mm-dd
dpavlin [Sun, 21 Aug 2005 16:12:34 +0000 (16:12 +0000)]
change date input in search form to ISO format yyyy-mm-dd

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@63 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoremoved on-disk full path from database and queries, search now tries to
dpavlin [Sun, 21 Aug 2005 15:59:55 +0000 (15:59 +0000)]
removed on-disk full path from database and queries, search now tries to
match full path and not only filename

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@62 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoupdate target to run BackupPC_updatedb
dpavlin [Sun, 21 Aug 2005 15:42:40 +0000 (15:42 +0000)]
update target to run BackupPC_updatedb

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@61 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofixed limit by share while searching
dpavlin [Sun, 21 Aug 2005 15:38:18 +0000 (15:38 +0000)]
fixed limit by share while searching

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@60 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoAdd permantent serach form using HTML::FillInForm, fixed offset+1 bug,
dpavlin [Sun, 21 Aug 2005 15:29:24 +0000 (15:29 +0000)]
Add permantent serach form using HTML::FillInForm, fixed offset+1 bug,
added no results message

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@59 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoburn media now sorts by start date and display age (in days)
dpavlin [Sun, 21 Aug 2005 14:26:23 +0000 (14:26 +0000)]
burn media now sorts by start date and display age (in days)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@58 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoprint start time and duration of each backup
dpavlin [Sun, 21 Aug 2005 14:25:46 +0000 (14:25 +0000)]
print start time and duration of each backup

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@57 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoprofile target is now destructive to backuppc database!
dpavlin [Sun, 21 Aug 2005 13:52:47 +0000 (13:52 +0000)]
profile target is now destructive to backuppc database!

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@56 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoremoved dvds from count sql, added duration of search, cosmetic changes in output
dpavlin [Sun, 21 Aug 2005 13:44:20 +0000 (13:44 +0000)]
removed dvds from count sql, added duration of search, cosmetic changes in output

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@55 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoanother fix for profile target
dpavlin [Sun, 21 Aug 2005 12:46:24 +0000 (12:46 +0000)]
another fix for profile target

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@54 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofix archive to backup medium (but it still doesn't have functionality)
dpavlin [Sat, 20 Aug 2005 17:19:48 +0000 (17:19 +0000)]
fix archive to backup medium (but it still doesn't have functionality)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@53 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoschema fix
dpavlin [Sat, 20 Aug 2005 16:45:02 +0000 (16:45 +0000)]
schema fix

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@52 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded SearchDSN and SearchUser configuration directives. Defaults are
dpavlin [Sat, 20 Aug 2005 16:40:11 +0000 (16:40 +0000)]
added SearchDSN and SearchUser configuration directives. Defaults are
probably useful only to me :-)
Added total duration display to BackupPC_updatedb

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@51 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agodisplay duration time for each increment part
dpavlin [Sat, 20 Aug 2005 15:51:16 +0000 (15:51 +0000)]
display duration time for each increment part

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@50 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agochanges to make it work on PostgreSQL (and add general DBD independence), added
dpavlin [Sat, 20 Aug 2005 15:01:48 +0000 (15:01 +0000)]
changes to make it work on PostgreSQL (and add general DBD independence), added
unique indexes, fixed schema, converted primary keys to serial.

This change breaks search for sure, but PostgreSQL is faster than SQLite on
my laptop:

User+System Time
SQLite 24.96514
PostgreSQL 11.08451

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@49 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agosome speedups, I think this is most I can do without changing database
dpavlin [Sat, 20 Aug 2005 14:13:58 +0000 (14:13 +0000)]
some speedups, I think this is most I can do without changing database

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@48 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoprofile target now calls test to install new version, minor fixes in profile
dpavlin [Sat, 20 Aug 2005 14:08:02 +0000 (14:08 +0000)]
profile target now calls test to install new version, minor fixes in profile
file generation

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@47 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agomore fixes for profile target
dpavlin [Sat, 20 Aug 2005 12:40:24 +0000 (12:40 +0000)]
more fixes for profile target

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@46 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofine-tune debug output, profile target
dpavlin [Sat, 20 Aug 2005 11:39:05 +0000 (11:39 +0000)]
fine-tune debug output, profile target

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@45 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded verbosity level to -v and backup type to display
dpavlin [Sat, 20 Aug 2005 11:24:55 +0000 (11:24 +0000)]
added verbosity level to -v and backup type to display

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@44 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofix size format
dpavlin [Fri, 19 Aug 2005 22:12:56 +0000 (22:12 +0000)]
fix size format

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@43 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded size format
dpavlin [Fri, 19 Aug 2005 22:07:01 +0000 (22:07 +0000)]
added size format

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@42 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofirst try at generating Excel report
dpavlin [Fri, 19 Aug 2005 21:52:43 +0000 (21:52 +0000)]
first try at generating Excel report

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@41 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agodisplay number of new and total files in each increment
dpavlin [Fri, 19 Aug 2005 15:38:56 +0000 (15:38 +0000)]
display number of new and total files in each increment

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@40 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofix clean pid handling on clean exit
dpavlin [Fri, 19 Aug 2005 15:28:59 +0000 (15:28 +0000)]
fix clean pid handling on clean exit

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@39 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agomaintain pid file in /tmp/BackuPC_update.pid
dpavlin [Fri, 19 Aug 2005 15:27:27 +0000 (15:27 +0000)]
maintain pid file in /tmp/BackuPC_update.pid

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@38 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded date, time and average items per second
dpavlin [Fri, 19 Aug 2005 14:57:30 +0000 (14:57 +0000)]
added date, time and average items per second

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@37 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agonow it works from current directory
dpavlin [Wed, 3 Aug 2005 14:58:26 +0000 (14:58 +0000)]
now it works from current directory

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@36 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agocreate BackupPC::View just once
dpavlin [Sun, 31 Jul 2005 21:03:36 +0000 (21:03 +0000)]
create BackupPC::View just once

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@35 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded option to dump just first increment in view
dpavlin [Sun, 31 Jul 2005 20:53:40 +0000 (20:53 +0000)]
added option to dump just first increment in view

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@34 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agonew install-etc target
dpavlin [Sun, 31 Jul 2005 18:58:26 +0000 (18:58 +0000)]
new install-etc target

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@33 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded -v option to turn debugging on (-d is allready delete)
dpavlin [Sun, 31 Jul 2005 18:10:45 +0000 (18:10 +0000)]
added -v option to turn debugging on (-d is allready delete)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@32 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoimplemented pager which work (with maximum of 10 pages at one time and 100 results on
dpavlin [Sun, 31 Jul 2005 16:16:55 +0000 (16:16 +0000)]
implemented pager which work (with maximum of 10 pages at one time and 100 results on
one screen)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@31 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded $debug level to make script chatty to STDERR
dpavlin [Sun, 31 Jul 2005 15:59:19 +0000 (15:59 +0000)]
added $debug level to make script chatty to STDERR

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@30 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agobug squashing fest: moved stack in recurseDir in proper scope (which will save memory),
dpavlin [Sun, 31 Jul 2005 12:40:51 +0000 (12:40 +0000)]
bug squashing fest: moved stack in recurseDir in proper scope (which will save memory),
recurse always through all directories (unfortunate fact that directory mtime doesn't
track changes in sub-directories), insert invrement after all files are inserted

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@29 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded init script and example httpd.conf (local use, really)
dpavlin [Fri, 29 Jul 2005 17:33:23 +0000 (17:33 +0000)]
added init script and example httpd.conf (local use, really)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@28 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agomaintain own stack to cut down memory usage
dpavlin [Fri, 29 Jul 2005 17:31:14 +0000 (17:31 +0000)]
maintain own stack to cut down memory usage

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@27 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded restore link to search results
dpavlin [Fri, 29 Jul 2005 17:30:25 +0000 (17:30 +0000)]
added restore link to search results

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@26 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofixed drop-down label
dpavlin [Wed, 13 Jul 2005 09:57:41 +0000 (09:57 +0000)]
fixed drop-down label

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@25 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agocosmetics
dpavlin [Mon, 11 Jul 2005 16:48:33 +0000 (16:48 +0000)]
cosmetics

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@24 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofixed names, Makefile and misc stuff
dpavlin [Mon, 11 Jul 2005 16:22:50 +0000 (16:22 +0000)]
fixed names, Makefile and misc stuff

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@23 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoadded sub-project to create configuration from M$ Excel file
dpavlin [Mon, 11 Jul 2005 15:53:59 +0000 (15:53 +0000)]
added sub-project to create configuration from M$ Excel file

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@22 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agotarget to rsync to deployment server
dpavlin [Mon, 11 Jul 2005 14:59:05 +0000 (14:59 +0000)]
target to rsync to deployment server

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@21 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofixed join with backups to show just increments
dpavlin [Mon, 11 Jul 2005 14:58:54 +0000 (14:58 +0000)]
fixed join with backups to show just increments

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@20 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agodisplay limits in search, easier to understand filter generator (and correct
dpavlin [Mon, 11 Jul 2005 14:32:40 +0000 (14:32 +0000)]
display limits in search, easier to understand filter generator (and correct
one -- doesn't require users to enter dates as 01 01 2001)

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@19 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agofix schema
dpavlin [Mon, 11 Jul 2005 14:31:51 +0000 (14:31 +0000)]
fix schema

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@18 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoimproved design
dpavlin [Mon, 11 Jul 2005 13:22:38 +0000 (13:22 +0000)]
improved design

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@17 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agodon't join with backups, so it will show just increments
dpavlin [Mon, 11 Jul 2005 11:51:09 +0000 (11:51 +0000)]
don't join with backups, so it will show just increments

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@16 8392b6e1-25fa-0310-8288-cc32f8e212ea

18 years agoremoved debug output
dpavlin [Mon, 11 Jul 2005 00:07:25 +0000 (00:07 +0000)]
removed debug output

git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@15 8392b6e1-25fa-0310-8288-cc32f8e212ea