Maintaining a database over 2 computers w/datamined hands

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Maintaining a database over 2 computers w/datamined hands

Postby T28333 » Wed Jul 16, 2008 4:45 pm

I've looked over all the info I could find about maintaining a single database over 2 computers. Networking the database is not an option for me.

What I've been doing is just transferring hand histories on a thumb drive, and importing into the database on both computers. This works fine, but I'm starting to want to datamine with auto-import, and I don't end up having histories that I can transfer for those hands.

Exporting and re-importing the entire database is an option, but it's a *very* slow one.

Is there any solution to this? Is it possible to merge two databases? If that were possible, I could have a shared database on the thumb drive (although I might need to get a larger thumb drive for that), and merge back and forth as necessary.

Or is it possible to only export a sub-set of data, preferrably on some sort of command-line interface, so that I wouldn't have to remember to note the date and time every time I export, although it wouldn't be the end of the world if I had to do that?
T28333
 
Posts: 12
Joined: Fri May 23, 2008 5:53 pm

Re: Maintaining a database over 2 computers w/datamined hands

Postby WhiteRider » Wed Jul 16, 2008 4:57 pm

Selective export has not yet been added, though this is planned.

Why do you say you don't end up with hand histories for you observed hands? Is this on FTP where the .tmp files are removed when you close the table? I think that if you stop auto import with the tables still open the files will be moved by PT3 before they are deleted. Not that this is a full solution if you close and open tables, I guess.
WhiteRider
Moderator
 
Posts: 54018
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Maintaining a database over 2 computers w/datamined hands

Postby T28333 » Wed Jul 16, 2008 5:17 pm

Yes, it's on full tilt, and those histories do get deleted when you close the table.

But if selective export is planned, that should be good enough. :)
T28333
 
Posts: 12
Joined: Fri May 23, 2008 5:53 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 32 guests

cron
highfalutin