ive just spent an hour and half researching this and trying to figure it out on my own so sorry if the answer is obvious to you....anyways, had to reinstall pt3 and i need a password for the postgres config, and "dbpass" isnt working. I jstu get the error:

unable to connect to database. please check the config.

also, i saw links for disabling the password for postgres, but they seem to have all been moved. Thanks for your help.

Best,

Konrad

http://http://forumserver.twoplustwo...stgres-326729/

the op of this thread was having the exact same problem. unfortunately, he never posted what (if anything) solved the problem. BTW, i installed pt3 on my friends laptop (as im using it to play poker on), and it works fine. the difference is that im never asked for a password on this computer, and postgres was installed via the pt3 installer. I dont know what to do...i downloaded the version with postgres.

just wanted to add that Im not convinced postgres was succesfully installed on my computer. Although it appears in START>PROGRAMS>POSTGRES when I click on the file to edit the password (i.e. mp5>trust), there is no document in this folder. When I do the same thing on my friends laptop, the file contains writing.

I have also tried to manually install postgres with the password p0stgr3s, as suggested by pirjnah's instructions but this too was unsuccesful. Please help me someone, I am so sad without my pt3

I had the same problem when I had to reinstall PT.

You need to uninstall and reinstall postgres. I can't exactly remember how I did it but I'm pretty sure I uninstalled PT and did a reinstall and installed postgres thru that. I also may of downloaded it thru here: http://www.postgresql.org/download/ and installed it via that. But once reinstalled you can use the default password and you should be good to go. Also make sure that you tried 'dbpass' for database user, and svcpass for service user.

anyway, a reinstall is the only way I know of.

An uninstall and reinstall seems like the best idea to me as well.

You can find a tutorial on how to do this available here.

This is the one thing I have not yet tried. In a pathetic state of desperation, I have probably installed and reinstalled at least 5 times. I cant wait to get home and see if svcpass thing works. Thanks for your help guys..Ill be sure to notify you once it get it working again

Good luck.

Thank you very much KINGME620 and Kraada.......it works!!!

It turns out that I had to put in "svcpass" (not dbpass) for the postgres congfigruation password. At this point, PT3 and postgres are installed on my pc. You guys have helped me de-stress alot. The next step is to restore my old database.

