Re: register a service in Windows

Поиск
Список
Период
Сортировка
От Josi Perez (3T Systems)
Тема Re: register a service in Windows
Дата
Msg-id i2q76a181e91004221111q10e542a7h6b2df466960466f2@mail.gmail.com
обсуждение исходный текст
Ответ на register a service in Windows  ("Josi Perez (3T Systems)" <josiperez3t@gmail.com>)
Ответы Re: register a service in Windows  (BlackSkaven <BlackSkaven@gmx.de>)
Список 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@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\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

#avg_ls_inline_popup { position:absolute; z-index:9999; padding: 0px 0px; 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;}

В списке pgsql-admin по дате отправления:

Предыдущее
От: German Salinas
Дата:
Сообщение: Re: [pgsql-es-ayuda] REF: Migracion de Sqlserver a Postgresql
Следующее
От: Jan-Peter Seifert
Дата:
Сообщение: Re: initdb failure