Getting rid of postgres output

From: "Nicola Mauri" <Nicola(dot)Mauri(at)saga(dot)it>
To: pgsql-admin(at)postgresql(dot)org
Subject: Getting rid of postgres output
Date: 2006-08-07 14:00:15
Message-ID: OFBA5015CF.3E3EC482-ONC12571C3.004A9520-C12571C3.004CEFA0@saga.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I scheduled a dump between two databases, via network:

pg_dump --clean -U postgres mydb | psql -q -h remote_host -d mydb -U
postgres

I'd like to have no output being generated, unless an error condition
occurs, so that crond will email me only when something goes really wrong.
Unfortunately I'm getting this output:

setval
--------
551776
(1 row)

setval
--------
340537
(1 row)

setval
--------
10411
(1 row)

and so on........
It seems to be related to some sequences recently added to the database.
Actually we are getting one 'setval' line for each sequence defined.

Does anyone know how to get rid of this output?
Simply redirecting output is not a great idea, as we may loose some
precious error messages too; so I think we should prevent this messages to
being generate at all.
(Postgres 8.1.3 on RHEL4)

Thank You!
Nicola

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Srinivas Iyyer 2006-08-07 14:57:50 Re: pg_dump question -- did I delete my database -- please help -- urgent
Previous Message Richard Broersma Jr 2006-08-07 13:57:56 Re: pg_hba.conf includes