Skip site navigation (1) Skip section navigation (2)

Re: Workaround for bug #4608?

From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
To: "Bruce Momjian" <bruce(at)momjian(dot)us>,"Robert Campbell" <rrc7cz(at)gmail(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Workaround for bug #4608?
Date: 2009-04-22 16:07:32
Message-ID: 53F9CF533E1AA14EA1F8C5C08ABC08D205B0A610@ZDND.DND.boston.cob (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-hackerspgsql-novice
Bruce,
I doubt a normal install would work but perhaps might be worth trying.
As I recall the situation at least in my case
I would explicitly add full permission with a bunch of accounts to the
folder and then when I reran the PostgreSQL install, the installer
insisted on removing most of those permissions including the postgres
account.

So its almost like sometimes the installer shoots itself in the foot by
removing its own access to the folder so that it can't even install. But
why this happens only sometimes I have no clue.

Like I said on all the servers here I tested all exhibit the same odd
behavior, but my windows xp box which is also on the same windows 2003
domain network but uses a local postgres account doesn't run into this
issue.

I've installed on lots of standalone windows servers even windows 2008
without any issue.

Thanks,
Regina

-----Original Message-----
From: Bruce Momjian [mailto:bruce(at)momjian(dot)us] 
Sent: Wednesday, April 22, 2009 11:05 AM
To: Robert Campbell
Cc: Obe, Regina; pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Workaround for bug #4608?

Robert Campbell wrote:
> I found the problem: it's a permissions issue.
> 
> The autogenerated data folder has the following permissions:
> 
> Administrators (MY_COMPUTER_NAME\Administrators)
> postgres (MY_COMPUTER_NAME\postgres)
> 
> Once I added my Novell user MY_COMPUTER_NAME\my_novell_username with
> Full Control I was able to run initdb on it okay.

My guess is that a normal install would work fine now too.

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from disclosure
pursuant to Massachusetts law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and delete the material from any computer.

In response to

Responses

pgsql-novice by date

Next:From: Robert CampbellDate: 2009-04-22 16:50:38
Subject: Re: Workaround for bug #4608?
Previous:From: Robert CampbellDate: 2009-04-22 15:29:40
Subject: Re: Workaround for bug #4608?

pgsql-hackers by date

Next:From: Brendan JurdDate: 2009-04-22 16:19:39
Subject: Re: WIP: to_char, support for EEEE format
Previous:From: Simon RiggsDate: 2009-04-22 15:52:42
Subject: Re: Automating Partitions in PostgreSQL - Query on syntax

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-04-22 16:33:07
Subject: Re: BUG #4774: Bug with use execute+xml+xml_encode_special_chars
Previous:From: Robert CampbellDate: 2009-04-22 15:29:40
Subject: Re: Workaround for bug #4608?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group