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 executableThanks !
On Tue, Mar 31, 2009 at 4:31 PM, CM J
<postgres.newbie@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.
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