From 0c11b0746d6161dd546b864ff24b3c2db813866a Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Tue, 22 Jul 2014 00:28:59 +0200 Subject: [PATCH] move logs back to spinning disk --- utils/cron_logrotate.sh | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/utils/cron_logrotate.sh b/utils/cron_logrotate.sh index 7d3ca4a3..b9291d95 100755 --- a/utils/cron_logrotate.sh +++ b/utils/cron_logrotate.sh @@ -14,7 +14,7 @@ pg_dump -a -F p -t backup_query_log $dbname | gzip -9 > $logfile psql -q -d $dbname -c 'DROP TABLE backup_query_log' # rotate -psql -q -1 -d $dbname -c 'ALTER TABLE new_query_log RENAME TO backup_query_log;CREATE TABLE new_query_log TABLESPACE ssd2 as (select * from backup_query_log limit 0);GRANT SELECT, INSERT, UPDATE ON new_query_log TO "www-data"' +psql -q -1 -d $dbname -c 'ALTER TABLE new_query_log RENAME TO backup_query_log;CREATE TABLE new_query_log as (select * from backup_query_log limit 0);GRANT SELECT, INSERT, UPDATE ON new_query_log TO "www-data"' psql -q -d $dbname -c 'ALTER INDEX idx_new_query_log_starttime RENAME TO idx_backup_query_log_starttime' -psql -q -d $dbname -c 'CREATE INDEX idx_new_query_log_starttime ON new_query_log USING BTREE (starttime) TABLESPACE ssd2' +psql -q -d $dbname -c 'CREATE INDEX idx_new_query_log_starttime ON new_query_log USING BTREE (starttime)' -- 2.39.5