Re: [ADMIN] logging

2011-05-06 Thread Tom Lane
"Campbell, Lance" writes: > I currently use PostgreSQL 8.4.x. > Below is a message I see in my logs. How can I display the values for > $1, $2, etc. within the logs? > ERROR: duplicate key value violates unique constraint "table_name_pkey" Update to 9.0.x. There's no capability for this befo

[ADMIN] logging

2011-05-06 Thread Campbell, Lance
I currently use PostgreSQL 8.4.x. Below is a message I see in my logs. How can I display the values for $1, $2, etc. within the logs? ERROR: duplicate key value violates unique constraint "table_name_pkey" STATEMENT: insert into schema_name.table_name(field1, field2, field3, field4, f

Re: [ADMIN] 'SGT DETAIL: Could not open file "pg_clog/05DC": No such file or directory' - what to do now?

2011-05-06 Thread Tomasz Chmielewski
On 04.05.2011 22:27, Tomasz Chmielewski wrote: Then another pg_clog file disappeared. OK, I have: bookstor=# SELECT * FROM core_wot_seq; sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called --+---

Re: [ADMIN] My server is oddly very slow

2011-05-06 Thread adrien ducos
Kevin Grittner a écrit : adrien ducos wrote: Kevin Grittner a écrit : What does this show?: free -m total used free shared buffers cached Mem: 3042 3000 4104 2896 -/+ buffers/cache: 99 2942 S