pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedQuery history file
5+ messages / 4 participants
[nested] [flat]
* Query history file
@ 2005-04-01 23:42 Mauro Bertoli <bertolima@yahoo.it>
2005-04-03 02:56 ` Re: Query history file Bruce Momjian <pgman@candle.pha.pa.us>
2005-04-03 08:03 ` Re: Query history file PFC <lists@boutiquenumerique.com>
0 siblings, 2 replies; 5+ messages in thread
From: Mauro Bertoli @ 2005-04-01 23:42 UTC (permalink / raw)
To: pgsql-sql
Hi,
I've installed a Postgres 8.0.
There's a history file with all executed queries?
Thanks!
___________________________________
Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… Scaricalo ora!
http://it.messenger.yahoo.it
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Query history file
2005-04-01 23:42 Query history file Mauro Bertoli <bertolima@yahoo.it>
@ 2005-04-03 02:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
1 sibling, 0 replies; 5+ messages in thread
From: Bruce Momjian @ 2005-04-03 02:56 UTC (permalink / raw)
To: Mauro Bertoli <bertolima@yahoo.it>; +Cc: pgsql-sql
Mauro Bertoli wrote:
> Hi,
> I've installed a Postgres 8.0.
> There's a history file with all executed queries?
If you are using psql, \s will show you your old queries. From the
server side, if you enable 'log_statement' all queries will go into the
server logs.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Query history file
2005-04-01 23:42 Query history file Mauro Bertoli <bertolima@yahoo.it>
@ 2005-04-03 08:03 ` PFC <lists@boutiquenumerique.com>
1 sibling, 0 replies; 5+ messages in thread
From: PFC @ 2005-04-03 08:03 UTC (permalink / raw)
To: Mauro Bertoli <bertolima@yahoo.it>; pgsql-sql
~/.psql_history is everything you typed in psql
On Sat, 02 Apr 2005 01:42:05 +0200, Mauro Bertoli <bertolima@yahoo.it>
wrote:
> Hi,
> I've installed a Postgres 8.0.
> There's a history file with all executed queries?
> Thanks!
>
>
>
> ___________________________________
> Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar,
> Webcam, Giochi, Rubrica… Scaricalo ora!
> http://it.messenger.yahoo.it
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Query history file
@ 2005-04-05 15:29 Mauro Bertoli <bertolima@yahoo.it>
2005-04-12 19:33 ` Re: Query history file Vivek Khera <vivek@khera.org>
0 siblings, 1 reply; 5+ messages in thread
From: Mauro Bertoli @ 2005-04-05 15:29 UTC (permalink / raw)
To: Bruce Momjian <pgman@candle.pha.pa.us>; +Cc: pgsql-sql
> From the
> server side, if you enable 'log_statement' all
> queries will go into the
> server logs.
Thank you, I enabled
log_statement = all
log_duration = true
It's beautiful! :)
___________________________________
Nuovo Yahoo! Messenger: E' molto più divertente: Audibles, Avatar, Webcam, Giochi, Rubrica… Scaricalo ora!
http://it.messenger.yahoo.it
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Query history file
2005-04-05 15:29 Re: Query history file Mauro Bertoli <bertolima@yahoo.it>
@ 2005-04-12 19:33 ` Vivek Khera <vivek@khera.org>
0 siblings, 0 replies; 5+ messages in thread
From: Vivek Khera @ 2005-04-12 19:33 UTC (permalink / raw)
To: Mauro Bertoli <bertolima@yahoo.it>; +Cc: pgsql-sql
On Apr 5, 2005, at 11:29 AM, Mauro Bertoli wrote:
>> From the
>> server side, if you enable 'log_statement' all
>> queries will go into the
>> server logs.
> Thank you, I enabled
> log_statement = all
> log_duration = true
You may also want
log_min_error_statement = error
else any statement that causes an error (such as a typo) will not be
logged -- just the error gets logged. Makes debugging of very complex
systems much easier to be able to see the full query that caused the
problem.
Vivek Khera, Ph.D.
+1-301-869-4449 x806
Attachments:
smime.p7s (application/pkcs7-signature, 2.4K) download
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2005-04-12 19:33 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-04-01 23:42 Query history file Mauro Bertoli <bertolima@yahoo.it>
2005-04-03 02:56 ` Bruce Momjian <pgman@candle.pha.pa.us>
2005-04-03 08:03 ` PFC <lists@boutiquenumerique.com>
2005-04-05 15:29 Re: Query history file Mauro Bertoli <bertolima@yahoo.it>
2005-04-12 19:33 ` Vivek Khera <vivek@khera.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox