I have the following problem. My PostreSQL db is stored on C:\Program Files\PostreSQL and the directory is 9 gigabytes and growing. The bad thing about this is that the size of my C:\ drive overall is only 17 gigabytes. Currently I have like 1 megabyte of free space and there simply isn't much besides the PostreSQL database to remove to make free space. I do however have another hard drive, D:\, which is 450 gigabytes total and has plenty of free space.
My question is, how do I transfer the PostreSQL database from C:\ to D:\ ? I'd also like to set it up in a way where any new PostreSQL files go directly to the new folder in D:\ instead of C:\.
My Holdem Manager is installed on D:\ so it seems kinda weird for the huge PostreSQL database to locate itself onto C:\ ... how do I fix this? I have to warn you I suck a lot when it comes to doing things like this so please input instructions as detailed as possible. Thanks a lot!!!