Re: PGS Tuning Wizard destroys my login

Jennifer,

obviously you are on windows. And the problem you are describing seems to
be:

"after running the tuning wizzard, the PostgreSQL Service does not start any
more"

AT the same time you are describing some problem of

"you are not able to delete some Files / Directories connected with
PostgreSQL-Databases, and you are not able to change ownership / take
ownership of those files."

THAT gives reason to the assumption that you are using something Vistaish or
Windows-7ish.

AND that the right structure of your file system around PostgreSQLs Files is
rather screwed; not clear, by what or who.

SO, to help you to get to some solution:

1.) you should state the exact version of your operating system
2.) you should state the exact PostgreSQL Version
3.) exactly describe your Windows Authorization. Is there some Domain /
ActiveDirectory going on? Do you really have MasterChiefAdministrator
rights?

and to continue your diagnostics:

4.) Check the application event log of windows. "eventvwr" from the Command
line, or dig through the Administration Panels
5.) Check for the logfiles of PostgreSQL within the pg_log directory.

Most likely reason is that postgres.exe is not allowed to open some file or
port; to write to a log file or read it's databases or even read its
configuration file postgresql.conf

So, next of this: check the file-ownerships and rights of your PostgreSQL
Data directory. Especially, is the user owning the postgresql service
allowed to read an change all the files within the PostgreSQL Data
directory? Especially the postgresql.conf?

Best luck,

Harald

On Wed, Apr 8, 2009 at 1:50 PM, Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com>wrote:

> Hehe, I am not saying that you are untruthful, but obviously there is more
> to this issue than just the .conf file.
>
> Because when returning to the old conf the problem is still there and I am
> also certain that this problem was not there before I just installed the
> tuning wizard.
>
> Would you at least agree that there is something fishy going on, and that
> its related to the tuning wizard? Things seldom work as expected
>
>
> I just un-installed the tuning-wizard (I still have the generated config
> file, so I dont have to repeat this step once more), restarted, the problem
> is still there. The problem does not seem to be login related. But more to
> that the server doesn't start up.
>
> Running the program, 'Start Server', it just sits there and does nothing.
> After long time it says:
>
> The service did not report an error.
>
> More help is available by typing NET HELPMSG 3534
>
> Not sure what is going on. Server refuses to start it seems. Please help me
> debug this problem :)
>
> Sincerely / Jen
>
> On Wed, Apr 8, 2009 at 2:31 PM, Dave Page <dpage(at)pgadmin(dot)org> wrote:
>>
>> On Wed, Apr 8, 2009 at 12:16 PM, Jennifer Trey <jennifer(dot)trey(at)gmail(dot)com>
>> wrote: > Look, I am telling now what I did. > > I don't want to hear
>> claims about how its not the tuning wizards fault. It > is! > > And it
>> does more than the postgresql.conf because thats not true.
>> I'm sorry to hear you think I'm being untruthful. The source code for the
>> tuning wizard is at
>> http://www.enterprisedb.com/openDownloads.do?productId=417&redirectReason=true&productVersion=otherDownload- you can see exactly what it modifies there. --Dave PageEnterpriseDB UK:
>> http://www.enterprisedb.com
>>
>
>

--
GHUM Harald Massa
persuadere et programmare
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607
no fx, no carrier pigeon
-
LASIK good, steroids bad?