Since beta 20 or so, PT3 doesn't start anymore in Wine. To get it running again, I'd like to run PT3 in VMWare but keep postgresql-sever running natively on Linux.

I found the following post below. This seems to be exactly what I want to be doing. Kraada, do you--by any chance--have a link to a page that describes how to set this up?

I'd be happy to walk through it with you. What distro are you running?

Tyvm for the offer, it's much appreciated!

I run openSUSE 11.0 (x86-64). VMWare version is 6.0.5. postgresql version is 8.3.1, and PT3 is installed in a Windows XP (32bit) guest.

Everything is fully set up so I just need to get postgresql on the host to "talk to" PT3 in the guest. Right now PT3 uses the Postgresql that I installed in the guest (along with installing PT3 beta 23).

I think I can prolly figure out myself the changes I need to make with the network setup of VMWare. Just some short pointers on how to modify the postgresql config files on the server side and the settings/additional programs I need in the guest would be great. Thanks again.

Edit the pg_hba.conf to add a line:
host all all 192.168.1.1/24 md5

though if your local subnet isn't 192.168.1.x change it as appropriate (to 192.168.0.x or whatever you have it set to), and if you don't want PT3 to need a password for postgres, change md5 to trust.

Then edit postgresql.conf and change the listen_addresses to '*' and restart the postgres server and that should be all you need to do (other than getting local networking working in postgres; that shouldn't be too hard though

I might be needing some help too. I'll check back after I move this weekend.

Okay, I can tell you I won't be around this weekend as some old friends of mine are coming to visit, but I'll be here Monday for sure and if you need help I'll help you get squared away. (Though one of the other members of the support team will likely be checking in occasionally while I'm gone, so feel free to post and they'll get back to you if I'm not here.)

alright, I got moved! (YAY!!!!) It went very well.
I'm working with Fedora 10 on a very weak system (700+Mhz cpu, 512mb ram, 40gb hdd). If it's possible, I'd like to set this up on this system and test it before I dump my main workstation for a day or two (I'm currently running vixta on 2.4ghz, 3gb ram, 140gb hdd). I have another box, but the motherboard is cooked and I'm waiting a couple more weeks to make sure I can blow $150 on a nice board+cpu. I'm thinking that after I set this up, I could possibly run the DB on that server and play on my workstation. But this I'm not real sure about.
(This kinda feels like I'm putting myself through the gauntlet of databases)

I'm glad to hear your move went well.

The database server is going to be doing quite a bit of work, especially when doing things like importing and housekeeping. You can still give it a try, it may be powerful enough, but I'm not sure that one will cut the mustard.

If you're going to give it a try (as there's no real pain but lost time, so long as you don't test on high limit tables), I'd start by doing things like a big bulk import of hands and see how fast that goes. If you're not getting more than 20 or 30h/sec that's a bad sign. On my old machine (Dual AMD MP 2800+, 2G ram, Debian Etch), I'd get in the 45-60 range depending. My new machine (Intel Core 2 Quad Q6700, 8G ram, Ubuntu 8.10) I get more like 85 or so (and once I get a second hard drive so I can split the pg_log and pg_xlog from the main database it'll go even faster). Next I'd run housekeeping on that database, though the cluster will be faster in the next Beta the time taken for the cache update is worth noting. That's a hugely resource intensive process as it basically calculates all stats in your stats database for all players for all hands and stores the columns needed so the HUD queries are faster. The longer that takes, the worse off you are. (It's hard to give exact numbers here though as obviously it varies based on how many hands are in your database.)

Then I'd probably just try datamining and seeing what happens at 1, 2, 4, and 8 tables once I have the cache built. If things aren't too painful, housekeeping might be a real chore but otherwise things may work.

As I said, that computer sounds particularly underpowered, but I haven't had a confirmed test from any machine that weak to compare to so I can't really tell you from experience. And PostgreSQL does do much better on a linux system than a windows system, so you may be able to get by assuming you're not using that machine for basically anything else.

yeah, all I'm going to use it for (until I get this whole test done) is watching some movies (which I'm not super confident that it can do either LOL). I basically just want to see it run and make sure that it's a smooth process (ie not in wine as you can't do things like resize the window). It runs very well on my vixta system right now (no lag and 20 tables no problem).

edit to above: I didn't realize that vixta was actually a variant in Linux. When I referred to vixta, I was talking about Microsoft Vista.

That system should be able to watch non-HD movies (or DVDs) without too much trouble.

Either way good luck and keep me posted.

Beta 24 does work with Wine properly; I've got it open and running right now.

See this thread for detailed setup instructions.

interesting. glad to see that as an option at least. It plays movies and video just fine. I'm using it to play music at the moment.
But this is on a bit of a hold. Right now, I'm workin with Stars and my ISP on another problem. stars won't connect to the game server. When I hit that utility when it starts, it hits all 7 servers perfectly. I've tried disabling vista's firewall AND forwarding the ports in my router too. so this is on the back burner for the time being.
more later.

Good luck. At least Stars support is good and I'm sure they'll be willing to work with you to get that fixed.