Hi again
I have tried to check different /var/log/messages on the servers but they only
go back 1 month. I also had quick glance at Nagios and Munin logs but I could
not find anything there.
This database is mainly used for reading data as it is now, but it's a couple
of applications which al
PostgreSQL 9.2.2
Is there a configuration parameter in PostgreSQL that will allow a full query
to be displayed in the log file?
What I see:
UPDATE abc.table set def=$1 WHERE id=$2
What I want to see:
UPDATE abc.table set def='hi bob' WHERE id=12
Thanks,
Lance Campbell
Software Architect
Web S
"Campbell, Lance" writes:
> What I see:
> UPDATE abc.table set def=$1 WHERE id=$2
> What I want to see:
> UPDATE abc.table set def='hi bob' WHERE id=12
It doesn't work that way. What you should be seeing, though, is that
the value of each parameter is included in a DETAIL line just after
the st
Yesyerday I had an issue where Postgres could not write to a fsm file
and started creating WAL files until it filled up the disk space on the
partition where the WAL files were located and panicked. I moved the
WASL files to the data partition, restarted postgres, and after about an
hour everythin
"Benjamin Krajmalnik" writes:
> Looking at pg_xlogs, I see that postgres is sequentially reusing all of
> the available WAL files, while looking at the log file, it is recycling
> approximately 70-80 files every checkpoint, but it is not removing any
> files.
[ squint... ] It should be removing
It is set to 1024 (I had set it to that level just in case it was needed
due to a peak in workload), and presently I have 2121 WAL files.
Thanks for the info - just reduced it to 256, and will go form there.
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Tuesday, Jan
Hi,
How can i get the listed columns which mentioned in a update command in a
trigger ?
Thanks And Regards.
wang
