PDA

View Full Version : Problem Setting Up External Hard Drive



vpbob2000
01-30-2009, 06:20 PM
I'm trying to move my database to an external drive to share between my desktop and notebook. I've followed the directions in FAQ #154 and renamed my external drive as my M: drive. When I change the entry via regedit and reboot, when I try to reload HoldemManager I get the following error message:
"The following error occurred when trying to open the database. Failed to establish a connection to '127.1.01'."

Thanks in advance.

morny
01-31-2009, 12:35 PM
Did you try restart the PostgreSQL service, youll need to do this each time you switch

vpbob2000
01-31-2009, 05:46 PM
Yes, every time I made the regedit change I reboot, then try to load Hold'em Manager again and get the error message I described.

morny
02-01-2009, 12:02 PM
If you try and start the postgreSQL service in Control Panel > Admin Tools > Services then it should give an error after this error go to Control Panel > Admin Tools > Event Viewer and look for a PostgreSQL error for the time you got the error and tell me what it says

vpbob2000
02-02-2009, 05:53 PM
Here is the error I get:


Log Name: Application
Source: PostgreSQL
Date: 2/2/2009 1:43:58 PM
Event ID: 0
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: Bob-PC
Description:
2009-02-02 21:43:58 GMT FATAL: could not create lock file "postmaster.pid": Permission denied

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="PostgreSQL" />
<EventID Qualifiers="0">0</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2009-02-02T21:43:58.000Z" />
<EventRecordID>39943</EventRecordID>
<Channel>Application</Channel>
<Computer>Bob-PC</Computer>
<Security />
</System>
<EventData>
<Data>2009-02-02 21:43:58 GMT FATAL: could not create lock file "postmaster.pid": Permission denied
</Data>
</EventData>
</Event>

morny
02-02-2009, 06:10 PM
go to C:\Program Files\PostgreSQL\8.2\data and delete the postmaster.pid file then restart the PostgreSQL service like shown above (If that file dosent exist then thats normal, also dont delete the postmaster.opts file its a different one)

If the problem persists email me and well do a teamviewer session, did you use the same version of PostgreSQL btw as if you dont in can cause connection issues

vpbob2000
02-03-2009, 01:00 PM
I get the same error message after I delete the .pid file.

If I change the drive location from M: back to C: in regedit I have no problem.

Here is my ImagePath file: "C:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D "M:\Program Files\PostgreSQL\8.3\data\"

Here is the path I created on the external drive: M:\Program Files\PostgreSQL\8.3\data

morny
02-03-2009, 02:26 PM
email me morny@holdemmanager.net and ill have a look