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
