Re: pg_ctl vs. Windows locking

Bruce Momjian <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
Good report.  Would you check to see if a sleep or loop checking if the
file is unused would help?

---------------------------------------------------------------------------

Andrew Dunstan wrote:
> 
> pg_ctl seems to be working for Windows now, except that there are occasional Windows file locking issues, especially on restart - see below.
> 
> cheers
> 
> andrew
> 
> 
> C:\msys\1.0\local\pgsql>bin\pg_ctl -D data -l logfile restart
> waiting for postmaster to shut down....done
> postmaster stopped
> postmaster starting
>  
> C:\msys\1.0\local\pgsql>
> C:\msys\1.0\local\pgsql>
> C:\msys\1.0\local\pgsql>
> C:\msys\1.0\local\pgsql>
> C:\msys\1.0\local\pgsql>bin\pg_ctl -D data -l logfile restart
> waiting for postmaster to shut down....done
> postmaster stopped
> The process cannot access the file because it is being used by another process.
> Unable to run the postmaster binary
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [email protected]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.