root/trunk/tools


Mode:

Legend:

Added
Modified
Copied or renamed
Rev Chgset Date Author Log Message
(edit) @291 [291] 11/08/11 20:10:17 depesz 1. use variables for queries - to make it obvious that header is built …
(edit) @287 [287] 09/06/11 19:42:44 depesz Added a lot of functionality: 1. stderr output of checks (unless check …
(edit) @267 [267] 08/03/11 21:10:43 depesz 1. Add handling of environment variables in config 2. modify sample config …
(edit) @266 [266] 07/22/11 21:11:37 depesz fix mentions of omnipitr
(edit) @265 [265] 07/22/11 21:10:14 depesz make removal of directories safer, so we'll avoid race condition when …
(edit) @264 [264] 07/18/11 20:23:12 depesz initial version of script to check if there are pages willed with chr(0) …
(edit) @263 [263] 07/12/11 19:31:37 depesz - make system_monitoring correctly buffer lines, not to split them in …
(edit) @262 [262] 07/05/11 21:09:38 depesz some cleanup, grouping, added timing information
(edit) @261 [261] 07/04/11 21:43:46 depesz add handling of sequence values to fast.restore
(edit) @260 [260] 07/04/11 21:40:32 depesz Add dump of sequence values
(edit) @259 [259] 07/04/11 21:31:36 depesz make the queries easier to read, and make psql handling centralized
(edit) @258 [258] 07/04/11 19:12:16 depesz Fix bug in handling tables with first column of primary key not being …
(edit) @257 [257] 07/04/11 19:07:39 depesz First part of code beautifying. Removal of redundant calls to …
(edit) @256 [256] 07/01/11 21:38:34 depesz Initial version. Does restoration. Internally not so cool. Will use some …
(edit) @255 [255] 07/01/11 18:54:22 depesz Make fast.dump dump also meta information about fkeys, to make it simpler …
(edit) @254 [254] 07/01/11 16:54:56 depesz Forgot to commit. Make fast.dump log also information about how big are …
(edit) @253 [253] 06/27/11 21:32:20 depesz make the dumps self-contained sql scripts, not just dummy files
(edit) @252 [252] 06/24/11 17:46:03 depesz In case of most-common-values split of table into blobs - get into …
(edit) @251 [251] 06/24/11 16:46:45 depesz 1. use pg_relation_size(table) + pg_relation_size( toast ) for size …
(edit) @250 [250] 06/24/11 15:35:43 depesz change max-size unit to KB to be able to handle tables which are very …
(edit) @249 [249] 06/24/11 15:26:04 depesz silence the warning
(edit) @248 [248] 06/24/11 15:16:22 depesz more debug info
(edit) @247 [247] 06/24/11 14:57:28 depesz forgot to actually add psql option to parse rules :)
(edit) @246 [246] 06/23/11 21:25:21 depesz looks like working
(edit) @245 [245] 06/23/11 18:56:24 phil tid16363 wrote a quick script to give some stats on checkpoints from the …
(edit) @244 [244] 06/10/11 19:27:15 depesz Script to show detailed information about locks in database
(edit) @212 [212] 01/12/11 22:19:02 depesz make it dump the tables in chronological order
(edit) @211 [211] 01/12/11 22:01:23 depesz oops, forgot to make switches case sensitive - which broke -p|-P
(edit) @206 [206] 12/06/10 22:32:56 depesz initial, written and tested, ersion of the script to archive tables to …
(edit) @203 [203] 12/04/10 12:50:30 depesz make the sleep() work sensibly with non-integer sleep values
(edit) @202 [202] 12/03/10 13:35:46 depesz md5sum is not always available on all platforms, and it's really useful. …
(edit) @201 [201] 11/26/10 14:16:18 depesz - some cleanup to make the code a bit more readable - added documentation …
(edit) @200 [200] 11/26/10 13:47:56 depesz 1. add ability to ignore output of checks (to implement cleanup …
(edit) @199 [199] 11/24/10 22:18:25 depesz comparing the same variable is stupid. I should compare with previous …
(edit) @198 [198] 11/24/10 21:31:15 depesz initial version of script to do long-term data gathering about server …
(edit) @197 [197] 11/16/10 15:33:34 denish fixed typo in email address
(edit) @196 [196] 11/16/10 15:32:57 denish Making email address list as variable
(edit) @195 [195] 11/09/10 22:19:00 depesz Make archive_logs work correctly with log prefixes that contain - …
(edit) @194 [194] 11/08/10 22:03:41 denish missed comment #
(edit) @193 [193] 11/05/10 20:01:38 denish Script to email locked queries with blocking query detail
(edit) @191 [191] 10/14/10 22:07:09 depesz add ability to turn on/off vacuums, and choose better field for updates
(edit) @190 [190] 10/14/10 15:02:54 ssteinpreis tid13485 consolidated version of various zbackup.sh scripts
(edit) @189 [189] 10/12/10 20:54:08 depesz make it handle -? properly
(edit) @188 [188] 10/12/10 20:50:40 depesz script to shrink table, from task: …
(edit) @177 [177] 07/14/10 19:42:44 ssteinpreis tid6031 modified to take postgres database port as command line option, …
(edit) @176 [176] 07/02/10 16:12:33 depesz new version, handling of different prefixes of logs
(edit) @169 [169] 06/17/10 19:21:33 depesz Initial version, although should be perfectly functional
(edit) @166 [166] 06/10/10 07:37:18 depesz simple script to generate list of xlog files in given range.
(edit) @160 [160] 06/04/10 15:17:20 ssteinpreis tid 12167 Initial checkin
(edit) @152 [152] 05/25/10 18:20:43 ssteinpreis tid12312 removed reference to avoiding pg_temp_nnn namespaces, handled on …
(edit) @142 [142] 05/19/10 19:34:43 ssteinpreis Modified to include as follows in order to have report maintain consistent …
(edit) @141 [141] 05/19/10 19:16:38 ssteinpreis Modified to include as below in order to have report maintain consistent …
(edit) @139 [139] 05/03/10 18:36:38 depesz add -r option, to remove old logs instead of archiving them
(edit) @81 [81] 01/27/10 20:27:16 depesz script that gzips input to set of file, keeping each file under given size …
(edit) @56 [56] 12/02/09 15:56:29 depesz if logdir is symlink, version without / at the end doesnt work
(edit) @55 [55] 12/01/09 23:40:20 depesz script to archive pg logs. run archive_logs.sh -h to get help page
(edit) @50 [50] 09/22/09 16:52:58 depesz Copy/paste error
(edit) @49 [49] 08/25/09 15:24:39 depesz make tables report return really only tables
(edit) @46 [46] 08/13/09 20:19:38 depesz change of simple formatting, requested by robert
(edit) @45 [45] 08/13/09 17:52:26 depesz added options to format the report in more readable way (less information)
(edit) @44 [44] 08/12/09 18:53:49 depesz implement --min-pages and --min-wasted-pages options
(edit) @43 [43] 07/31/09 16:59:02 depesz fix bad printf format (%->%s), and add --send-zero option
(edit) @42 [42] 07/31/09 15:13:22 depesz Add workaround for API change in File::Path
(edit) @41 [41] 07/29/09 16:56:37 depesz new version, with --help, and more run options. migrated from bash to perl
(edit) @40 [40] 06/17/09 21:13:15 robert would be good to have easy locatable logfile too
(edit) @39 [39] 06/15/09 17:48:56 robert quick script for emailing bloat report from postgres
(edit) @23 [23] 09/25/08 16:23:14 robert make this work in miliseconds, which is more inline with other pg tools …
(edit) @22 [22] 09/25/08 16:01:25 robert show usage if no arguments are given
(edit) @21 [21] 09/19/08 16:15:15 jesus PostgreSQL passive slow query tool on DTrace
(edit) @10 [10] 04/14/08 18:21:04 jesus netbackup zfs postgres symbiosis
(add) @8 [8] 07/27/07 14:13:59 jesus pg_file_stress allow you to monitor read/write by table in a form similary …
Note: See TracRevisionLog for help on using the revision log.