[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

[dak/master] function pg_timestamp



Signed-off-by: Joerg Jaspert <joerg@debian.org>
---
 config/backports/common |    6 ++++++
 1 files changed, 6 insertions(+), 0 deletions(-)

diff --git a/config/backports/common b/config/backports/common
index 2c7b76b..050f506 100644
--- a/config/backports/common
+++ b/config/backports/common
@@ -101,3 +101,9 @@ function reports() {
 #    dak cruft-report -s experimental >> $webdir/cruft-report-daily.txt
     cat $webdir/cruft-report-daily.txt | mail -e -s "Debian archive cruft report for $(date +%D)" team@backports.debian.org
 }
+
+function pg_timestamp() {
+    tsname=${1:-"unknown"}
+    log "Saving postgres transaction id for ${tsname}"
+    psql -tAc 'select txid_current();' > $base/backup/txid_${tsname}_$(date +%Y.%m.%d-%H:%M:%S)
+}
-- 
1.7.2.5


Reply to: