Page 1 of 1
Sharing DB between dually boot OS's?

Posted:
Fri Aug 14, 2009 12:10 pm
by loc2k
Is this possible? I mean a LAN- and virtualization-free solution, say booting into any number of Windows installations on different partitions and being able to access the same PT3 DB without installing PostgreSQL on each of them, to avoid importing a gazillion hands multiple times.
Re: Sharing DB between dually boot OS's?

Posted:
Fri Aug 14, 2009 12:17 pm
by kraada
You could keep the database in a separate partition but unless you're using a virtualization solution - or another computer to run the database - you're going to need to install PostgreSQL on each machine in order to have something running the database when you're booted in there.
I think that might be a bit confusing so let me elaborate a bit:
Say you have one physical computer C. C has different partitions: C1, C2 and C3. C1 and C2 each have their own operating system and C3 is just a data partition. Assume C1 and C2 are both running Windows, and you reboot when you want to switch.
You can install PT3 in C1 and have PostgreSQL put the data in C3. But when you boot into C2, and install PT3 there, there's still no running instance of PostgreSQL. You can't run the PostgreSQL server from C1's installation because of registry conflicts, you will need to install PostgreSQL on C2. The good news though is that you can reuse the data on C3 so you still only have one database.
The other option is to have one large partition and run a host OS and use virtual machines. Obviously your setup needs may vary but at least I have had good experiences with them and I've heard good things about Virtual Box (which is free).
Re: Sharing DB between dually boot OS's?

Posted:
Fri Aug 14, 2009 12:32 pm
by loc2k
Oops, I worded that kinda wrong. Thanks for the response. How would I go about moving my database to another partition?
Re: Sharing DB between dually boot OS's?

Posted:
Fri Aug 14, 2009 1:15 pm
by kraada