Re: [ADMIN] db size growing out of control when using clustered Jackrabbit

2012-07-27 Thread Joshua D. Drake
On 07/26/2012 12:31 PM, Gary Webster wrote: OK, I set "log_statement = "all"" The log grew to 1GB in ~minute! It is dominated by this one statement, which occurs every ~1.4 sec: "update WS_BUNDLE set BUNDLE_DATA = $1 where NODE_ID_HI = $2 and NODE_ID_LO = $3" parameter $1 is hex, over 6million

Re: [ADMIN] pg_dump on Postgres 9.1

2012-07-27 Thread Tom Lane
Alanoly Andrews writes: > Is there any reported bug with pg_dump in Postgres 9.1, on AIX ? The > following command hangs for "ever" and has to be interrupted. It creates a > zero-length file. We had a recent report of strange server-side behavior on AIX that went away after rebuilding with a ne

[ADMIN] pg_dump on Postgres 9.1

2012-07-27 Thread Alanoly Andrews
Hello, Is there any reported bug with pg_dump in Postgres 9.1, on AIX ? The following command hangs for "ever" and has to be interrupted. It creates a zero-length file. pg_dump -Fc alan1 > alan1.dmp If I run the command in the verbose mode, I see that it stops at "saving database definition