Hi,
I am working on packaging postgres database in our java based application.I downloaded postgresql-8.2.12-1-binaries-no-installer.zip from the postgres site and installed it on a windows 2003 machine using administrator account.I later created a postgres service login account and changed the permissions on the postgres directory to include this user too.
When logged in as administrator , i tried starting the server using the following cmd:
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
I also tried the starting the server using runas :
runas /user:postgres "pg_ctl.exe -wait start -D D:\pgsql\data"
The above too failed.Please let me know on what i am missing here.
Thanks.
