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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-advocacy pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Walter Cruz | 2007-02-25 01:03:30 | Jav Database Performance |
Previous Message | Joshua D. Drake | 2007-02-23 19:00:32 | Re: [GENERAL] PostgreSQL on Windows Paper |
From | Date | Subject | |
---|---|---|---|
Next Message | Tino Wildenhain | 2007-02-23 20:04:06 | Re: postgresql vs mysql |
Previous Message | Mike | 2007-02-23 19:50:51 | SQL Question - Using Group By |