Now, I copied the "processed hands" folder and the "layouts.pt3", so I definitely have all my hands from the past few months. However, I did not export the databse into another folder. Instead, I backed up PT via the postgress backup option. How can I restore it? For some reason, when I select "import from directory," the backup.pt3 file does not show up on my list of folders (even though it is right there on my desktop. Furthermore, when I click on the icon from my desktop (after having installed pt3 and imported my processed hands), it merely opens up my current PT3 database, i.e., all my manually entered stars tourneys are not there.

It would not be a tragedy if I lost this info as it is all available on officialpokerrankings.com. The most important thing is my stats on some 100k players which are presumably still there.

Best,

Konrad

If you used the PGadminIII method of backing up, if you go into PGadmin there's a restore option right next to the backup option you used.

kraada,

is it normal that my back up file ends with .backup? what exactly must i type in the prompt to restore a file called pt3 db.backup, which is located in the C drive? i've tried so many combinations and they dont work. also, after restoring the db, i cant find it when i go to make a new db with the "this db already exist" tab clicked. what was the default name again..."my first pt3 db" ?

You can call it whatever you'd like; the file extension really doesn't matter in this case.

You can check to make sure the database loaded (and find out its name) by clicking Start --> Programs --> PostgreSQL --> psql to postgres (it might be psql to template1, that'd be fine to). At the prompt that appears type \l and hit enter and it will list all databases that exist in PostgreSQL.

hi,

ive followed the direction for restoring the db with the command prompt but i always get the error: "[archiver] could not open input file ....no such file or directory exists."

as for restoring the other way (pqs admin iii)...i put the restored file on a cd before i switched pcs, and later on my desktop, but i still cant restore it for some reason. i click on the DB >Restore>(i ch oose the file) and nothing happens. at the end it reads: "process returned exit code 1."

again, i have my processed hands so it would not be a disaster if i cant restore it...it would be nice though. ty for your help.

I prefer the command prompt personally; I find it tends to work better for me.

That error on the command prompt sounds like you're not putting in the correct filename for the file you're trying to open; if you have any spaces in the filename you need to put the filename in quotes otherwise PostgreSQL will look for two files, split by a space.

sorry to prolong this but im really incompetent with this stuff..its pathetic. anyways, i think i must be making a mistake in the command. i have tried to follow instructions as carefully as possible, and also tried different combinations.

first, i reinstalled pt3 on my new pc and imported my Processed Hands into the new database. its name (as indicated in the psl to postgres prompt) is the default: PT3 DB


i have moved the backup file to the appropriate postgres folder (bin etc.). the name of the file is "pt3 db.backup." I go to the postgress command prompt and run the following command:

pg_restore -U postgres -d yournewdb databasename.tar

i replace "databasename.tar" with "pt3 db.backup" (in quotes) and replace "yournewdb" with "PT3 DB," then click enter. My final command thus reads as follows:

c:etc>pg_restore -U postgres -d "PT3 DB" "pt3 db.backup"


What followed looked good at first (becuz it seemed to be loading something) but i soon noticed it was filled with errors. There were way too many to list but they were errors like the following: add constraint; [archiver[ <db> could not execute query ; error from toc entry; the last line was: Warning: Errors ignored on restore: 122.

Am i doing the command wrong? I also tried it without replacing yournewdb, but that didnt work either. Maybe there is something i have to do after that i have not done. after running the command, should my old db simply be there after opening pt3?

As always, thanks for your help. Happy Holidays .

yournewdb should be a different database name, one you just created.

Issue this command first:

CREATE DATABASE pt3new;

Then try restoring to pt3new and that should work.

so i just type this into the command prompt and hit enter?

CREATE DATABASE pt3new

well, that didnt work so i created a new db from the db management and set it as my default. it is called pt3new.

when i type the following command:

pg_restore -U postgres -d pt3new "pt3 db.backup"

i get the following error:

pg_restore: [archiver <db>] connection to database pt3new failed: FATAL: database "pt3new" does not exist.

You need that semicolon at the end of the line, but creating it from the database management window should do it also.

I'm not really sure what's going wrong here (that error clearly says the database doesn't exist, but I believe you when you say you created it so I'm not sure what's causing the discrepancy.

The easiest thing at this point is likely for you to create a support request via this link and explain the situation, and the head of our support division will schedule a time with you for him to log into your computer and fix it directly.

hey kraada,

i doubt this will help you determine why i cant restore my db, but i thought id tell u anyways. i wanted to see if i could create a new DB using the prompt (I had not put in the semi-colon the first time), but even with the semi colon, i get this error:

'CREATE' is not recognized as an internal or external command, operable program or batch file.

PLease tell me that Im ******ed,i.e., still making a mistake, or whether there is something wring with my pt3. It just seems weird to me that i cant accomplish anything using the command prompt, despite the directions being so simple, and despite me apparently following every step.

Best,

Konrad

PS: I made request for the pt3 support to log on to my pc. ty

Konrad,

Were you clicking "Command Prompt" not "psql to postgres" (or template1) from the start menu? It sounds like you don't have a PostgreSQL command prompt; that error is a DOS command prompt error.

Silly me, that error is from a dos command prompt, not the psql to postgress prompt. it was around 4am here when i did that. fwiw, this morning, when i type that command in the psql to postgress, it says "CREATE DATABASE" after i hit enter.

That means the command completed successfully and you can continue.

Kraada,

the db was restored succesfully...what a relief

I now have some errors listed in red where the tourneys should be : Unable to execute query Select (tourney_holdem).

I remember having a similar problem...the solution was easy but cant remmeber exactly what it was.

Thanks Again!

Just playin the sunday majors here and my hud isnt functioning. Hands are importing, the hud is on, the review last hand feature works, but the stats arent there.

Try restarting PT3 and see if that helps.