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

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, the

[ADMIN] pooler/router?

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

Re: [ADMIN] pooler/router?

Hi Bèrto, On Thu, 13 Dec 2012 12:39:28 +, Bèrto ëd Sèra 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 database. PgPooler + rou

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

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 (pgsql-adm

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

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 " 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

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

Greg Williamson writes: > We want to create a role used by a monitor to check for " 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 tabhles that need to b

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

Tom -- >Greg Williamson writes: >> We want to create a role used by a monitor to check for " 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 tabhle