By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 1,902 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

pgAdmin, Maintenance - "cannot open the logfile" ?

scubak1w1
P: 53
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...
Nov 17 '09 #1

✓ answered by 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...

Share this Question
Share on Google+
3 Replies


scubak1w1
P: 53
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...
Nov 18 '09 #2

P: 1
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 .
Mar 13 '13 #3

P: 1
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
May 6 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.