Page 1 of 1

Postgresql separate data partition

PostPosted: Thu Oct 01, 2015 4:04 pm
by outfit
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

Re: Postgresql separate data partition

PostPosted: Thu Oct 01, 2015 4:30 pm
by kraada
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.

Re: Postgresql separate data partition

PostPosted: Thu Oct 01, 2015 5:27 pm
by fizbin
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?

Re: Postgresql separate data partition

PostPosted: Thu Oct 01, 2015 8:02 pm
by outfit
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

Re: Postgresql separate data partition

PostPosted: Fri Oct 02, 2015 12:12 am
by fizbin
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.)

Re: Postgresql separate data partition

PostPosted: Fri Oct 02, 2015 5:26 am
by outfit
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.

Re: Postgresql separate data partition

PostPosted: Fri Oct 02, 2015 6:02 am
by outfit
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.

highfalutin