Re: Why does app fail?

From: "Paul Simpson" <Paul(dot)Simpson(at)spgs(dot)org>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why does app fail?
Date: 2004-02-24 12:09:18
Message-ID: s03b3f0e.093@spgs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for that! I'll have a look...

Paul

>>> Shridhar Daithankar <shridhar(at)frodo(dot)hserus(dot)net> 24/02/2004 12:02:30 >>>
On Tuesday 24 February 2004 16:51, Paul Simpson wrote:
> 1) If there is a log somewhere showing failed requests, I might be able to
> see what the application is trying to do and then figure out a way around
> it.

You can log in every query server is executing. You need to enable the
corresponding log statement in pg_hba.conf. I think it is called
log_statement.

And of course, don't throw away server logs. If they are redirected
to /dev/null, they are useless anyways..

I am sure you will find lot of information in there..

HTH

Shridhar

ABOUT THIS E-MAIL
The information contained within this e-mail is privileged, confidential and protected from disclosure.

Any opinions expressed in this electronic communication do not necessarily reflect official policy of St Paul's Girls' School.

If you are not the intended recipient of this document or any part then please:

1) : inform the sender at the above address
2) : delete this e-mail immediately
3) : do not take copies nor disclose the contents of this document to anyone

PUPILS' COMMUNICATIONS
Only Senior School pupils of St Paul's Girls' School are permitted to send electronic mail and then only via our controlled system.
It is contrary to school rules for any other pupil to do so and they are regularly reminded of this fact.

VIRUS PROTECTION
All electronic mail traffic sent from this establishment is monitored and scanned for viruses prior to sending.

Browse pgsql-general by date

  From Date Subject
Next Message Nagib Abi Fadel 2004-02-24 12:46:01 ON DELETE RULE problem
Previous Message Shridhar Daithankar 2004-02-24 12:02:30 Re: Why does app fail?