el_grande
01-08-2009, 01:56 PM
I'm using a primary desktop and secondary laptop with HEM. I saw the FAQ on sharing a single DB by storing it on an external USB drive, but I don't want to carry that around all the time. So this is how I deal with my DB:
- Desktop and laptop both have a DB with the same name stored locally
- The desktop is my primary machine
- When I play hands on my laptop, I export new hands and import to desktop
- Once a week I backup my desktop DB to an external drive then restore to laptop
This way I have multiple backups of the DB and don't have to carry an external drive around. The only problem with this is that my laptop DB doesn't always have the latest data from the desktop, but that's ok.
I went through that explanation in case someone can suggest a better way?
Here's the problem... When I restore my desktop DB to the laptop, all hands are added instead of overwriting duplicate hands. So my laptop DB is double size - duplicate hands. Do I have to delete or wipe my laptop DB every time I restore? Or is there some setting in postgre admin that tells it to to a full replace when doing a restore.
thanks
- Desktop and laptop both have a DB with the same name stored locally
- The desktop is my primary machine
- When I play hands on my laptop, I export new hands and import to desktop
- Once a week I backup my desktop DB to an external drive then restore to laptop
This way I have multiple backups of the DB and don't have to carry an external drive around. The only problem with this is that my laptop DB doesn't always have the latest data from the desktop, but that's ok.
I went through that explanation in case someone can suggest a better way?
Here's the problem... When I restore my desktop DB to the laptop, all hands are added instead of overwriting duplicate hands. So my laptop DB is double size - duplicate hands. Do I have to delete or wipe my laptop DB every time I restore? Or is there some setting in postgre admin that tells it to to a full replace when doing a restore.
thanks