FW: [ADMIN] pg_dump: schema with OID 2200 does not exist

2012-05-14 Thread Elizandro Gallegos
Hello Please can I be removed from the mailing list, and I receive many emails like this thanks ЄLIZANDЯO GALLEGOS V. > Date: Wed, 9 May 2012 09:58:45 -0400 > From: chander.gane...@gmail.com > To: pgsql-admin@postgresql.org > Subject: [ADMIN] pg_dump: schema with O

[ADMIN] dangling connections

2012-05-14 Thread Daryl Stultz
Hello, I have a tomcat server with 7 applications connecting to PG 8.4. All apps use connection pooling. Over the weekend the apps ran out of connections. The max connections is at the default of 100 which is more than enough for normal operations. In attempting to resolve the situation I shutdown

[ADMIN] CPU Load question / PgBouncer config

2012-05-14 Thread Benjamin Krajmalnik
I am experiencing a little higher CPU load than I would like to see, and was wondering if it has to do with the number of connections (although many are idle). I am running PG 9.0.4/amd64 on FreeBSD 8.1., dual boxes running streaming replication. Hardware is a 16 core box with 96GB RAM, using 6GB

Re: [ADMIN] CPU Load question / PgBouncer config

2012-05-14 Thread k...@rice.edu
On Mon, May 14, 2012 at 11:02:30AM -0600, Benjamin Krajmalnik wrote: > I am experiencing a little higher CPU load than I would like to see, and > was wondering if it has to do with the number of connections (although > many are idle). > > I am running PG 9.0.4/amd64 on FreeBSD 8.1., dual boxes run

[ADMIN] Monitoring for failed autovacuum

2012-05-14 Thread John Rouillard
Hello all: I am running postgres 8.4.7 as supplied by centos 5.8. I get a number of messages like: ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table "template0.pg_catalog.pg_shdepend" for a number of different tables in my databases. We use slony to do replication and