PDA

View Full Version : PSQL issue : failed to establish con....



sal
08-14-2011, 06:30 AM
i usually just stop/start service and it works fine(been doing it for a year or so) but now those 2 are taking forever saying ''starting/stoping .....................'' and it doesn't get to the end. i've re-started my pc, installed update, looked for that file to delete but i can't even find the data folder, it doesn't seem to exist. please help, what do i do now?

Patvs
08-14-2011, 09:59 AM
This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely

sal
09-01-2011, 07:51 AM
how do i do that? i saw several posts about it but not sure which is right for me... will i lose my db?

Patvs
09-01-2011, 09:18 AM
Run the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
If you're lucky, it will detect the old database update/fix the installation.

Otherwise install 8.2: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip) to port 5433 and reimport your hands into a new database

sal
09-01-2011, 10:24 AM
since my v is 8.3 should i install or update that or the latest v ?

Sarek
09-01-2011, 12:05 PM
if it was 8.3 - install 8.3
because 8.4 will not recognize you database. Also 9

sal
09-01-2011, 01:30 PM
i'm sorry but i can't find the 8.3 on that site, i'm terrible with software. can you give me a direct safe link for dl 8.3?

Patvs
09-01-2011, 06:57 PM
PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.3.15/win32/postgresql-8.3.15-1.zip) (=8.3)


Use 8.2 if 8.3 still wont work: PostgreSQL: Choose a Mirror (http://wwwmaster.postgresql.org/download/mirrors-ftp/binary/v8.2.21/win32/postgresql-8.2.21-1.zip)

sal
09-02-2011, 01:34 PM
thanks! does it have to be http or ftp?

Patvs
09-02-2011, 01:45 PM
It doesn't matter. Picking a server from the country closest to you theoretically should result in the fastest download.

Sarek
09-02-2011, 01:46 PM
no difference

sal
09-09-2011, 07:38 AM
i uninstalled the old 8.3 and trying to install the new one but can't find the old pages you had before with step by step instructions for sql.

fozzy71
09-09-2011, 09:55 AM
i uninstalled the old 8.3 and trying to install the new one but can't find the old pages you had before with step by step instructions for sql.

http://faq.holdemmanager.com/questions/70/Reinstall+PostgreSQL

sal
09-12-2011, 10:07 AM
i uninstalled and installed twice and still the same errors come up after the installing is over, like nothing changed form the initial issue. and start/stop doesn't work , they just take forever.......... woth the dots and nothing happens
:(

sal
09-12-2011, 10:14 AM
i uninstalled and installed twice and still the same errors come up after the installing is over, like nothing changed form the initial issue. and start/stop doesn't work , they just take forever.......... woth the dots and nothing happens
:(

it works now so never mind ... for now lol