Dear community!

My SQL-folder grew quite big,
after playing PLO, Limit and NoLimit 6max i finally arrived @ FR NL and so i want to delete all the other databases.



How do i actually do that?



I dont know this passwort

http://faq.holdemmanager.com/questio...elete+Database


PT3's default name/password is - postgres/dbpass
HM's default name/password is - postgres/postgrespass

If that doesnt help:

1. Go to C:\Program Files\PostgreSQL\8.x\data, move the the pg_hba file to your Desktop and open it with notepad.
2. Scroll to the bottom and change all md5 to trust. Save and close the file
3. Move the file back to the data folder
4. Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

HM will accept any password now.

http://faq.holdemmanager.com/questio...es+(PostgreSQL)



Logging:

I would suggest you turn off logging on your new SQL installation as well as these other performance improvements in my signature - Top 10: HEM performance increase tips


To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.



File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.


- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.



Regarding database maintenance:

You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin.
http://faq.holdemmanager.com/questio...+from+Database
http://faq.holdemmanager.com/questions/197/Purge+Hands

Then you can vacuum/analyze - http://faq.holdemmanager.com/questio...tabase+#manual

Before you defragment you should stop the PostgreSQL service:

Start > Programs > PostgreSQL 8.x > Stop Server

Use your favorite defrag tool. I recommend Smart Defrag.

After defrag I recommend you reboot your PC. If you need to access the DB before rebooting you can start the PostgreSQL service.

Start > Programs > PostgreSQL 8.x > Start Server

Do you have logging turned on? If you don't turn it off you'll get a lot of useless .log files and my folder was pretty big before I found out.

"HM's default name/password is - postgres/postgrespass"

So what should i type in? i dont get that, sorry

And what should i change there? -.-

postgres is the name and postgrespass is the password.

Your file has already been edited so you shouldnt need a password for connecting to the postgresql server in pgadmin.

THe Namer is Malma91, not postgres...
and postgrespass does not work as a password...

You shouldnt need a password if your file looks like what you posted. You need to restart the postgresql service or reboot your computer for those changes in the pg_hba file to take effect.

Problem is that i havent changed anything...

hem > options > database management

it should show you your username AND password

it really sucks...

This is Nickname: dermax and Passwort: einheit,
nothing about Malma91...

You must have made another name/pass when installing it. I have no idea how to help you. I would suggest you just export all your databases to text files as backup then you could reinstall postgresql completely and start from scratch if you are unable to figure out that user/password issue.

damn it.

so i export all the hands from the database, then deinstall postgresql, then reinstall it?
Is the 40GB SQL folder deleted aswell?

The SQL-folder is still @ C:\Programms\SQL

How can i get rid of this huge folder?

Export all your hands, notes, and tourney summaries/results.

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator
[PHP]net user postgres /delete [/PHP]

Now delete your 40gb folder and empty the recycle bin.
4) reboot.
5) Install PostgreSQL http://rvgsoftware.fileburst.com/postgresql_8.4.2.1.exe

thank u so much for taking all the time...

I am a completely Computer-Noob, how do i do "2) run the command - start > programs > accessories > command prompt > right-click > run as administrator"?

____


think i got it via google.com
im german so its a bit difficult based on language-issues

Im actually reinstalling... and praying

_____

AWESOME!
WORKS!