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.