PT v2 Backup Issues

[a_good_year]

I am trying to backup my PTv2 db for the first time since my reinstallation and it is giving me the following message:

"
C:\Program Files\PostgreSQL\8.3\bin>"C:\Program Files\PostgreSQL\8.3\bin\pg_dump
.exe" -i -h localhost -p 5432 -U postgres -F c -v -f "C:\Users\kchua000\Desktop\
Cardrunners\Tracking\Micro_Stakes_db_032108.backup" "MICROSTAKES"
Password:
pg_dump: [archiver (db)] connection to database "MICROSTAKES" failed: FATAL: pa
ssword authentication failed for user "postgres"
pg_dump: *** aborted because of error



Error 1 has occurred ==== BACKUP FAILED TO COMPLETE!!!
Press any key to continue . . ."

I am on Vista w/ SP1.

Please help.

Thanks.

[a_good_year]

Woops, wrong message posted. Here it is:

"
C:\Program Files\PostgreSQL\8.3\bin>"C:\Program Files\PostgreSQL\8.3\bin\pg_dump
.exe" -i -h localhost -p 5432 -U postgres -F c -v -f "C:\Users\kchua000\Desktop\
Cardrunners\Tracking\Micro_Stakes_db_032108.backup" "MICROSTAKES"
pg_dump: [archiver (db)] connection to database "MICROSTAKES" failed: server clo
sed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: *** aborted because of error



Error 1 has occurred ==== BACKUP FAILED TO COMPLETE!!!
Press any key to continue . . ."

I don't recall putting a password for my db.

[a_good_year]

Oh, and I followed the instructions to edit the pg_hba.conf as instructed.

[ptrack pat]

There is a problem with this database if it keeps shutting down the PostgreSQL service like this.

Try using the FULL vacuum/analyze option on the PostgreSQL Database Functions window.

Also, you can try reindexing all of the tables as detailed here:
archives/PT2/viewtopic.php?t=13546&highlight=reindex+pgadmin

[a_good_year]

Doesn't work, but I think this extra info that I neglected to give you might help:
"
After I click on "Backup" and type in a file name for the backup file I want to create, a window pops up asking for the location of the "pg_dump.exe" file. So I locate it at "C:\Program Files\PostgreSQL\8.3\bin". Then the cmd prompt window pops up and asks for my password, but I don't have a password, so I hit enter. Then the following message pops up:

"
C:\Program Files\PostgreSQL\8.3\bin>"C:\Program Files\PostgreSQL\8.3\bin\pg_dump
.exe" -i -h localhost -p 5432 -U postgres -F c -v -f "C:\Users\kchua000\Desktop\
Cardrunners\Tracking\Observed_Hands_db_032108.backup" "MICROSTAKES"
Password:
pg_dump: [archiver (db)] connection to database "MICROSTAKES" failed: fe_sendaut
h: no password supplied
pg_dump: *** aborted because of error



Error 1 has occurred ==== BACKUP FAILED TO COMPLETE!!!
Press any key to continue . . ."

Does this have anything to do with Vista security? Maybe its a new thing with Vista + Service Pack 1?

[ptrack pat]

You have to edit the pg_hba.conf file as administrator if you are using Vista.

From the Start menu select All Programs > PostgreSQL 8.3 > Configuration Files - right-click on "Edit pg_hba.conf" and select "Run as administrator" from the list. Now at the bottom of the file change both places where it says "MD5" to say "trust" and then save the file and try the backup again.

[a_good_year]

Bingo!!! You're the man!