Move AuditLog to Another Database by Create Date

#!/bin/bash

## GET time to query data
move_time=`date --date="6 months ago" "+%Y-%m-%d %T"`
echo ${move_time}

## COPY data auditlog
echo "Copy data auditlog"
psql wms_local -c \
"\copy (SELECT id,name,model_id,res_id,user_id,method,http_session_id,http_request_id,log_type,create_uid,create_date,write_uid,write_date FROM auditlog_log WHERE create_date <= '${move_time}') TO STDOUT" | \
psql archived_wms -c "\copy auditlog_log(id,name,model_id,res_id,user_id,method,http_session_id,http_request_id,log_type,create_uid,create_date,write_uid,write_date) FROM STDIN"


## COPY data auditlog_line
echo "\nCopy data auditlog_line"
psql wms_local -c \
"\copy (SELECT id,field_id,log_id,old_value,new_value,old_value_text,new_value_text,create_uid,create_date,write_uid,write_date FROM auditlog_log_line WHERE log_id in (SELECT id FROM auditlog_log WHERE create_date <= '${move_time}'$
psql archived_wms -c "\copy auditlog_log_line(id,field_id,log_id,old_value,new_value,old_value_text,new_value_text,create_uid,create_date,write_uid,write_date) FROM STDIN"


### Remove OLD record
echo "\nRemoving data auditlog_line"
psql wms_local -c "DELETE FROM auditlog_log_line WHERE log_id in (SELECT id FROM auditlog_log WHERE create_date <= '${move_time}')"

echo "\nRemoving data auditlog"
psql wms_local -c "DELETE FROM auditlog_log WHERE create_date <= '${move_time}'"