Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Silvio Brandani
Giles Lean ha scritto: Silvio Brandani silvio.brand...@tech.sdb.it 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

Re: [ADMIN] postgres invoked oom-killer

2010-05-10 Thread Greg Spiegelberg
2010/5/7 Silvio Brandani silvio.brand...@tech.sdb.it 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

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 renato.olive...@grant.co.uk wrote: Is there a specific ‘STATEMENT’ to display the same thing? Try this SELECT datname FROM pg_database; Is this

Re: [ADMIN] List of postgreSQL databases

2010-05-10 Thread Tom Lane
Andreas 'ads' Scherbaum adsm...@wars-nicht.de 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