Re: PGS Tuning Wizard destroys my login - Mailing list pgsql-general

From Massa, Harald Armin
Subject Re: PGS Tuning Wizard destroys my login
Date
Msg-id e3e180dc0904080517o665c069bw461ee73b32162408@mail.gmail.com
Whole thread Raw
In response to Re: PGS Tuning Wizard destroys my login  (Jennifer Trey <jennifer.trey@gmail.com>)
List pgsql-general
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.trey@gmail.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@pgadmin.org> wrote:
 
On Wed, Apr 8, 2009 at 12:16 PM, Jennifer Trey <jennifer.trey@gmail.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
 



--
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?

pgsql-general by date:

Previous
From: Kevin Kempter
Date:
Subject: Re: PGS Tuning Wizard destroys my login
Next
From: Jennifer Trey
Date:
Subject: Re: PGS Tuning Wizard destroys my login