Re: PGS Tuning Wizard destroys my login

From: iSTRONG <kaveh_samani(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PGS Tuning Wizard destroys my login
Date: 2009-05-25 21:50:55
Message-ID: 23713659.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I had the same problem as OP.

With Windows 7 x64 & postgresql Version 8.3.7-1

It seems like running tuning wizard changes the permissions of the
postgres.conf file so that the .postgres account is not able to read it.

Similar to OP's situation, postgres was working fine until ran the tuning
wizard at which point the server wouldn't start (after rebooting)

EntrepriseDB should definitly look into this because it's quite difficult
for non-experts like myself to debug.

Error message i get in event viewer:

FATAL: could not open configuration file "C:/Program Files
(x86)/PostgreSQL/8.3/data/postgresql.conf": Permission denied

This problem was solved (after quite a few hours of research, and a few
trials and errors) by changing the owner of the data folder of postgres to
the postgres account.

--
View this message in context: http://www.nabble.com/PGS-Tuning-Wizard-destroys-my-login-tp22947007p23713659.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Browse pgsql-general by date

  From Date Subject
Next Message Eric Smith 2009-05-26 00:27:48 Re: getting a list of users
Previous Message mARK bLOORE 2009-05-25 19:29:54 how to delete many rows from a huge table?