register a service in Windows

--000e0cd13a825a3e35048498d53b
Content-Type: text/plain; charset=ISO-8859-1

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\postgre sql-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

--000e0cd13a825a3e35048498d53b
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi, I'm trying to start=
automatically 3 postgresql services in Windows without success. 
 What I already do: 1) Insta=
ll postgres8.4.2 binaries for Windows - ok, this service installs automatic=
ally without any action mine; 
 2) Created 2 new clusters: =
C:\Program
Files\PostgreSQL\8.4>bin\initdb
--pgdata "C:\data5"=A0 --encoding 'UTF8' --locale 'pt=
_BR.UTF-8' --username postgres C:\Program
Files\PostgreSQL\8.4>bin\initdb
--pgdata "C:\data7"=A0 --encoding 'UTF8' --locale 'pt=
_BR.UTF-8' --username
postgres 
 and changed the postgres.conf contained in each of the=
se directories: in C:\data5:=A0 port=3D5430</spa=
n> 
in C:\data7:=A0 port=3D543=
4 3) Started pg_ctl manually and worked with the clusters/databases inside p=
gAdminIII, including port 5432: 
C:\data5>"C:\Progr=
am
Files\PostgreSQL\8.4\bin\pg_ctl"=A0 -D "C:\data5" -N postgre=
s842w5430=A0
-l logfile5430=A0 start C:\data7>"C:\Program
Files\PostgreSQL\8.4\bin\pg_ctl"=A0 -D "C:\data7" -N postgre=
s842w5434=A0
-l logfile5434=A0 start But, I want to start each cluster aut=
omatically. 1) If I try to register C:\data5>"C:\Program File=
s\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 reg=
edit I can see: HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\pos=
tgresql-8.4 HKEY_LOCAL_MACHIN=
E\SOFTWARE\PostgreSQL\Services\pgsql-8.4 
 but, how can I add a new service? In Installations there is a key &q=
uot;Data Directory" - then, to start another cluster I needed to insta=
ll 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 thes=
e 3 data base areas as a service in Windows? 
 Thanks in advance. Josi Perez <div style=3D"visibility: hidden; display: inline; font-family: ve=
rdana,sans-serif;" id=3D"avg_ls_inline_popup"></div><style type=3D"text/css=
">#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0=
px; margin-left: 0px; margin-top: 0px; width: 240px; overflow: hidden; =
word-wrap: break-word; color: black; font-size: 10px; text-align: left;=
line-height: 13px;}</style>

--000e0cd13a825a3e35048498d53b--

--0016e64b96daa9157c0484d73e42
Content-Type: text/plain; charset=ISO-8859-1

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.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\postgre sql-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
>

--0016e64b96daa9157c0484d73e42
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I tried to use SC Windows =
command (Service Commander) with an administrative login, but no success ag=
ain: <div style=3D"mar=
gin-left: 40px;">
net user postgres mypass /add
 sc create</b=
>
pgsql-8.4 binpath=3D "C:\postgres\8.4\bin\=
pg_ctl.exe

 runservice -w -N pgsql-8.4 -D C:\data5\"
type=3Down start=3Dauto displayname=3D "Postgr=
eSQL
8.4 p5430" password=3D mypass <=
span style=3D"font-family: verdana,sans-serif;">sc</=
b> start pgsql-8.4
 </div>


 All commands above give me "Access denied&=
quot;. 
Anyone have a tip? Am I in=
a wrong list to ask about this? Thanks in advan=
ce, 
Josi Perez <div class=3D"gmail_quote=
">2010/4/19 Josi Perez (3T Systems) <<a href=3D"mailto=
:josiperez3t [at] gmail.com" target=3D"_blank">josiperez3t [at] gmail.com</a>></sp=
an> 
<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi, I'm trying to start=
automatically 3 postgresql services in Windows without success. 

 What I already do: 1) Insta=
ll postgres8.4.2 binaries for Windows - ok, this service installs automatic=
ally without any action mine; 

 2) Created 2 new clusters: =
C:\Program
Files\PostgreSQL\8.4>bin\initdb
--pgdata "C:\data5"=A0 --encoding 'UTF8' --locale 'pt=
_BR.UTF-8' --username postgres C:\Program
Files\PostgreSQL\8.4>bin\initdb
--pgdata "C:\data7"=A0 --encoding 'UTF8' --locale 'pt=
_BR.UTF-8' --username
postgres 
 and changed the postgres.conf contained in each of the=
se directories: in C:\data5:=A0 port=3D5430</spa=
n> 

in C:\data7:=A0 port=3D543=
4 3) Started pg_ctl manually and worked with the clusters/databases inside p=
gAdminIII, including port 5432: 

C:\data5>"C:\Progr=
am
Files\PostgreSQL\8.4\bin\pg_ctl"=A0 -D "C:\data5" -N postgre=
s842w5430=A0
-l logfile5430=A0 start C:\data7>"C:\Program
Files\PostgreSQL\8.4\bin\pg_ctl"=A0 -D "C:\data7" -N postgre=
s842w5434=A0
-l logfile5434=A0 start But, I want to start each cluster aut=
omatically. 1) If I try to register C:\data5>"C:\Program File=
s\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 reg=
edit I can see: HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\pos=
tgresql-8.4 HKEY_LOCAL_MACHIN=
E\SOFTWARE\PostgreSQL\Services\pgsql-8.4 

 but, how can I add a new service? In Installations there is a key &q=
