[postgis-users] debug_level options?

[Tyler Mitchell]

Who knows if the debug options are even in the binary?  Because the
compilation was done behind closed doors and I've seen some quirky things
every now and then, I wouldn't be surprised if they left it out.

Did anyone on this list help get the postgis compiled against Multeras
win32 version of postgres?

Tyler


                                                                                                                           
                      "Mike Leahy"                                                                                         
                      <mgleahy at fes.uwaterloo.ca>                To:       "'PostGIS Users Discussion'"                     
                      Sent by:                                   <postgis-users at postgis.refractions.net>                   
                      postgis-users-bounces at postgis.refr        cc:                                                        
                      actions.net                               Fax to:                                                    
                                                                Subject:  RE: [postgis-users] debug_level options?         
                                                                                                                           
                      06/05/2003 04:08 PM                                                                                  
                      Please respond to PostGIS Users                                                                      
                      Discussion                                                                                           
                                                                                                                           
                                                                                                                           




Okay...checked that file, and the debug_level there is 0 (out of a range
of 0 to 16).  I think there must be another debug_level option somewhere
else that I need to change...but I haven't found it in that folder...

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: June 5, 2003 6:06 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] debug_level options?

If I recall correctly, you are using a precompiled binary. Check in the
postgresql.conf file and see if the debugging is cranked up in there to
some non-default value.
P.

Mike Leahy wrote:
> Hello all again.
>
> I have what I hope is a fairly simple question.when I do a query on a
> map using layers from a PostGIS database, string of results will
scroll
> by in the Postmaster command window.  Most of it looks like super long
> series of TARGETENTRY statements (below).
>
> This is also followed by a series of NOTICE messages before the query
> finishes.  The whole thing overall is working fine, but it can
sometimes
> be a fairly lengthy wait if there are multiple layers and lots of
small
> polygons.  I expect it would be significantly faster if I could have
the
> postmaster work in a quiet mode of some type, either with the window
> hidden or by turning off message reporting.  I experimented with
passing
> a debug_level parameter (-d 1) with the pg_ctl command (i.e., pg_ctl
> start -o "-i -d 1"), but that didn't really change anything.  Does
> anybody have any suggestions?
>
> BTW: We are volunteering for an NGO in Peru to build an education
> information system based on spatial data, and have relatively little
> access to any development support network.  As a result, we have been
> relying heavily on email discussion lists.  We appreciate all of the
> help that has been offered by the participants of this list.
>
> Kind regards,
> Mike
> __________________________________________
>
> { TARGETENTRY
> :resdom
>    { RESDOM
>    :resno 66
>    :restype 23
>    :restypmod -1
>    :resname a_gra07gm
>    :reskey 0
>    :reskeyop 0
>    :ressortgroupref 0
>    :resjunk false
>    }
>
> :expr
>    { VAR
>    :varno 1
>    :varattno 66
>    :vartype 23
>    :vartypmod -1
>    :varlevelsup 0
>    :varnoold 1
>    :varoattno 66
>    }
> }
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


--
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users