aboutsummaryrefslogtreecommitdiffstats
path: root/extra/sql_dumps
Commit message (Collapse)AuthorAgeFilesLines
* dumps: don't upload file hashes or release extid tablesBryan Newbold2022-11-231-1/+1
| | | | These could be replaced by subsets of data (eg, using jq) in the future.
* dumps: private database dump commandsBryan Newbold2022-11-231-0/+18
|
* dumps: use main partition path in prodBryan Newbold2022-11-233-13/+13
|
* bulk dumps: update Makefile with bugfixesBryan Newbold2022-04-261-28/+28
|
* dump/export helper MakefileBryan Newbold2022-04-181-0/+93
|
* sql dumps: use 'custom' mode instead of 'tar'Bryan Newbold2022-02-231-1/+5
|
* SQL snashots/exports: updated prod commandsBryan Newbold2021-12-031-13/+15
|
* sql_dumps: set collection at upload timeBryan Newbold2021-09-021-2/+5
|
* SQL dumps: more pigz (vs. gzip) for speedBryan Newbold2021-06-171-2/+2
|
* SQL dump timing noteBryan Newbold2021-03-101-0/+3
|
* sql dump recent timing noteBryan Newbold2021-03-081-1/+2
|
* include releases_by_work in ident tarballBryan Newbold2020-08-041-1/+2
|
* update SQL dump docs with group-by-work command (by default)Bryan Newbold2020-08-041-1/+1
|
* WIP: sorted release ident dumpsBryan Newbold2020-08-041-0/+16
|
* sql: really don't double-dump requestsBryan Newbold2020-05-261-1/+0
| | | | | | I guess we were dumping 3 times originally; already had an earlier commit that removed one row from this README (that I copypaste to CLI every time)
* update bulk export instructionsBryan Newbold2020-04-071-4/+2
| | | | | - don't do expanded and regular release dumps - default to sqldump_public for item name (as that is common-case)
* sql_dumps: stop doing redundant release dumpsBryan Newbold2020-04-011-1/+3
|
* bulk exports README different from SQL READMEBryan Newbold2020-03-171-1/+1
|
* sql table size script: shorter outputBryan Newbold2020-01-151-0/+1
| | | | This skips postgres-internal tables in size output
* DB loads take a long time nowBryan Newbold2019-12-211-1/+1
|
* export raw affiliation strings for analysisBryan Newbold2019-10-031-0/+17
|
* create new collection just for fatcat exportsBryan Newbold2019-09-091-1/+1
|
* sql_dumps: typoBryan Newbold2019-07-141-1/+1
|
* dump_release_extid.sql changes for new schemaBryan Newbold2019-06-031-1/+1
|
* move export README info to sql_dumps docBryan Newbold2019-06-031-1/+29
|
* commit SQL table stats scriptsBryan Newbold2019-05-212-0/+36
|
* no-derive metadata and SQL dump uploads (to petabox)Bryan Newbold2019-04-301-0/+2
|
* update sql dump READMEBryan Newbold2019-04-241-9/+12
|
* gitignore SQL identifier dumpsBryan Newbold2019-02-221-0/+1
|
* start of README files for item uploadsBryan Newbold2019-02-053-0/+26
|
* use pigz over gzip in more placesBryan Newbold2019-02-052-7/+15
|
* update dump and sort commandsBryan Newbold2019-02-011-3/+13
| | | | | Pipeline sorts are *so* starved and slow ; they only get a few MByte of RAM by default!
* add filesets and webcaptures to dumpsBryan Newbold2019-01-284-1/+33
|
* DATABASE_URL, not DATABASE_URIBryan Newbold2018-09-131-4/+4
|
* fix snapshot output suffix (.gz)Bryan Newbold2018-09-131-1/+1
|
* improvements to ident_table_snapshot.shBryan Newbold2018-09-131-5/+15
|
* remove accidentally-commited files; add gitignoreBryan Newbold2018-09-133-5/+3
|
* improve dump scriptsBryan Newbold2018-09-138-0/+96