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: 20070223195156.GF20242@alvh.no-ip.org (view raw or flat)
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:
> >>
> >> http://port25.technet.com/archive/2007/02/22/postgresql-on-windows-a-primer.aspx
> >>
> >> 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                                http://www.CommandPrompt.com/
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-2014 The PostgreSQL Global Development Group