PDA

View Full Version : Fix for PostgreSQL cannot start error 127.0.0.1



bechorff
05-01-2011, 06:59 AM
Hello

I have tried to do as the sticky said, but how do i overwrite the original file?
Everytime i try, i get "Access denied"

netsrak
05-01-2011, 11:54 AM
copy the file to the desktop. Edit the copied file. Rename the original file and move the copy from the desktop to the original folder.

Did you try all these things before editing any files?

1. Reboot your computer
2. If that doesn't help look for the hidden system file postmaster.pid in the postgresql data folder, delete it and reboot your computer again.
3. Check the postgresql service in the windows services (control panel->administration). Sometimes it helps to change the Logon As.. to "local system account"
4. Check our FAQ:
http://faq.holdemmanager.com/questions/91/Can%27t+Connect+%7B47%7D+Failed+to+Start+PostgreSQ L+

labanivo
05-04-2011, 02:35 PM
Don't want to start yet another one of these threads so I'll hijack this one.

My C: was filling up so I copied the files (20 GB) to D: as in your guide. Changed the permissions etc etc. All as told in

http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition

After all that I get the Failed to establish a connection to ‘127.0.0.1 message.

I have no idea if that has anything to do with the move I made. I changed it to point to C: again but same message.

So now I try to follow your sticky thread about this message

http://forums.holdemmanager.com/manager-general/8182-fix-postgresql-cannot-start-error-127-0-0-1-a.html

Doesn't make a difference. However I notice that this is written a long time ago and me and I imagine many others are now using not only windows 7 but also a x64 system.

Is the system32 directory still where I should make changes? Or is there something different when running x64?

I've noticed this problem in a lot of your manuals and guides. Many are at best referring to Vista (and often not even that) and unless you know what has changed they are often hard to follow.

I realize it's hard and time consuming to try to keep up with all of Microsofts changes but I really think it's time to update at least some of these guides.

So far I've gotten nowhere. Guess a total reinstall would be the easiest but then I have no idea if I would still get the same error afterwards. I made a total export only a month or so ago and can get this last months hands again.

Guess this wasn't so much a question as a rant. Sorry bout that. Would like to know if there are anything different I should try running Windows 7 x64

fozzy71
05-04-2011, 09:34 PM
Most 64 bit programs go to \Program Files (x86)\..., but otherwise everything should be the same.

The easiest thing would probably be to just download the latest 8.4.x build from postgresql and reinstall it completely, but pick your new \data directory during installation. Our combo installer doesnt give this option.

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4.x from this link - Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows)

labanivo
05-05-2011, 12:20 PM
Oh well,

I'm not the patient type so I had already decided on updating to 8.4. Unintalled 8.3. Hadn't figured out I needed to delete user. Ran into password question when installing. Standard password didn't work. Swore a little. Aborted and installed instead from your combo installer. As you said this time I didn't get the chose of where to put my data (why not?, I even installed Postgres on D: so why does it put data on C:?) so I'm stuck at C:.

Everything seems to work though and by only installing the last couple of months I have about 18GB less data so I should be fine for awhile.

Do I risk any potential problems by not doing #2 on your list?

Patvs
05-05-2011, 01:07 PM
The combo installer will always install to the default folder. (and won't give you the option to pick the data folder)
The manual installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org) will.
But you can also change the location of the data folder in the system's registry, read: http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition


If PostgreSQL is running, you don't have to worry about not having performed step #2 (deleting the postgres user) from Fozzy's list.