Page 1 of 2

Sudden error when importing hands

PostPosted: Wed Nov 12, 2008 8:50 am
by snoman
Image

Need help on this one...

Edit: fixed image

Re: Sudden error when importing hands

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: Wed Nov 12, 2008 12:42 pm
by kraada
Use psql to 'postgres', then.

Re: Sudden error when importing hands

PostPosted: 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

PostPosted: Wed Nov 12, 2008 1:06 pm
by kraada
That means it finished; try importing hands now.

Re: Sudden error when importing hands

PostPosted: 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

PostPosted: 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 :oops:

highfalutin