# Suspend all users apart from admin users for development copy

**URL:** <https://meta.discourse.org/t/suspend-all-users-apart-from-admin-users-for-development-copy/113317>\
**Category:** Product Support\
**Created:** [April 3, 2019, 7:58am UTC](https://meta.discourse.org/t/suspend-all-users-apart-from-admin-users-for-development-copy/113317 "2019-04-03T07:58:17Z")\
**Posts on this page:** 1\
**Showing post:** 7

<div class="post-metadata">

**Author:** ![chrisc](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/chrisc/32/119982_2.png) [@chrisc](https://meta.discourse.org/u/chrisc)\
**Post date:** [April 4, 2019, 11:51am UTC](https://meta.discourse.org/t/suspend-all-users-apart-from-admin-users-for-development-copy/113317/7 "2019-04-04T11:51:52Z")

</div>

Cheers, I know my way around MySQL…

> [@slackmoehrle](#):
>
> sudo postgres

FWIW that should be:

```bash
su - postgres

```

Or:

```bash
sudo -iu postgres

```

So I worked out how to select admin users:

```plaintext
discourse=# SELECT FROM users WHERE admin='t';
--
(6 rows)

```

And then tried:

```plaintext
discourse=# UPDATE users
discourse-# SET silenced_till = '3019-02-01 13:00:00,'
discourse-# SET suspended_till = '3019-02-01 13:00:00'
discourse-# WHERE admin='f'
discourse-# RETURNING id, username_lower;
ERROR: syntax error at or near "SET"
LINE 3: SET suspended_till = '3019-02-01 13:00:00'
        ^

```

However this works:

```plaintext
discourse=# UPDATE users
discourse-# SET silenced_till = '3019-02-01 13:00:00', suspended_till = '3019-02-01 13:00:00'
discourse-# WHERE admin='f'
discourse-# RETURNING id, username_lower;

```

Thanks for your help with this @slackmoehrle 🙂 .

> [@pfaffman](#):
>
> Perhaps you missed that there is a new “staff only” setting for “disable emails”.

Ahh! Yes, I had missed that, this is perfect, thanks.

---

_[View the full topic](https://meta.discourse.org/t/suspend-all-users-apart-from-admin-users-for-development-copy/113317)._