DB Backup from a VM

[PJs Ronin]

system: Linux Host with postgres service... Win XP guest running poker clients, PT3 and with ODBC installed.

I can backup the Optional Files (thank God) but if I try and do a backup of the PT3 db from within PT3 I get:


I can do a backup from within postgres on the Linux host, but would rather have PT3 do it all.

Any suggestions?... anyone?... Bueller?

[kraada]

Do you have PostgreSQL installed in the VM? I know you don't want to use it there, but installing it might provide the necessary files so that everything works properly.

[PJs Ronin]

Do you have PostgreSQL installed in the VM? I know you don't want to use it there, but installing it might provide the necessary files so that everything works properly.

No, just the ODBC files... and I knew you were going to suggest that. That means I should run the postgres service from within the VM?

[kraada]

That's not necessary, just installing the service should be sufficient.

[PJs Ronin]

That's not necessary, just installing the service should be sufficient.

Well, it tried but came up with an error after a while about the host unexpectedly closing the connection... will investigate. May also be because my HD is starting to max out. Will advise.

[kraada]

Keep me posted.

[PJs Ronin]

First error/warning message was about Windows TEMP environment not being big enough for the dump temp file(s). I finally figured out (doh!) that maybe I should clean up my localized system TEMP directory and got rid of some 400 odd files. The PT3 backup process then ran without giving me the warning... however:

Code: Select all

Database:PT3_2010_11_15_120133...pg_dump: Dumping the contents of table "tourney_holdem_cache" failed: PQgetCopyData() failed.
pg_dump: Error message from server: server closed the connection unexpectedly
   This probably means the server terminated abnormally
   before or while processing the request.
pg_dump: The command was: COPY public.tourney_holdem_cache (id_player, id_blinds, cnt_players, position_type, amt_bb_won, amt_blind, amt_won, cnt_bb, cnt_bb_steal_call, cnt_bb_steal_fold, cnt_bb_steal_raise, cnt_blind,..
etc
etc
cnt_wtsd_won_yz, cnt_wtsd_yz, val_antes, val_blinds, val_stack_size) TO stdout;

-------------------
Optional Files
-------------------
File:Data\Config\PokerTracker.cfg
File:Data\Layouts.pt3
File:Data\ReportsCustomized.pt3
File:Data\StatDefinitionsCustomized.pt3
File:Data\Config\Everest.cfg
File:Data\Config\PokerStars.cfg
Remove Temp Files...OK
Remove Temp Folders
Temp Databases Files...Error
Temp Optional Files...OK
Temp Aggregated Files...OK
Error
-------------------
Backup Complete.


Any ideas?

[kraada]

Do you see any errors in the most recent file in your pg_log directory on the host?

Depending on your host distribution the pg_log directory might be somewhere like /var/lib/PostgreSQL/8.3/main/data/pg_log/ (that's where it is in Ubuntu) - but it should be findable with locate if it's not exactly there.

[PJs Ronin]

Do you see any errors in the most recent file in your pg_log directory on the host?

Depending on your host distribution the pg_log directory might be somewhere like /var/lib/PostgreSQL/8.3/main/data/pg_log/ (that's where it is in Ubuntu) - but it should be findable with locate if it's not exactly there.

No, I do not... infact I don't even have that pg_log subdirectory on my host. However, I do have that on the guest. The error from yesterday reads:

2010-12-14 12:45:28 WST LOG: database system was shut down at 2010-12-14 09:39:50 WST
2010-12-14 12:45:28 WST FATAL: the database system is starting up
2010-12-14 12:45:28 WST LOG: database system is ready to accept connections
2010-12-14 12:45:28 WST LOG: autovacuum launcher started
2010-12-14 14:00:55 WST LOG: received fast shutdown request
2010-12-14 14:00:55 WST LOG: aborting any active transactions
2010-12-14 14:00:55 WST LOG: autovacuum launcher shutting down
2010-12-14 14:00:55 WST LOG: shutting down
2010-12-14 14:00:55 WST LOG: database system is shut down

and the one from this morning's failure reads:

2010-12-15 07:36:41 WST FATAL: the database system is starting up
2010-12-15 07:36:41 WST LOG: database system was shut down at 2010-12-14 14:00:55 WST
2010-12-15 07:36:42 WST LOG: database system is ready to accept connections
2010-12-15 07:36:42 WST LOG: autovacuum launcher started

This is getting a little weird.

[kraada]

What sort of firewall/antivirus do you have setup on the guest?