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)
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' insi
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
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 hop
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 pr
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 t
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 trig
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
que
