We only use one database, not counting the built-in template databases. The server is running 9.1.3. We were running 9.1.1 until fairly recently.
We are still getting set up to test this on non-virtual hardware, but hope to have results from that in a few hours or less. ________________________________ From: Tom Lane <t...@sss.pgh.pa.us> To: Mark Dilger <markdil...@yahoo.com> Cc: deepak <deepak...@gmail.com>; Alban Hertroys <haram...@gmail.com>; "pgsql-general@postgresql.org" <pgsql-general@postgresql.org> Sent: Wednesday, May 23, 2012 12:23 PM Subject: Re: [GENERAL] FATAL: lock file "postmaster.pid" already exists Mark Dilger <markdil...@yahoo.com> writes: > We do not use tablespaces at all. [ scratches head... ] If you aren't using any tablespaces, there should be only *one* pgsql_tmp directory, which makes this even more confusing. (Unless you're using a pre-8.3 release, in which case there would be one per database, so maybe if you've got hundreds/thousands of databases in the cluster that would explain it. But I sure hope you're not still using pre-8.3, especially not on Windows.) regards, tom lane
