Getting rid of postgres output

Поиск
Список
Период
Сортировка
От Nicola Mauri
Тема Getting rid of postgres output
Дата
Msg-id OFBA5015CF.3E3EC482-ONC12571C3.004A9520-C12571C3.004CEFA0@saga.it
обсуждение исходный текст
Ответы Re: Getting rid of postgres output  ("Aaron Bono" <postgresql@aranya.com>)
Re: Getting rid of postgres output  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: Getting rid of postgres output  (Jim Nasby <jnasby@pervasive.com>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: pg_hba.conf includes
Следующее
От: Srinivas Iyyer
Дата:
Сообщение: Re: pg_dump question -- did I delete my database -- please help -- urgent