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) <[email protected]> > 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 >
