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

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

--
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 8/18/10 7:42 AM, Vikram Patil wrote:

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.

See --serviceaccount and --servicepassword CLI options to the installer,
you can provide any existing user with its corresponding password as the
postgres service owner.

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

--
Regards,
Sachin Srivastava
EnterpriseDB <http://www.enterprisedb.com&gt;, the Enterprise Postgres
<http://www.enterprisedb.com&gt; company.

-----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_&amp;_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 all windows 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

Hello Sachin,

Thanks for reply. I will check that one out.

Thanks & Regards,
Vikram

________________________________
From: Sachin Srivastava [mailto:sachin.srivastava@enterprisedb.com]
Sent: Tuesday, August 17, 2010 10:48 PM
To: Vikram Patil
Cc: jd@commandprompt.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Windows 2003 server installation issue

On 8/18/10 7:42 AM, Vikram Patil wrote:

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.
See --serviceaccount and --servicepassword CLI options to the installer, you can provide any existing user with its corresponding password as the postgres service owner.

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<mailto: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

--
Regards,
Sachin Srivastava
EnterpriseDB<http://www.enterprisedb.com&gt;, the Enterprise Postgres<http://www.enterprisedb.com&gt; company.