Postgres: Packaging & Server Startup

Started by CM Jabout 17 years ago1 messagesgeneral
Jump to latest
#1CM J
postgres.newbie@gmail.com

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.