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.newbie@xxxxxxxxx> wrote:
Hi,D:\pgsql\bin>D:\pgsql\bin\pg_
I don't have multiple postgres installed.Anyway, tried your suggestion to use the full path name and here is what i get:
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 <dev@xxxxxxxxxxxx> wrote:
CM J wrote:That does seem to suggest it found the executable but it didn't match
> 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
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
