---
title: Global min_messages
teaser: How to reduce postgres output noise.
tags: web,postgresql,rails
author: Dan Croak
published_on: 2012-04-02
---

When running Rails apps with Postgres in development mode, you might notice
output like this when running tests:

    NOTICE:  CREATE TABLE will create implicit sequence "users_id_seq" for serial column "users.id"
    NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "users_pkey" for table "users"

It's noisier than you need for day-to-day development. To quiet the noise, you
could change a setting in your `config/database.yml` file:

```yaml
min_messages: warning
```

However, we can set this machine-wide instead of project-wide, similar to the
[global .gitignore] file and `set noswapfile` vim setting.

```sh
psql -d rails_app_development
ALTER ROLE USER_NAME SET client_min_messages TO WARNING;
```

Change `USER_NAME` to be the user account for your machine.

Bueno.

[global .gitignore]: https://thoughtbot.com/blog/post/18739402579/global-gitignore