uot;Data Directory" - then, to start another cluster I needed to insta=
ll 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 thes=
e 3 data base areas as a service in Windows? 

 Thanks in advance. Josi Perez <div style=3D"display: inline; font-family=
: verdana,sans-serif;"></div>
</blockquote></div> <div style=3D"display: inline;"></div>
<div style=3D"visibility: hidden; display: inline;" id=3D"avg_ls_inline_pop=
up"></div><style type=3D"text/css">#avg_ls_inline_popup { position:absolut=
e; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; =
width: 240px; overflow: hidden; word-wrap: break-word; color: black; fo=
nt-size: 10px; text-align: left; line-height: 13px;}</style>

--0016e64b96daa9157c0484d73e42--

Hello,

just use pg_ctl register ;)

http://www.postgresql.org/docs/8.4/interactive/app-pg-ctl.ht ml

Good luck,

Peter

Am 22.04.2010 20:11, schrieb Josi Perez (3T Systems):
> 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.com
> <mailto:josiperez3t [at] gmail.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\postgre sql-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
>
>

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

--005045013ed8460655048565d9ee
Content-Type: text/plain; charset=ISO-8859-1

Peter, thank you for your efforts in try to help me and sorry for send the
message directly to you, not for the list.
No success yet - I'm starting (and stoping) manually the 2 extra services.

About the locale, I removed this option at initdb - I will try to solve this
after the service is running.
If I use pg_ctl runservice, I got the message:
1063 ERROR_FAILED_SERVICE_CONTROLLER_CONNECT The service process could not
connect to the service controller.

If I use pg_ctl register, I continue to receive the same error - no matter
what I do:
can not open the service manager

I made a Google search and looks like no one have problems with pg_ctl
register.
Probably I am doing a stupid thing, but I can not see what.
Sugestions?

Thank you in advance,
Josi Perez

2010/4/24 BlackSkaven <BlackSkaven [at] gmx.de>

> Hello Josi,
>
> Well - I happen to have Windows 7 on my personal PC.
>
> -switched off UAC via tools in msconfig and restarted Windows.
> -started Windows service 'Secondary Logon' and set it to automatic
> -initialized a new cluster (BTW: the locale you specified does'nt
> exists on Windows. Windows uses codepages instead.)
> -registered it:
> pg_ctl register -N "postgresql-8.4_2nd" -U postgres -P "password" -D
> "C:\data5" -w
>
> I just used the basic options. Check the docs for the options that fit
> your needs.
>
> Ready ;)
>
> Good luck,
>
> Peter
>

--005045013ed8460655048565d9ee
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Peter, thank you for your =
efforts in try to help me and sorry for send the message directly to you, n=
ot for the list. <span=
style=3D"font-family: verdana,sans-serif;">No success yet - I'm starti=
ng (and stoping) manually the 2 extra services. 
 About the locale, I removed this option at initdb - I =
will try to solve this after the service is running. 

If I use pg_ctl runservice, I got the message: 1=
063 ERROR_FAILED_SERVICE_CONTROLLER_CONNECT The service process could
not connect to the service controller. If I use pg_ctl register, I continue =
to receive the same error - no matter what I do: 
can not open the service m=
anager I made a Google search and looks like no one have problems with pg_ct=
l register. 
Probably I am doing a stup=
id thing, but I can not see what. Sugestions?</s=
pan> 
 Thank you in advance, Josi =
Perez 
 <div class=3D"gmail_quote">2010/4/24 BlackSkaven <<a href=3D"mailto:BlackSkaven [at] gmx.de" target=3D"_blank">BlackSkaven=
[at] gmx.de</a>> 

<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hello Josi, 
 
Well - I happen to have Windows 7 on my personal PC. 
 
-switched off UAC via tools in msconfig and restarted Windows. 
-started Windows service 'Secondary Logon' and set it to automatic<=
br>
-initialized a new cluster =A0(BTW: the locale you specified does'nt<br=
>
exists on Windows. Windows uses codepages instead.) 
-registered it: 
pg_ctl register -N "postgresql-8.4_2nd" -U postgres -P "pass=
word" -D 
"C:\data5" -w 
 
I just used the basic options. Check the docs for the options that fit 
your needs. 
 
Ready ;) 
 
Good luck, 
 
Peter </blockquote></div> <div style=3D"display: inline;"></div>
<div style=3D"display: inline;"></div>
<div style=3D"visibility: hidden; display: inline;" id=3D"avg_ls_inline_pop=
up"></div><style type=3D"text/css">#avg_ls_inline_popup { position:absolut=
e; z-index:9999; padding: 0px 0px; margin-left: 0px; margin-top: 0px; =
width: 240px; overflow: hidden; word-wrap: break-word; color: black; fo=
nt-size: 10px; text-align: left; line-height: 13px;}</style>

--005045013ed8460655048565d9ee--

register a service in Windows

Re: register a service in Windows

Re: register a service in Windows

Re: register a service in Windows