Holdem manager 2 database full#
When all the users have full control, click Apply and OK. Then for each user in the top pane, select that user. To do this, go the Main folder (PostgreSQL in this case) and right click it. Otherwise a "cant connect to postgreSQL error" can occur. So it is necessary to make sure the user has sufficent priveleges. When moving a folder to a new PC, the old user priveleges may not be transferred. "C:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D "I:\Program Files\PostgreSQL\8.3\data\" If creating the key based on that screenshot the old key would be: Choose properties to view this:įor location it shows the actual path, in this case it is the I: drive but others might be different. The easiest way is to navigate to the actual Data folder on the external hard drive. Make sure to get the path exactly correct. Next, tell PostgreSQL the current location. But, they have been moved to the external hard drive. This is the location that PostgreSQL looks for the database files. "C:\Program Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D "C:\Program Files\PostgreSQL\8.3\data\" Right click and choose modify to view the following: In the image above key that needs to changed is highlighted. Navigate the folders to this path: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\pgsql-8.3 to view the following screen: Go to Start > All Programs > Accessories > Run then type the following in the textbox: regedit and then press enter and a new window should appear like in the screenshot below: Then press enter and a new window should appear like in the screenshot below: Go to Start > Run and type the following in the textbox: regedit Now tell PostgreSQL where the new data folder is located. If this is a big database this may take some time. Copy (or Cut) all the files in here to the new data folder that was just created above on the external hard drive. Then go to where the data folder which will be c:\program files\PostgreSQL\8.3\data by default unless it was changed.
So if the external hard drive is on the I drive the path I:\Program Files\PostgreSQL\data would have been created. Inside that folder create a \ PostgreSQL folder and inside that create a \ data folder. Right click this and choose "Stop" to stop the service.Ĭreate the following folder in the external hard drive: newParent The location should be F:\newParentĬreate the following folder in the external hard drive: Program Files Start > Control Panel > Administrative Tools (Use classic View) > Services *Please note this is an advanced article and we do not provide support for these this method if you encounter issues but at the request of users we decided to make a FAQ for those who felt confident enough to try this methodĬlose down the PostgreSQL service while doing this. It can be done without having to reinstall.
Holdem manager 2 database windows#
If PostgreSQL is installed on the C drive where Windows is installed, but you want to move the Data folder i.e Database to a different partition or external hard drive to reclaim the space on your C drive. How can a PostgreSQL database (Hand Database) be moved to a new Hard Drive or Drive Partition?