Обсуждение: Windows 2003 server installation issue

On Sat, Aug 14, 2010 at 12:49 AM, Vikram Patil <vpatil@actuate.com> wrote:
> Hello Folks,
>
>
>
>    I am facing an issue starting postgresql using windows service when my
> user belongs to Administrator group.
>
>
>
>    I applied patch from following thread to 8.4.1 source code and it seems
> to be working with every windows operating system except Windows 2003 .

Is this patch not included in 8.4.4?  If so it would be much easier to
just upgrade.

On Fri, 2010-08-13 at 23:49 -0700, Vikram Patil wrote:
> Hello Folks,
>
>
>
>    I am facing an issue starting postgresql using windows service when
> my user belongs to Administrator group.
>
>
>
>    I applied patch from following thread to 8.4.1 source code and it
> seems to be working with every windows operating system except Windows
> 2003 .
>
There is a reason the community provides binary packages. The idea that
you are patching 8.4.1 is quite ridiculous. Upgrade to 8.4.4.


Sincerely,

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

On Fri, 2010-08-13 at 23:49 -0700, Vikram Patil wrote:
> Hello Folks,
>
>
>
>    I am facing an issue starting postgresql using windows service when
> my user belongs to Administrator group.
>
>
>
>    I applied patch from following thread to 8.4.1 source code and it
> seems to be working with every windows operating system except Windows
> 2003 .
>
There is a reason the community provides binary packages. The idea that
you are patching 8.4.1 is quite ridiculous. Upgrade to 8.4.4.


Sincerely,

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

Joshua,

     Thanks for reply. But I tried 8.4.4 and it still doesn't work with local administrator account on windows 2003 . I
don'twant to create additional "postgres" user to start service on windows rather I want to use my currently logged in
user.User can be administrator or non-administrator.  

I am getting an "error code 5" in event viewer when I try to use administrator as service user.Before attempting that I
usedinitdb to create  
Data directory with same user

Thanks & Regards,
Vikram



-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com]
Sent: Saturday, August 14, 2010 9:32 AM
To: Vikram Patil
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Windows 2003 server installation issue

On Fri, 2010-08-13 at 23:49 -0700, Vikram Patil wrote:
> Hello Folks,
>
>
>
>    I am facing an issue starting postgresql using windows service when
> my user belongs to Administrator group.
>
>
>
>    I applied patch from following thread to 8.4.1 source code and it
> seems to be working with every windows operating system except Windows
> 2003 .
>
There is a reason the community provides binary packages. The idea that
you are patching 8.4.1 is quite ridiculous. Upgrade to 8.4.4.


Sincerely,

Joshua D. Drake


--
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579
Consulting, Training, Support, Custom Development, Engineering
http://twitter.com/cmdpromptinc | http://identi.ca/commandprompt

Joshua,
    Thanks for reply. But I tried 8.4.4 and it still doesn't work with local administrator account on windows 2003 . I don't want to create additional "postgres" user to start service on windows rather I want to use my currently logged in user. User can be administrator or non-administrator.

 

I am getting an "error code 5" in event viewer when I try to use administrator as service user.Before attempting that I used initdb to create 
Data directory with same user

Thanks & Regards,
Vikram        


-----Original Message-----
From: Joshua D. Drake [mailto:jd@commandprompt.com] 
Sent: Saturday, August 14, 2010 9:32 AM
To: Vikram Patil
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Windows 2003 server installation issue

On Fri, 2010-08-13 at 23:49 -0700, Vikram Patil wrote: 

Hello Folks,

  I am facing an issue starting postgresql using windows service when
my user belongs to Administrator group.

  I applied patch from following thread to 8.4.1 source code and it
seems to be working with every windows operating system except Windows
2003 .
   

There is a reason the community provides binary packages. The idea that
you are patching 8.4.1 is quite ridiculous. Upgrade to 8.4.4.


Sincerely,

Joshua D. Drake

 

> -----Original Message-----
> From: Vikram Patil [mailto:vpatil@actuate.com]
> Sent: Tuesday, August 17, 2010 10:13 PM
> To: jd@commandprompt.com
> Cc: pgsql-general@postgresql.org
> Subject: Re: Windows 2003 server installation issue
>
> Joshua,
>
>      Thanks for reply. But I tried 8.4.4 and it still doesn't
> work with local administrator account on windows 2003 . I
> don't want to create additional "postgres" user to start
> service on windows rather I want to use my currently logged
> in user. User can be administrator or non-administrator.
>
> I am getting an "error code 5" in event viewer when I try to
> use administrator as service user.Before attempting that I
> used initdb to create Data directory with same user
>
> Thanks & Regards,
> Vikram
>
>

Can't do.
PG documantation clearly states, that Windows account used to run
Postgres service SHOULD NOT be a member of Administrators group.

Regards,
Igor Neyman

Hi Igor,


http://wiki.postgresql.org/wiki/Running_&_Installing_PostgreSQL_On_Native_Windows#Why_do_I_need_a_non-administrator_account_to_run_PostgreSQL_under.3F

This says that it will give up administrative rights when we try to install as administrator account. And it succeeds
allwindows platform except Windows 2003. 

Thanks & Regards,
Vikram

-----Original Message-----
From: Igor Neyman [mailto:ineyman@perceptron.com]
Sent: Wednesday, August 18, 2010 6:35 AM
To: Vikram Patil; jd@commandprompt.com
Cc: pgsql-general@postgresql.org
Subject: RE: Windows 2003 server installation issue



> -----Original Message-----
> From: Vikram Patil [mailto:vpatil@actuate.com]
> Sent: Tuesday, August 17, 2010 10:13 PM
> To: jd@commandprompt.com
> Cc: pgsql-general@postgresql.org
> Subject: Re: Windows 2003 server installation issue
>
> Joshua,
>
>      Thanks for reply. But I tried 8.4.4 and it still doesn't
> work with local administrator account on windows 2003 . I
> don't want to create additional "postgres" user to start
> service on windows rather I want to use my currently logged
> in user. User can be administrator or non-administrator.
>
> I am getting an "error code 5" in event viewer when I try to
> use administrator as service user.Before attempting that I
> used initdb to create Data directory with same user
>
> Thanks & Regards,
> Vikram
>
>

Can't do.
PG documantation clearly states, that Windows account used to run
Postgres service SHOULD NOT be a member of Administrators group.

Regards,
Igor Neyman