The reason for starting postgres as a service is so it will continue to run when the user logs out. When started as an
application,it will quit when you log out. Servers are generally left with nobody logged in. A really good reason for
thatin NT is that it saves you money. A real user can use that license.
Ian A. Harding
Programmer/Analyst II
Tacoma-Pierce County Health Department
(253) 798-3549
iharding@tpchd.org
WWSD - What Would Scooby Doo?
>>> Savita <savita@india.hp.com> 10/10/02 04:38AM >>>
Yes I understand that the psql is the command is to verify that the server is
started properly.
Once you install postgre as a NT service.WE will get two things in the control
panel.
I am able to start the service now using control panel.
But what I wanted is that insdeed of using psql command in command prompt is
there any other way to connect to postgre.because basically the pupose of making
postgre as a service is to avoid the use of command prompt.
Actually what I mean
"Nigel J. Andrews" wrote:
> On Thu, 10 Oct 2002, Savita wrote:
>
> > Connect to PostgreSQL:
> >
> > # psql -U postgres template1
> >
> > why should we do this Creating the postgre as a service it is not possible
> > to start it from start->sevices->control panel.If so then how the client
> > will give the database name to connect to the postgre.
> >
>
> No idea about the control panel stuff but that last stage you list is nothing
> to do with starting the service. psql connects to the database server it was
> obviously listed in the documentation as a test to confirm the previous
> commands had managed to start the server.
>
> --
> Nigel J. Andrews
--
Best Regards
- Savita
----------------------------------------------------
Hewlett Packard (India)
+91 80 2051288 (Phone)
847 1288 (HP Telnet)
----------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly