Postgresql separate data partition

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Postgresql separate data partition

Postby outfit » Thu Oct 01, 2015 4:04 pm

In the installation instructions for postgresql the following is stated,
DO NOT change this default directory location, it is a sub-directory of the installation directory that you selected in the previous step.

I would like to install postgresql on my C drive but have the data on a separate partition.
Is that ok to do?
Will poker tracker not work like this?
Why is this stated in you directions?
Will I have to make changes in Poker Tracker if I do this?
I am new to this and have not installed Poker Tracker on this computer.
Thanks
outfit
 
Posts: 8
Joined: Thu Oct 01, 2015 3:52 pm

Re: Postgresql separate data partition

Postby kraada » Thu Oct 01, 2015 4:30 pm

The permissions need to be set in a particular fashion to work. If you'd like your data on a different drive the easiest thing to do is to create a new empty folder on that drive and install PostgreSQL directly to that location.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgresql separate data partition

Postby fizbin » Thu Oct 01, 2015 5:27 pm

There are also a couple of entries in the FAQ:
https://www.pokertracker.com/forums/vie ... 993#p56990
See:
Can I have a PostgreSQL database on a separate drive in the same computer?
How do I move my database to another drive?
fizbin
 
Posts: 87
Joined: Tue Jan 08, 2013 5:25 am

Re: Postgresql separate data partition

Postby outfit » Thu Oct 01, 2015 8:02 pm

kraada wrote:The permissions need to be set in a particular fashion to work. If you'd like your data on a different drive the easiest thing to do is to create a new empty folder on that drive and install PostgreSQL directly to that location.


Is there documentation available for how to set the permissions in this fashion?

Installing the program on the data partition seems sloppy. It would feel like my socks are in the wrong drawer. I share it with my linux installs.
the tablespace documentation is interesting.

I think I need to read more before I do anything.
Thanks

edit: I am going the tablespace way
Thanks again for the help
outfit
 
Posts: 8
Joined: Thu Oct 01, 2015 3:52 pm

Re: Postgresql separate data partition

Postby fizbin » Fri Oct 02, 2015 12:12 am

I think both links in the FAQ give that information, e.g.:
https://www.pokertracker.com/forums/vie ... 641#p56641

Since you mention Linux, consider running postgresql in Linux (which is what I do.) You can then use a link or a mount under Linux to put the postgresql data directory where you want. You can run PT4 under Windows from either a separate machine or a virtual machine. (Running PT4 under Wine is possible but glitchy and not supported.) When you start PT4 and it asks where postgresql is, then instead of "localhost" use the address of your Linux host. (In my experience, this always fails the first time, and always succeeds on restart, and then continues to work, shrug.)
fizbin
 
Posts: 87
Joined: Tue Jan 08, 2013 5:25 am

Re: Postgresql separate data partition

Postby outfit » Fri Oct 02, 2015 5:26 am

I should have read the FAQ before posting.
The more I read up on it I am happy with the ways of doing it.
Thanks again for the responses and links.
outfit
 
Posts: 8
Joined: Thu Oct 01, 2015 3:52 pm

Re: Postgresql separate data partition

Postby outfit » Fri Oct 02, 2015 6:02 am

I still have a bunch of stuff to read but I guess I was wondering why I could not just
specify the D:\\ drive durring the postgresql install, when it asks you to choose the drive for the database.
This does not really matter if I can just play with this stuff after the install.
I guess I will just choose the C:\\ drive and mess with it later.
The setup you are talking about sounds really cool too.

I do not really understand windows very well or postgresql.
Postgresql looks fun to learn.
outfit
 
Posts: 8
Joined: Thu Oct 01, 2015 3:52 pm


Return to PokerTracker 4

Who is online

Users browsing this forum: Amazonbot and 70 guests

cron