Sudden error when importing hands

[snoman]

Image

Need help on this one...

Edit: fixed image

[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.

[snoman]

Did what you said.

Just got a different error message.

Image

[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.

[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...

[kraada]

Use psql to 'postgres', then.

[snoman]

Nothing happens, it seems.

When I pushed Enter, it just came a new line.

Image

[kraada]

That means it finished; try importing hands now.

[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.

[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