pgAdmin, Maintenance - "cannot open the logfile" ?

[scubak1w1]

Hello,

Did a search here, manuals and Googled, etc generally, so apologies if I did not find the answer to my issue - that is, I try and 'self help' as mush as I can...

I adjusted my postgresql.conf file to set as on 'explain_pretty_print'

Now in pgAdmin (1.10.0) when I right-click a database in the 'usual' way, Maintenance, any of the tasks, its starts OK, but I get a dialogue box up every (seeming) operation that the Maintenance is doing "Fatal Error - Cannot open the logfile - OK", click OK, it moves on - and then again, again, again... as you can imagine, clicking OK >>100 times is "not efficient"... :-)

I stopped the PostgreSQL service in Windows Server 2008, replaced the postgresql.conf file with the pre-change backup I made, restarted the Windows PostgreSQL service - same error

Did a reboot of the server - same error

Help! What is the log file it is referring to? How come it is not able to see it all of a sudden? I am (now) using the default postgresql.conf and so not verbose logs or some such... No permissions were changed in Windows - and no other changes were made in the PostgreSQL settings...

The databases otherwise appear to be working fine (e.g., I have some web pages writing data to them via PHP, all seems good..)

Thanks in advance...

Cheers,
GREG...

[scubak1w1]

OK, I'm a dufus...

This is a reinstall, had the default for pgAdmin logging set to errors only... changed it to errors & notices, BUT the log file did not exist, created a text file and pointed to it in PgAdmin/logging options, viola...

[YkeR]

I had this problem under windows 7 and it turend out W7 somehow makes all folders readonly after pOSTGRES 9.2 installation. Unsetting readonly does not work so i had to create the folder (debug_logging folder under PG_DATA) manually .

[CallMeSpike]

happened to me today;

some days ago I did some folder clean up, and mistakely
moved my documents Under my music.

restored My documents by correcting the location tab
of "My documents" link from Desktop->Documents->MyDocuments.
in Windows Explorer. pgadmin.log is in that folder Under Win7 anyways. C:\users\[accoun]\Documents.

Works just fine now, blood pressure back to normal.
Cheers, Spike