Re: prepared statements logging - Mailing list pgsql-hackers

From tomas@tuxteam.de
Subject Re: prepared statements logging
Date
Msg-id 20070411060346.GA18225@www.trapp.net
Whole thread Raw
In response to prepared statements logging  ("marcofuics" <marcofuics@netscape.net>)
List pgsql-hackers
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, Apr 10, 2007 at 02:53:32AM -0700, marcofuics wrote:
> Hi *
> I am using the postgresql-8.2.3, with a jdbc-8.2-504.... (the GeoNet
> webServer tool...) My question is :
> Is the <<PostGresDB>> server able to log the whole <<SELECT>> query?
> {made by a prepared statement????}
> Looking at the log I can see only queries of the type:
> TIP 5: don't forget to increase your free space map settings

Wrong list. This is one dedicated for people working on the innards of
PostgreSQL. You'd want one of <pgsql-admin@postgresql.org> or
<pgsql-novice@postgresql.org>.

Now to your question: there are many configuration parameters in the
config file (possibly in /etc/postgresql/8.2/main/postgresql.conf or
some similar location, depending on your OS and distribution) to control
the level of logging. Look there for entries named log_xxx and
debug_xxx.

HTH
- -- tomás
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFGHHpCBcgs9XrR2kYRAs4SAJ45gvCVcp4Avk4t7NgQ/SST0s35owCggdWQ
CcVc9UluRe4d/Gl8ERV7z4I=
=P8EJ
-----END PGP SIGNATURE-----



pgsql-hackers by date:

Previous
From: ITAGAKI Takahiro
Date:
Subject: Question about SHM_QUEUE
Next
From: "Pavan Deolasee"
Date:
Subject: Re: CIC and deadlocks