--=======5C7F7EF0=======
Content-Type: text/plain; x-avg-checked=avg-ok-6C5A1E3E; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 8bit


Hi

I am a Tutor who teaches SQL and I like to be familiar with all Relational
DBs and their SQL variants.

I run WinXP HE under a single Account name and would like to install and
use PostgreSQL. I have downloaded a version of PostgreSQL from
http://pgfoundry.org/project/showfil...&release_id=48
and at present have installed V7.5.

My problem:-

(1) I don't want to use the "Install as a service" option as I do not want
more than one account on my machine.

(2) So I installed PostgreSQL by unchecking the "Install as a service"
option. The problem now is I can't start PostgreSQL because I get the
following error "execution of PostgreSQL by a user with administrative
permissions is not permitted. The server must ........".

This appears to be a Catch22 situation.

All I want is to install PostgreSQL as a WinXP Service and as a user with
admin privileges be able to stop & start the PostgreSQL service. This is
how I have both Oracle & MySQL installed. These are just WinXP services
which are stopped by default and when I want to use them I just start the
appropriate services and then use an appropriate GUI to run SQL.

Is there some chance you could change your install package so that :-

(1) I can install PostgreSQL as a service without having to create a new
Account Name & Password

OR

(2) by pass install as a service but allow anyone to start the service?

Bert


PO Box 720
Belconnen ACT 2616 Australia
+61+2+ 62541341 (h)
0427 541344 (Bert's Mobile)
0403 050965 (Mary's Mobile)

--=======5C7F7EF0=======
Content-Type: text/plain; charset=us-ascii; x-avg=cert; x-avg-checked=avg-ok-6C5A1E3E
Content-Disposition: inline


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.746 / Virus Database: 498 - Release Date: 31/08/2004

--=======5C7F7EF0=======
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

--=======5C7F7EF0=======--

why not? Its *VERY* standard procedure on all sorts of systems to run
RDBMS servers as a dedicated user.

there are all kinda system accounts already in XP used by various system
services, whats one more? note, these are *NOT* regular user accounts, they
don't typically show up on the "Welcome" login screen. instead of the
stupified Control Panel -> User Accounts, try admin tools -> computer
management -> local users and groups, which is the *real* NT Users panel...



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org