Re: How to start postresql db server as a administrator on windows platform? - Mailing list pgsql-admin

From Jason Minion
Subject Re: How to start postresql db server as a administrator on windows platform?
Date
Msg-id 0105A1BF505D304E9E5AF38B63E40E4E69D523@EXCHANGE.siglercompanies.com
Whole thread Raw
In response to How to start postresql db server as a administrator on windows platform?  ("Rich" <rich@piolink.com>)
List pgsql-admin
You really need to run PostgreSQL as an unprivileged user.

The database server needs to serve as the *only* interface between processes accessing information stored by the server
andthat stored information. With the database user being an unprivileged process, you would be protected in case the
databaseprocess attempted to execute a process it shouldn't, or overwrite files it shouldn't, which protects your host
system.PostgreSQL should *not* be doing anything that requires permissions outside the scope of reading and writing its
files,and as few users as possible (ie only administrators) should have access to read or write such files. 

This is a fundamental security design common to many platforms and applications. Please see:

http://en.wikipedia.org/wiki/Principle_of_least_privilege


and to answer your actual question...

If you want to simply execute PostgreSQL at a command prompt check:

> pg_ctl.exe --help

You'll want to use the runas command to run the pg_ctl.exe under another (unprivileged!) user account:

http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/runas.mspx

Jason Minion
IT Developer
Sigler Printing & Publishing
413 Northwestern Ave
Ames, IA 50010
515-232-6997
jason.minion@sigler.com


-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Rich
Sent: Tuesday, November 01, 2005 11:32 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] How to start postresql db server as a administrator on windows platform?


Hi there..

First, I'm a begginer to PostgreSQL.
please, Don't fool me too much. ;-)

As you see the title of this post,
I'd like to know how to start postresql db server as a administrator of
MS-windows os. (I'm trying not to run as a service.)
Yes, I already know that according to the document, I have to be a unpriviliged user to run postresql db
server on it.
But, I have to run it as a administrator user.

Isn't there any way to do that?
If so, I can't help change DB system to a different kind of DBMS.

Please, let me know how.

Thank you very much in advance.

Best Regards.

pgsql-admin by date:

Previous
From: John Barham
Date:
Subject: Deleting old files from pgsql_tmp
Next
From: Bruce Momjian
Date:
Subject: Re: Deleting old files from pgsql_tmp