Thread: Re: [GENERAL] PostgreSQL on Windows Paper
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. Joshua D. Drake > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/
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