Re: PGS Tuning Wizard destroys my login

Jennifer,

1.) you should state the exact version of your operating system

Windows Web Server 2008 x64

2.) you should state the exact PostgreSQL Version

The latest available, installed this : postgresql-8.3.7-1-windows.exe

 

3.) exactly describe your Windows Authorization. Is there some Domain / ActiveDirectory going on? Do you really have MasterChiefAdministrator rights?

As far as I know, I have one user and that is the Administrator. Not sure if that is the commander in chief but obviously not, because he is screwing with me allot. 

You have digged down to the root of the problem:

FATAL: could not open configuration file "E:/PostgreSQLDATA/postgresql.conf": Permission denied

so to sum it up: you ran the Tuning Wizard, which gave you a new postgresql.conf. Tuning wizard, running as your user, copied this postgresql.conf OR you put back your back-upped postgresql.conf, also as "Administrator"

The permissions of that directory seem to be very screwed :)

5.) Check for the logfiles of PostgreSQL within the pg_log directory.

I cannot enter that folder! Crazy! I command you to let me in!

No, I try to change the settings and permissions (there is like tousand entries to those things), i give full access but no difference! I don't get it! Make me the super chief damn it!

A quick google for NTFS permissions points to a lot of second source manuals; that is a hint that it is complicated enough for people to make money to write books about it. As I am always working WITH the system adminstrators when implementing PostgreSQL on Win32, I have no MCP or MSC or whatever that title for knowing about Windows-Permissions is.

So my hints to solve your problem:

a) check if there is some higher authority - as "this computer is member of a domain / Active Directory", and rights for those file systems are managed elsewhere out of your control

b) read up on Windows NTFS File Permissions on Server 2008. Do you have to use another account? Do you have to elevate privileges in any way?

c) after learning enough about windows File Permissions, make sure that the user "Postgres" -> PostgreSQL Service Account has the appropriate permissions to access all the files within the PostgreSQL Data directory.

You seem to be on something here. Keep going! :)

Now it's you and windows. Good 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?