PostgreSQL problem

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

PostgreSQL problem

Postby johnyphx » Tue Feb 25, 2014 9:56 am

Yesterday while I was grinding a message appeared from AVG(an antivirus programm i have) that postgreSQL file might be dangerous or broken dk exactly and then PT4 crushed and I closed it. When I tried to open it again that message appeared https://imagizer.imageshack.us/v2/800x600q90/36/j0h6.jpg

I choose "Configure Defaults" and then this comes https://imagizer.imageshack.us/v2/800x600q90/835/cuul.jpg

With choosing Connect this comes https://imagizer.imageshack.us/v2/800x600q90/809/b9aw.jpg

By choosing cancel this comes https://imagizer.imageshack.us/v2/800x600q90/27/y3my.jpg

After trying to access to PT4 this comes up https://imagizer.imageshack.us/v2/1001x750q90/534/dlst.jpg

Please someone guide me to fix this thing, cause Im in a middle of a challenge and got to grind everyday.
Thank you very much.
PS: that was the only postgreSQL thread I found , Im using PT4 not PT3
johnyphx
 
Posts: 6
Joined: Fri Jan 13, 2012 3:13 pm

Re: PostgreSQL problem

Postby kraada » Tue Feb 25, 2014 10:35 am

Click Start type services.msc and click on it when it appears. Do you see PostgreSQL in the list? If so, can you start it?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problem

Postby johnyphx » Tue Feb 25, 2014 12:48 pm

I tried to start it and it was loading https://imagizer.imageshack.us/v2/998x561q90/827/n7y5.jpg
After trying to load it that message appeared https://imagizer.imageshack.us/v2/998x748q90/513/k1ai.jpg
Means sth like Windows were unable to start postgreSQL at your PC
Error 1053
Does that helps kraada?? ty
johnyphx
 
Posts: 6
Joined: Fri Jan 13, 2012 3:13 pm

Re: PostgreSQL problem

Postby johnyphx » Tue Feb 25, 2014 1:03 pm

I saw a very similar problem in the forum and there are plenty of errors like this and most of them at the same time https://imagizer.imageshack.us/v2/998x561q90/691/rz3p.jpg
https://imagizer.imageshack.us/v2/998x561q90/849/93kw.jpg
johnyphx
 
Posts: 6
Joined: Fri Jan 13, 2012 3:13 pm

Re: PostgreSQL problem

Postby kraada » Tue Feb 25, 2014 3:26 pm

Expand the Windows Logs section in Event viewer and click on Applications. The errors in there should be slightly different -- can you show me what it says there?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problem

Postby johnyphx » Tue Feb 25, 2014 4:03 pm

johnyphx
 
Posts: 6
Joined: Fri Jan 13, 2012 3:13 pm

Re: PostgreSQL problem

Postby johnyphx » Tue Feb 25, 2014 4:18 pm

Previous was info of errors
and those 2 are info of Warnings cause as u saw I got both on screen :?
https://imagizer.imageshack.us/v2/1010x758q90/33/q67n.jpg
https://imagizer.imageshack.us/v2/1010x758q90/89/tzmr.jpg
johnyphx
 
Posts: 6
Joined: Fri Jan 13, 2012 3:13 pm

Re: PostgreSQL problem

Postby kraada » Tue Feb 25, 2014 4:45 pm

That's not the section I referred to. In the left hand pane you need to expand Windows Logs and click on Application. That section shouldn't list errors thrown because of duplicate key violation.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: PostgreSQL problem

Postby johnyphx » Tue Feb 25, 2014 5:55 pm

johnyphx
 
Posts: 6
Joined: Fri Jan 13, 2012 3:13 pm

Re: PostgreSQL problem

Postby kraada » Tue Feb 25, 2014 6:05 pm

That error is different - it's saying it can't find necessary elements of your database in C:\PostgreSQL\Data folder -- check your anti-virus and recycle bin and if there were any files from the postgres folder you will need to restore them.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 7 guests

cron