Re: windows service

On Sun, May 3, 2009 at 12:32 PM, <garry(at)schoolteachers(dot)co(dot)uk> wrote:
> Anyone know how to install Postgresql as a windows service from the command
> line.
> I have this as the correct syntax:
> "c:\scholarpack\postgres\bin\pg_ctl.exe" runservice -w -N "P4" -D
> "c:\scholarpack\data"
>
> Where P4 is the name of the service. However, I can not get the sc command to
> accept the above string on the command line. Any help would be much
> appreciated.

pg_ctl can install itself:

pg_ctl register [-N servicename] [-U username] [-P password] [-D
datadir] [-w] [-t seconds] [-o options]

http://www.postgresql.org/docs/8.3/interactive/app-pg-ctl.html

--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com