[ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)

2012-12-13 Thread Haifeng Liu
Hi, I have a DB writer program written in Java, it do batch updates, and will try to update each record in a batch if it failed. I think no any record in a batch will be update if the batch failed, but weirdly I found a few records update twice(very little amount among all records). Well,

[ADMIN] pooler/router?

2012-12-13 Thread Bèrto ëd Sèra
Hi all, I have a customer who needs to split a set of pg databases that have outgrown any possible big iron and needs to do it quick, at zero impact on lots of existing and basically undocumented applications. I was wondering whether there is anything I can drop in as a middleware, that will get

Re: [ADMIN] pooler/router?

2012-12-13 Thread Gabriele Bartolini
Hi Bèrto, On Thu, 13 Dec 2012 12:39:28 +, Bèrto ëd Sèra berto.d.s...@gmail.com wrote: I was wondering whether there is anything I can drop in as a middleware, that will get any incoming connections to oldserver:5432 and reroute them to a set of individual boxes, based on the targeted

Re: [ADMIN] Confuse about the behaveior of PreparedStatement.executeBatch (jdbc)

2012-12-13 Thread Kevin Grittner
Haifeng Liu wrote: I wanna know if executeBatch really keep all the records in a batch untouched when the batch failed. I recommend asking on the pgsql-jdbc list. You might want to mention what autoCommit is set to during the attempt. -Kevin -- Sent via pgsql-admin mailing list

[ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-13 Thread Greg Williamson
This seems like a question whose answer must be right in front of me, but I am not seeing it. We want to create a role used by a monitor to check for IDLE in Transaction with the most restrictive permissions we can on a 8.4.13 instance. The user has been granted connect privilege to the

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-13 Thread Tom Lane
Greg Williamson gwilliamso...@yahoo.com writes: We want to create a role used by a monitor to check for IDLE in Transaction with the most restrictive permissions we can on a 8.4.13 instance. The user has been granted connect privilege to the database and some limited permissions to user

Re: [ADMIN] allow a user to see current_query in pg_stat_activity in 8.4

2012-12-13 Thread Greg Williamson
Tom -- Greg Williamson gwilliamso...@yahoo.com writes: We want to create a role used by a monitor to check for IDLE in Transaction with the most restrictive permissions we can on a 8.4.13 instance. The user has been granted connect privilege to the database and some limited permissions