Thread: windows service

windows service

From
garry@schoolteachers.co.uk
Date:
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.
Regards
Garry

Re: windows service

From
Thomas Kellerer
Date:
garry@schoolteachers.co.uk wrote on 03.05.2009 13:32:
> 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.

If the service is already registered with the name "P4", you can start it using

net start P4

Thomas

Re: windows service

From
Dave Page
Date:
On Sun, May 3, 2009 at 12:32 PM,  <garry@schoolteachers.co.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

Re: windows service

From
Adam Ruth
Date:
One option is sc.exe command.

sc create postgresql binPath= "^"c:\scholarpack\postgres\bin
\pg_ctl.exe^" runservice -w -N ^"P4^" -D ^"c:\scholarpack\data^"" -
start auto

On 03/05/2009, at 9:32 PM, garry@schoolteachers.co.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.
> Regards
> Garry
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general


Re: windows service

From
John R Pierce
Date:
Adam Ruth wrote:
> One option is sc.exe command.
>
> sc create postgresql binPath=
> "^"c:\scholarpack\postgres\bin\pg_ctl.exe^" runservice -w -N ^"P4^" -D
> ^"c:\scholarpack\data^"" -start auto

except, on a SC CREATE, you'd need to specify a lot more than just the
binpath.   I'd suspect at least  obj= username password= password

Far better to use the pg_ctl register command as Dave Page said...