Postgres server startup

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

Hi,

When logged in as administrator, i start the postgres server with
the following command:

runas /user:postgres "D:\postgres_new\pgsql\bin\pg_ctl.exe start -D
D:\postgres_new\pgsql\data"

The problem is "runas" cmd is not script friendly as i can not
pass the password as a cmd line argument.Is there any way i can start the
postgres server using pg_ctl.exe while logged in as administrator without
using "runas" ??

Thanks!

#2John R Pierce
pierce@hogranch.com
In reply to: CM J (#1)
Re: Postgres server startup

CM J wrote:

Hi,

When logged in as administrator, i start the postgres server
with the following command:

runas /user:postgres "D:\postgres_new\pgsql\bin\pg_ctl.exe start -D
D:\postgres_new\pgsql\data"

The problem is "runas" cmd is not script friendly as i can
not pass the password as a cmd line argument.Is there any way i can
start the postgres server using pg_ctl.exe while logged in as
administrator without using "runas" ??

why isn't it installed as a Windows Service, then any administrator can
start it with....
NET START PGSQL_8.3