数据库时区问题

调整服务器时区

cp -f /usr/share/zoneinfo/Asia/Shanghai /etc/localtime

https://blog.csdn.net/walykyy/article/details/105322252

调整数据库时区

具体命令
set time zone 'PRC';

select now();
SELECT localtime AT TIME ZONE 'Asia/Shanghai';

SELECT localtime AT TIME ZONE 'Asia/Shanghai';
SET TIME ZONE 'Asia/Shanghai';

SELECT * FROM "t_pay_order"
看这个教程

./pg_ctl reload 这个命令没必要
直接重启
systemctl restart postgresql-12.service
systemctl status postgresql-12.service