Page 1 of 2
Sudden error when importing hands
Posted:
Wed Nov 12, 2008 8:50 am
by snoman
ImageNeed help on this one...
Edit: fixed image
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 10:30 am
by kraada
Try setting PostgreSQL to ignore damaged data by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text "zero_damaged_pages = on" on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data and might resolve this issue for you.
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 11:29 am
by snoman
Did what you said.
Just got a different error message.
Image
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 12:03 pm
by kraada
You can reindex your database from the PostgreSQL command prompt. Click Start --> Programs --> PostgreSQL --> psql to template 1. At the prompt that appears, type "reindexdb -a" and hit enter. Be aware that if you have large databases this may take a while, so be patient and wait for it to finish.
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 12:30 pm
by snoman
There is no "psql to template 1".
The ones I got is:
- "psql to 'postgres'"
- "pgAdmin III"
- "Command Prompt"
Which one is it? I wanna be sure before I try som ninja commands...
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 12:42 pm
by kraada
Use psql to 'postgres', then.
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 12:51 pm
by snoman
Nothing happens, it seems.
When I pushed Enter, it just came a new line.
Image
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 1:06 pm
by kraada
That means it finished; try importing hands now.
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 1:16 pm
by snoman
Same error message as before.
But the reindexing thing, just took 0.1 sec in any case. And my DB is ~2gb comparing to PT2 db sizes.
When I looked at the commands available in the command propt, typing "\h", reindexdb dit not appear.
"Reindex" was the closest if it's worth anything.
Re: Sudden error when importing hands
Posted:
Wed Nov 12, 2008 1:57 pm
by kraada
Try using the Command Prompt instead of psql to postgres; reindexdb is a program in the PostgreSQL directory, not a postgres command, and I should've suggested the command prompt . . . sorry about that