Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] PostgreSQL on Windows Paper

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
Cc: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>, Chris Travers <chris(at)verkiel(dot)metatrontech(dot)com>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>, pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] PostgreSQL on Windows Paper
Date: 2007-02-23 19:51:56
Message-ID: (view raw or whole thread)
Lists: pgsql-advocacypgsql-general
Joshua D. Drake wrote:
> Scott Marlowe wrote:
> > On Fri, 2007-02-23 at 12:22, Chris Travers wrote:
> >> Hi all;
> >>
> >> Microsoft has seen it fit to publish a paper I have written as an 
> >> introduction to PostgreSQL on Windows.  This paper covers the basics of 
> >> installing and configuring the software.  I thought it might be of 
> >> interest here so here is the link:
> >>
> >>
> >>
> >> If there are any editorial concerns they can be directed to me.  It is 
> >> my hope that this will help introduce our favorite RDBMS to a wider 
> >> audience.
> > 
> > One point, the paper mentions that you can't run pgsql under an admin
> > account, but I thought that changed with 8.2.  Or is that with Vista or
> > something?
> You can start postgresql under and admin account, but is uses drop
> privelages or something like that to insure that it doesn't *run* under
> an admin account.

It drops privileges, which is something very much like dropping the root
UID in a setuid root Unix program.  So in practice you can run Postgres
under the admin account, but without the admin privileges.

Alvaro Herrera                      
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

pgsql-advocacy by date

Next:From: Walter CruzDate: 2007-02-25 01:03:30
Subject: Jav Database Performance
Previous:From: Joshua D. DrakeDate: 2007-02-23 19:00:32
Subject: Re: [GENERAL] PostgreSQL on Windows Paper

pgsql-general by date

Next:From: Tino WildenhainDate: 2007-02-23 20:04:06
Subject: Re: postgresql vs mysql
Previous:From: MikeDate: 2007-02-23 19:50:51
Subject: SQL Question - Using Group By

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group