SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 12:59 PM
| ||||
| ||||
 psql too noisy Hello - Can anyone suggest a way to suppress all STDOUT/STDERR output by the psql utility, except for >= ERROR level messages? In particular, I am trying to suppress NOTICE level messages. The purpose behind this is so that when a lengthy script is fed to psql to build a virgin DB, the many NOTICE lines output about things like "implicit sequence" and "implicit index" are suppressed. I have tried -q and -v VERBOSITY='terse' with no observed effect. Thanks in advance - Marc ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings      |
|
04-09-2008, 12:59 PM
| ||||
| ||||
| Re: psql too noisy Marc Evans wrote: > Hello - > > Can anyone suggest a way to suppress all STDOUT/STDERR output by the psql > utility, except for >= ERROR level messages? In particular, I am trying > to suppress NOTICE level messages. The purpose behind this is so that when > a lengthy script is fed to psql to build a virgin DB, the many NOTICE > lines output about things like "implicit sequence" and "implicit index" > are suppressed. Set client_min_messages to WARNING. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
