Re: How to turn off DEBUG statements from psql commends

Somehow your postgres log statements are getting echoed to the front
end. Did you change anything about the postgres (server) configuration file?

On Mon, Feb 10, 2014 at 07:43:33AM -0800, peterlen wrote:
> 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,
> xid/subid/cid:
> 0/1/0, nestlvl: 1, children:
> LOG: statement: create schema test;
> DEBUG: ProcessUtility
> DEBUG: CommitTransactionCommand
> DEBUG: CommitTransaction
> DEBUG: name: unnamed; blockState: STARTED; state: INPROGR,
> xid/subid/cid:
> 15099/1/1, nestlvl: 1, children:
> CREATE SCHEMA
> gis_demo=#
>
>
> Before, all I would get is the CREATE SCHEMA feedback. Not sure what may
> have caused this change on our end but does anyone know how to turn it off?
>
> Thanks - Peter
>
>
>
> --
> View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-turn-off-DEBUG-statements-from-psql-commends-tp5791250.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

--
Andrew Sullivan
ajs(at)anvilwalrusden(dot)com