Hi, Please ignore my previous mail. I had given data directory location incorrectly.Anyways,even after giving the absolute path for exe location, i get the same error message as before:
D:\pgsql\bin\pg_ctl.exe -U postgres -P <mypasswd> -w start -D D:\pgsql\data *waiting for server to start...FATAL: postgres: could not locate matching postgres executable* Thanks ! On Tue, Mar 31, 2009 at 4:31 PM, CM J <postgres.new...@gmail.com> wrote: > Hi, > > I don't have multiple postgres installed.Anyway, tried your > suggestion to use the full path name and here is what i get: > > D:\pgsql\bin>D:\pgsql\bin\pg_ctl.exe -U postgres -P <mypasswd> -w start > -D:\pgsql\data > > pg_ctl: could not open PID file ":/pgsql/data/postmaster.pid": Invalid > argument > > There is no data directory created by default (i used > no-installer-zip file to install postgres), so i went ahead and created a > dummy data directory which gave the same result as above. Any suggestions ?? > > Thanks. > > > On Tue, Mar 31, 2009 at 4:09 PM, Richard Huxton <d...@archonet.com> wrote: > >> CM J wrote: >> > pg_ctl.exe -U postgres -P <mypasswd> -w start -D D:\pgsql\data >> > >> > However, i get the following error message: >> > >> > waiting for server to start...FATAL: postgres: could not locate >> matching >> > postgres executable >> >> That does seem to suggest it found the executable but it didn't match >> versions with the data directory. Do you have two copies installed? If >> so, you'll probably want to specify the complete path to pg_ctl >> >> -- >> Richard Huxton >> Archonet Ltd >> > >