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
