473,320 Members | 2,097 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

3 13051
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
YkeR
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
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

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

Similar topics

5
by: BJ | last post by:
The application I have been developing is great except one flaw. When Windows NT shuts down, it doesn't send the Event to my application (if it did, it would close all of the open forms and kill an...
1
by: Fie Fie Niles | last post by:
I have IIS installed on XP Professional workstation machine. I have an ASP page that open connection to an Access database, then when trying to update the database, it gave me the error "cannot...
2
by: Matt | last post by:
In the following code, page1.asp is inside the frame of main.html. When the user click submit button in page1.asp, it will submit the form and open a new window called page2.asp. When the user...
4
by: Koen | last post by:
Hi all, At work I created a database which is really helpful. The database is used by approx 15 users. Everything worked great, until I added some 'scoreboard' forms and reports. I get the...
5
by: Francis Shanahan | last post by:
Folks, I have a base page which is the grand-daddy of all my pages. It inherits from System.UI.Web.Page From this I inherit a layout page. From this I inherit the individual pages themselves....
0
by: Mr.KisS | last post by:
Hello. I'm under Windows XP PRO SP1, IIS 5.1 ans SQL SERVER 2005 Express. When i try to open a connexion with : <connectionStrings> <add name="AppCnxStr"...
2
by: Mr.KisS | last post by:
Hello. I'm under Windows XP PRO SP1, IIS 5.1 ans SQL SERVER 2005 Express. When i try to open a connexion with : <connectionStrings> <add name="AppCnxStr"...
3
by: Joanne | last post by:
I have searched through previous threads regarding this error. I went back through all my code to make sure I closed and set to nothing all open db's and rs's. However, I still have one computer...
14
by: sarabonn | last post by:
hallo Iam trying to insert a row into a access database using visual c# and iam getting an error " cannot open the action query". here is my code private void button1_Click(object sender,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.