Skip site navigation (1) Skip section navigation (2)

Re: reindexdb command utlility

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
Cc: Henrik Zagerholm <henke(at)mac(dot)se>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: reindexdb command utlility
Date: 2006-06-07 13:13:15
Message-ID: 200606071313.k57DDFQ00413@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Patch applied.  Thanks.

---------------------------------------------------------------------------


Euler Taveira de Oliveira wrote:
> > I used wanted to point out the the ( -q, --quiet ) parameter for  
> > reindexdb command utility does not work.
> Actually it is *not* a bug. The NOTICE is printed by the REINDEX
> command; reindexdb is just a wrapper around REINDEX command. If you
> set up 'client_min_messages' in postgresql.conf, you don't get those
> 'annoying' messages.
> 
> > Also reindexdb writes NOTICE to standard err for every table it  
> > reindexes which makes it really hard to use in script as it always  
> > produces an "errror".  :-)
> > 
> You can always ignore NOTICE. grep is your friend. :-)
> 
> Looking at the code, IMHO we could raise the ereport from NOTICE to
> INFO (see the patch attached). None of the scripts actually raise
> NOTICEs if it succeeds.
> 
> Comments?
> 
> 
> -- 
>   Euler Taveira de Oliveira
>   http://www.timbira.com/

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

-- 
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2006-06-07 13:22:54
Subject: Re: Problem configuring PostgreSQL 8.1.4 on Mac OS X
Previous:From: Bruce MomjianDate: 2006-06-07 03:34:36
Subject: Re: stopping server does not remove external_pid_file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group