Postgresql died !!!!!what now ???

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 died !!!!!what now ???

Postby agelis » Thu Oct 21, 2010 5:58 pm

hello as i see i am not alone with this problem.after 7 months without problems,i was using v.3.6 of pokertracker and before 3 days when i was trying to start it PT3 shut down.i tried many times and nothing happened,just coudnt start.then i tried then to install v3.7.5 and surprised i saw it worked again.but after finishing my session and closed PT3,it never started again.i get the message Configure Postgresql everytime i try to start pt3 :evil:
tried to unistall and reinstall postgresql with latest version 8.3.12, 2-3 times,still nothing!!!!THE SERVICE JUST WONT START.i asked remote assistance, i am using this type of help from your site for 2 days now and i get 1 reply every 8-10 hours telling me about firewall and log files(which already sent).Sorry but i start to become frustrated :evil:
the reason i posted here is that maybe an other user finally did something that worked.i have backed up my database through pt3 1 month ago and i also have copied the proccessed folder of PT3.you think is better to create a new database and import my data from the backup file?
PLEASE HELP :oops:
agelis
 
Posts: 13
Joined: Wed Mar 24, 2010 6:00 am

Re: Postgresql died !!!!!what now ???

Postby ihatepostgreSQL » Thu Oct 21, 2010 9:06 pm

haha sucker, jk, i feel your pain, sucker haha.
ihatepostgreSQL
 
Posts: 72
Joined: Thu Oct 21, 2010 11:15 am

Re: Postgresql died !!!!!what now ???

Postby WhiteRider » Fri Oct 22, 2010 3:54 am

Have you tried reinstalling PostgreSQL?
How to reinstall PostgreSQL

Please follow-up in your ticket where we have all the information, if it can't be sorted out by your ticket then we can set a remote session where someone can connect to your computer directly to help you sort this out.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Postgresql died !!!!!what now ???

Postby agelis » Fri Oct 22, 2010 4:29 am

sorry but as i mentioned above i tried to reinstall 3 times.how can we arange this remote session?till now help from tickets where questions about what firewall i use :evil:
agelis
 
Posts: 13
Joined: Wed Mar 24, 2010 6:00 am

Re: Postgresql died !!!!!what now ???

Postby agelis » Fri Oct 22, 2010 4:51 am

i checked the event viewer for errors with postgresql and i found that the error is this:

FATAL: unrecognized configuration parameter "“zero_damaged_pages"

seems that there is a bad configuration command and if changed and reload configuration maybe works.
i checked the postgresql.conf file and at the end i see this:
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------

#custom_variable_classes = '' # list of custom variable class names
“zero_damaged_pages = on”
it seems that if we change value for this command maybe will be fixed
agelis
 
Posts: 13
Joined: Wed Mar 24, 2010 6:00 am

Re: Postgresql died !!!!!what now ???

Postby agelis » Fri Oct 22, 2010 5:18 am

ok i completely removed this command and everything seems to work till now.i am playing a test sng,will close PT3 after and try to start again and see whats going on.
agelis
 
Posts: 13
Joined: Wed Mar 24, 2010 6:00 am

Re: Postgresql died !!!!!what now ???

Postby agelis » Fri Oct 22, 2010 6:31 am

ok everything seems to work normally.but in the event viewer i still get an error every time pokertracker starts,is it important?is something missing?
here it is:
Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 22/10/2010
Time: 1:22:05 μμ
User: N/A
Computer: x
Description:
2010-10-22 13:22:05 EEST FATAL: could not create any TCP/IP sockets
agelis
 
Posts: 13
Joined: Wed Mar 24, 2010 6:00 am

Re: Postgresql died !!!!!what now ???

Postby kraada » Fri Oct 22, 2010 9:08 am

What version of Windows are you running?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgresql died !!!!!what now ???

Postby agelis » Fri Oct 22, 2010 9:07 pm

windows xp pro,why?
agelis
 
Posts: 13
Joined: Wed Mar 24, 2010 6:00 am

Re: Postgresql died !!!!!what now ???

Postby kraada » Sat Oct 23, 2010 9:11 am

Because the fix varies by operating system. You'll want run this program and that should fix things for you.
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 19 guests

cron