Re: FATAL: lock file "postmaster.pid" already exists - Mailing list pgsql-general

From Magnus Hagander
Subject Re: FATAL: lock file "postmaster.pid" already exists
Date
Msg-id CABUevEx8p6BRgjBy-SwdYH5Q-cnow5Hh6KEh-AFg97_sRhrJyA@mail.gmail.com
Whole thread Raw
In response to Re: FATAL: lock file "postmaster.pid" already exists  (Mark Dilger <markdilger@yahoo.com>)
Responses Re: FATAL: lock file "postmaster.pid" already exists
List pgsql-general
On Thu, May 24, 2012 at 12:47 AM, Mark Dilger <markdilger@yahoo.com> wrote:
> I am running this code on Windows 2003.  It
> appears that postgres has in src/port/dirent.c
> a port of readdir() that internally uses the
> WIN32_FIND_DATA structure, and the function
> FindNextFile() to iterate through the directory.
> Looking at the documentation, it seems that
> this function does collect file creation time,
> last access time, last write time, file size, etc.,
> much like performing a stat.
>
> In my case, the code is iterating through roughly
> 56,000 files.  Apparently, this is doing the
> equivalent of a stat on each of them.

how did you end up with 56,000 files? Lots and lots and lots of tables?

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

pgsql-general by date:

Previous
From: Karthik
Date:
Subject: Is there a way to start postgresql v907 as non daemon process
Next
From: Magnus Hagander
Date:
Subject: Re: FATAL: lock file "postmaster.pid" already exists