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







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