Re: How to turn off DEBUG statements from psql commends

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: peterlen <peteralen(at)earthlink(dot)net>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to turn off DEBUG statements from psql commends
Date: 2014-02-10 15:49:41
Message-ID: 1392047381.96986.YahooMailNeo@web133205.mail.ir2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

----- Original Message -----
> From: peterlen <peteralen(at)earthlink(dot)net>
> To: pgsql-general(at)postgresql(dot)org
> Cc:
> Sent: Monday, 10 February 2014, 15:43
> Subject: [GENERAL] How to turn off DEBUG statements from psql commends
>
> We are using PostgreSQL 9.3.  Something seems to have changed with our psql
> command-line output since we first installed it.  When I run commands at my
> plsql prompt, I am getting a lot of debug statements which I was not getting
> before.  I am just trying to find out how to tell psql not to display this
> output.  As an example, if I were to create a new 'test' schema, the
> output
> looks like:
>
> gis_demo=# create schema test;
> DEBUG:  StartTransactionCommand
> DEBUG:  StartTransaction
> DEBUG:  name: unnamed; blockState:      DEFAULT; state: INPROGR,

I'm guessing you've got client_min_messages set to one of the debug levels, try setting it to "log" or lower.  What does "SHOW client_min_messages;" say?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2014-02-10 15:54:33 Re: How to turn off DEBUG statements from psql commends
Previous Message peterlen 2014-02-10 15:43:33 How to turn off DEBUG statements from psql commends