# Challenge to masters

**URL:** <https://community.unix.com/t/challenge-to-masters/214057>\
**Category:** Shell Programming and Scripting\
**Created:** [September 26, 2008, 6:29am UTC](https://community.unix.com/t/challenge-to-masters/214057 "2008-09-26T06:29:33Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Neo](https://community.unix.com/user_avatar/community.unix.com/neo/32/22838_2.png) [@Neo](https://community.unix.com/u/Neo)\
**Post date:** [May 7, 2020, 5:56am UTC](https://community.unix.com/t/challenge-to-masters/214057/3 "2020-05-07T05:56:56Z")

</div>

Just updated the Community production DB to see if we can stop auto-bumping of these very old topics:

> [@Postgres timestamp without time zone query example](https://community.unix.com/t/postgres-timestamp-without-time-zone-query-example/378321/2):
>
> Production postgres DB actions on live, production Discourse DB: # cd /var/discourse /var/discourse# ./launcher enter data; # pwd / # su discourse -c 'psql discourse' psql (10.12 (Debian 10.12-2.pgdg100+1)) Type "help" for help. discourse=\> SELECT count(id) from topics where closed = false and created\_at \< '2018-01-01 00:00:00'::timestamp without time zone; count ------- 144 (1 row) discourse=\> UPDATE topics set closed = true where closed = false and created\_at \< '2018-01-01 00:00:00'::timest…

---

_[View the full topic](https://community.unix.com/t/challenge-to-masters/214057)._