PDA

View Full Version : The following error occurred



sal
02-16-2013, 12:53 PM
The following error occurred when trying to open the database: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.

tried restarting
tried finding the 8.x folder but it doesn't seem to exist
deleted that pid file but nothing

what do i do now? if i have to re-install it do i lose everything? i tried looking for updates on the sql site but couldn't find any downloadable links.

Patvs
02-17-2013, 03:20 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
Latest 8.4 build is: 8.4.16 Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload)

sal
02-17-2013, 08:36 AM
i am upgrading but it's asking me for a pass for service account. is this a pass i created or a std one? i can't remember :(

udbrky
02-17-2013, 11:42 PM
THis is for postgresql, it sounds like. the standard one is postgrespass

You can change the password in the command prompt.

Open start menu - accessories - command prompt - right click, run as administrator.

Type:

net user postgres postgrespass

This will change it to our standard postgrespass or you can replace that with your own password.

- Please see these steps to fix postgresql connection issues:

http://hm2faq.holdemmanager.com/questions/1001/Can+not+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

- Please make sure that you have allowed postgres and pg_ctl in your firewall and antivirus exceptions. They are in postgres\bin.

- Please update windows fully. Please keep checking until it shows twice five minutes apart that there are no more updates.

- Please update your network adapter. Open device manager and find the model #. Search google for the model # drivers to download.

- Please run the windows repair on your winsock:

How to determine and to recover from Winsock2 corruption in Windows Server 2003, in Windows XP, and in Windows Vista (http://support.microsoft.com/kb/811259)

If you are using Mcafee, Norton, Comodo or AVG for security, they have been causing a lot of issues with postgres lately. We recommend using a different program, such as Microsoft's firewall and Microsoft Security Essential. If you do feel that you need Comodo or AVG, uninstall first, install postgres, then reinstall after it is working.

Download the same version you are running from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) - do not use 9.1. Uninstall yours.

Right click the setup file, click properties. Click the unblock button at the bottom.

Empty the c:\temp and/or c:\Users\Username\AppData\Local\Temp folders.

Install in the same location yours was installed in.

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file.