pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to start postresql db server as a administrator on windows platform?
2+ messages / 2 participants
[nested] [flat]
* How to start postresql db server as a administrator on windows platform?
@ 2005-11-02 05:31 Rich <rich@piolink.com>
0 siblings, 0 replies; 2+ messages in thread
From: Rich @ 2005-11-02 05:31 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to start postresql db server as a administrator on windows platform?
@ 2005-11-03 20:31 Jason Minion <jason.minion@sigler.com>
0 siblings, 0 replies; 2+ messages in thread
From: Jason Minion @ 2005-11-03 20:31 UTC (permalink / raw)
To: Rich <rich@piolink.com>; 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 and that stored information. With the database user being an unprivileged process, you would be protected in case the database process 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2005-11-03 20:31 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-11-02 05:31 How to start postresql db server as a administrator on windows platform? Rich <rich@piolink.com>
2005-11-03 20:31 Re: How to start postresql db server as a administrator on windows platform? Jason Minion <jason.minion@sigler.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox