One PostgreSQL + two HM1 over network

[agk27]

I need configure setup, where two HM1 will import data to one PostgreSQL over network connection (home network).
I can connect different HM1, but when i trying import from two HM1, one of them makes Errors.

Every HM1 connected to PostgreSQL using different Postgre users(roles), but they had the same access rights.
What i should do?

[Patvs]

Read: http://faq.holdemmanager.com/questions/336/How+do+I+setup+Holdem+Manager+to+share+one+databas e+between+two+computers%3F

[agk27]

Cant see pictures on that link.

But iam checking this
http://faq.holdemmanager.com/questions/90/Run+PostgreSQL+Over+a+Network+

Once more.
Only when i trying import about 100k hands (or more) at the same time, i get import Errors on the of HM1.

[Sarek]

Try to use the same Role.

[agk27]

Try to use the same Role.

the same result(
94321

[Patvs]

Are both accessing the database simultaneously?
What happens if you import from PC1. Close HM1.

Then import from PC2.
Is it always the same machine that gives the errors?

[agk27]

Yes, errors only when simultaneously.

When i stop import from PC1, PC2 will import without errors.

But if two PCs import at the same time, after for example 10 minutes, PCs can change "place" errors/wo errors.

[agk27]

And more, i check ImportErrors.txt in RVG\HM\Import Errors\ folder

to many strings like this
C:\Users\agkwin7\Documents\testVM2\testVM2\HHmaile r_com_PS_NL50_USD_SH_2012_11_22_TOAV-034.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

[Sarek]

this error message usually means corrupt database

[agk27]

any other reason, cause always this is new DB?

[udbrky]

Move your DM hands folders out of the auto import list. Import them manually.

[Patvs]

The 'shared' database doesn't support an import from two computers simultaneously.
If you create a new database, and only import from one computer at a time, it should work.

[agk27]

Patvs,
the same for HM2?

[Patvs]

With HM2:
-it also doesn't support a simultaneous import from two computers.
-setting up a shared database is more difficult since you also need to share the parent folder:

C:\Users\{username}\AppData\Roaming\HoldemManager\ Database

To change the location of the parent folder read the last part of: http://hm2faq.holdemmanager.com/questions/1172/Move+Database+to+Another+Hard+Drive+or+Partition

-The alternative is to use HMSync to synchronize the two databases.