Skip site navigation (1) Skip section navigation (2)

Re: register a service in Windows

From: "Josi Perez (3T Systems)" <josiperez3t(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: register a service in Windows
Date: 2010-04-22 18:11:50
Message-ID: i2q76a181e91004221111q10e542a7h6b2df466960466f2@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
I tried to use SC Windows command (Service Commander) with an administrative
login, but no success again:
net user *postgres* mypass /add

*sc* *create* pgsql-8.4 binpath= "C:\*postgres*\8.4\bin\pg_ctl.exe
runservice -w -N pgsql-8.4 -D C:\data5\" type=own start=auto displayname= "*
PostgreSQL* 8.4 p5430" password= mypass

*sc* start pgsql-8.4

All commands above give me "Access denied".

Anyone have a tip? Am I in a wrong list to ask about this?
Thanks in advance,
Josi Perez



2010/4/19 Josi Perez (3T Systems) <josiperez3t(at)gmail(dot)com>

> Hi,
>
> I'm trying to start automatically 3 postgresql services in Windows without
> success.
>
> What I already do:
> 1) Install postgres8.4.2 binaries for Windows - ok, this service installs
> automatically without any action mine;
>
> 2) Created 2 new clusters:
> C:\Program Files\PostgreSQL\8.4>bin\initdb --pgdata "C:\data5"  --encoding
> 'UTF8' --locale 'pt_BR.UTF-8' --username postgres
> C:\Program Files\PostgreSQL\8.4>bin\initdb --pgdata "C:\data7"  --encoding
> 'UTF8' --locale 'pt_BR.UTF-8' --username postgres
>
> and changed the postgres.conf contained in each of these directories:
> in C:\data5:  port=5430
> in C:\data7:  port=5434
>
> 3) Started pg_ctl manually and worked with the clusters/databases inside
> pgAdminIII, including port 5432:
> C:\data5>"C:\Program Files\PostgreSQL\8.4\bin\pg_ctl"  -D "C:\data5" -N
> postgres842w5430  -l logfile5430  start
> C:\data7>"C:\Program Files\PostgreSQL\8.4\bin\pg_ctl"  -D "C:\data7" -N
> postgres842w5434  -l logfile5434  start
>
> But, I want to start each cluster automatically.
> 1) If I try to register
> C:\data5>"C:\Program Files\PostgreSQL\8.4\bin\pg_ctl" register -N
> "postgres842w5430" -D "C:\data5" -U postgres -P postgres
>
> comes the message:
> can not open the service manager
>
> 2) In regedit I can see:
> HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4
> HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Services\pgsql-8.4
>
> but, how can I add a new service?
> In Installations there is a key "Data Directory" - then, to start another
> cluster I needed to install binary PostgreSQL again with new parameters?
>
> 3) I tried to left these commands at autoexec.nt without success.
> 4) I tried to use batchrun to add these commands at startup and worked, but
> I needed an icon to stop the processes.
>
> Help.
> How can I start these 3 data base areas as a service in Windows?
>
> Thanks in advance.
> Josi Perez
>

In response to

Responses

pgsql-admin by date

Next:From: BlackSkavenDate: 2010-04-22 19:30:09
Subject: Re: register a service in Windows
Previous:From: Ernesto VerbanazDate: 2010-04-22 17:41:27
Subject: RE: REF: Migracion de Sqlserver a Postgresql

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group