Re: [GENERAL] PostgreSQL on Windows Paper

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