Christophe Pettus wrote:
Greetings,
Is there a combination of options that will cause a hot standby replica to
log queries that are cancelled due to a replication timeout
(max_standby_streaming_delay)?
Sure, how about the system view pg_stat_database_conflicts in PG 9.1?
Our docs say:
Greetings,
Is there a combination of options that will cause a hot standby replica to log
queries that are cancelled due to a replication timeout
(max_standby_streaming_delay)?
--
-- Christophe Pettus
x...@thebuild.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
Setting postgresql 8.1.3 to log all queries only logs direct queries, not ones made as part of a stored procedure (function) call.Is there a way to get it to log queries that are part of functions?--Mike Nolan
On 9/8/06, Michael Nolan [EMAIL PROTECTED] wrote:
Setting postgresql 8.1.3 to log all queries only logs direct queries,
not ones made as part of a stored procedure (function) call.
Is there a way to get it to log queries that are part of functions?
not really, but you can 'raise notice'
Hi all,
I've got a machine I am setting up (read; low volume atm). I need a
way to log all the queries made to Postgres (just for a short time).
I've got a problem with a 3rd party program (OSS, but I'm not 'let'
enough to trace it) and I am hoping to help fix the problem by being
able
Madison Kelly wrote:
Hi all,
I've got a machine I am setting up (read; low volume atm). I need a
way to log all the queries made to Postgres (just for a short time).
I've got a problem with a 3rd party program (OSS, but I'm not 'let'
enough to trace it) and I am hoping to help fix the
Madison Kelly wrote:
Madison Kelly wrote:
Hi all,
I've got a machine I am setting up (read; low volume atm). I need a
way to log all the queries made to Postgres (just for a short time).
I've got a problem with a 3rd party program (OSS, but I'm not 'let'
enough to trace it) and I am
On Fri, Oct 29, 2004 at 11:18:48PM +0200, stig erikson wrote:
i would like to log every single query coming in to the database into a
table. i would like the log to include the entire query and execution
time and execution cost, and if possible the user that executed the query.
A trigger
Hi.
i would like to log every single query coming in to the database into a
table. i would like the log to include the entire query and execution
time and execution cost, and if possible the user that executed the query.
A trigger is what i was thinking of, but how can i find out the actual