Re: Problem with potato

[Marko Cehaja <marko@perlbroker.2y.net>]

Dear

On Mon, Aug 14, 2000 at 08:46:41AM +0930, John Pearson wrote:
> > 
> >                         DEBUG:  Pages 0: Changed 0, Reapped 0, Empty 0,
> > New 0; Tup 0: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0;
> > Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. Elapsed 0/0
> > sec.
> this is fixed by setting
> PGDEBUG=0
> (or, for that matter, PGDEBUG=anything).


Hmm, I found finally how to turn that off in potato as well. When I looked in the file /etc/postgresql/postmaster.init there were lines like:

# Debugging level at which the backend servers are to operate.                        
# 1: trace connection traffic only; >=2: turn on debugging in the backends            
# giving more information according to the debug level. Debug logs are                
# sent to $POSTGRES_LOG                                                               
# PGDEBUG=0                                                                           
                                                                                      
# Whether to echo queries to the debug log: yes/no                                    
# PGECHO=no

Well those lines were commented, and I just had to uncomment them. I tought that was default. But it isn't.

Sincerely,
Marko Cehaja