Splitting one DB into two

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

Splitting one DB into two

Postby cbeauchamp » Sat Nov 07, 2009 5:03 pm

Hi,

Not much of a DBA and from my look around, I could not find this procedure documented.

How do I spit the DB into two? I do not play on Pokerstars anymore but I do not want to lose the data. I would like to move all of the Pokerstars into a separate DB and only enable it if I start playing there again in the future.

Any easy procedures to do this?

Thanks,

Chris
cbeauchamp
 
Posts: 9
Joined: Tue Mar 18, 2008 8:57 pm

Re: Splitting one DB into two

Postby kraada » Sat Nov 07, 2009 6:24 pm

There is no particular procedure for this, and you have a couple of options as to how to proceed.

(1) Export all PokerStars hands, then purge them from the database. If you want them later, reimport them. To accomplish this, see the Tutorial: Selective Export and the Tutorial: Selective Purge.

(2) Use a filter to hide non-pokerstars data. You won't see it in the tracker, and obviously it won't show up in the HUD, but it will still be in the database. See the Tutorial: Filters for more on how to accomplish this.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Splitting one DB into two

Postby cbeauchamp » Sat Nov 07, 2009 8:25 pm

OK, thanks!

Cheers,

Chris
cbeauchamp
 
Posts: 9
Joined: Tue Mar 18, 2008 8:57 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 17 guests

cron