unable to login to database

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

unable to login to database

Postby gollosb » Tue Sep 23, 2008 4:26 am

somebody please help me with these


[img]https://www.pokertracker.com/support/files/error[39].jpg[/img]
gollosb
 
Posts: 2
Joined: Tue Sep 23, 2008 4:12 am

Re: unable to login to database

Postby WhiteRider » Tue Sep 23, 2008 4:30 am

I assume it's this problem..
This means that postgres isn't running.
Please try starting the postgres service: Start -> Programs -> PostgreSQL -> Start Service.
If that, and a reboot doesn't work, try stopping the service (Start -> Programs -> Postgres -> Stop Service), running a search on your computer for postmaster.pid and then deleting that file, then restarting the service and see if that helps.
Note that you may need to turn on 'View hidden files and folders', and the file seems to be in the folder './Program Files/postgresql//data'.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: unable to login to database

Postby gollosb » Tue Sep 23, 2008 7:05 am

no, already try that but didn't worked.

didn't find postmaster.pid but i found postmaster.opts , delete it and try but nothing happened..

already try to reinstall postgresql but it's the same thing..

heeeeeeelpppppp
gollosb
 
Posts: 2
Joined: Tue Sep 23, 2008 4:12 am

Re: unable to login to database

Postby WhiteRider » Tue Sep 23, 2008 10:37 am

After you try to start the service, Please select the last few files in C:\Program Files\PostgreSQL\8.3\data\pg_log (they're dated so just pick the recent ones), right-click and choose 'Send To Compressed/zipped Folder', then attach the zip file to a ticket on the Support system, and link to this thread in the reference field of the ticket so that we can investigate.

Something must be preventing postgres from starting.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: unable to login to database

Postby Rodolphe2005 » Wed Sep 24, 2008 4:19 am

I had the same problem few minutes ago.

It happens just after I did some change in the config file (increasing some numbers like work_mem and shared_buffer).
I cancel my changes and now it works again so the problem comes from your config file. Add a # at the beginning of each line you changed in the config file, tehn reload and restart and it should work.
Rodolphe2005
 
Posts: 10
Joined: Thu May 22, 2008 4:41 am

Re: unable to login to database

Postby schuttedog » Thu Oct 02, 2008 11:55 am

deleting the postmaster.pid file didn't work for me, so i did the send to zip thing but after i clicked zip... nothing happened. where do i find that zip folder to send to you guys? or can i just send the unzipped version? i was going to send 2 of them and they are only 8k and 25k.
schuttedog
 
Posts: 16
Joined: Tue Mar 18, 2008 1:23 pm

Re: unable to login to database

Postby WhiteRider » Thu Oct 02, 2008 3:26 pm

That's fine - send the unzipped versions, just make sure the filenames aren't too long, and make sure they attach ok when you click the button - they should appear in red below the box.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests