[ADMIN] PgPool-II - does it do re-connect?

2010-05-10 Thread Evan Rempel
I am looking ahead to when postgresql 9.x is non-beta and how we can best make use of the "virtually synchronous" replication. At our site, we have a load balancer appliance that works very well in that it can direct a connection to one of a number of back ends. When one back end goes away, conne

Re: [ADMIN] List of postgreSQL databases

2010-05-10 Thread Tom Lane
"Andreas 'ads' Scherbaum" writes: >> SELECT datname FROM pg_database; > Is this guaranteed to stay forever? It seems reasonably unlikely that we'd change it. Even if we did, we have in the past provided compatibility views (cf pg_user, pg_shadow) when removing a catalog --- I would think the sa

Re: [ADMIN] List of postgreSQL databases

2010-05-10 Thread Andreas 'ads' Scherbaum
Hello, I want to raise this topic again. On Tue, 6 Apr 2010 15:39:35 +0400 Sergey Konoplev wrote: > On 6 April 2010 15:22, Renato Oliveira > wrote: > > Is there a specific ‘STATEMENT’ to display the same thing? > > Try this > > SELECT datname FROM pg_database; Is this guaranteed to stay fo

Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Greg Spiegelberg
2010/5/7 Silvio Brandani > Greg Spiegelberg ha scritto: > > >> Is this system a virtual machine? >> >> Greg >> >> No is not, > > is up and runnig from 4 months , 60 G of data in 9 different databases. > Lately we import a new schema in one of those databases . > > Okay. I asked because I have s

Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Silvio Brandani
Giles Lean ha scritto: Silvio Brandani wrote: yes the server is dedicated to PostgreSQL. Could be a bug of PostgreSQL the fact that the system went Out of Memory?? Wath can be the cause of it? Regards, Silvio The out of memory killer is a totally bogus misfeature of Linux. At le