help with password postgresql

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

help with password postgresql

Postby MaXXXstAkd » Tue Aug 05, 2008 2:36 pm

I have been having a problem with importing hands recently. I inquired to PT3 support and the gave me these instructions....There are two main reasons for this error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the PostgreSQL command prompt. Click Start --> Programs --> PostgreSQL --> Command prompt. 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.

The problem is it asks for a password, I don't remember setting up a password with postgresql, I tried my PT3 password to no evail. So is there a way of resetting the password? or a way of finding the current password?
MaXXXstAkd
 
Posts: 13
Joined: Fri Jan 25, 2008 7:09 pm

Re: help with password postgresql

Postby MaXXXstAkd » Tue Aug 05, 2008 2:43 pm

update


i disabled password, and now the command prompt says FATAL: role owner does not exist
MaXXXstAkd
 
Posts: 13
Joined: Fri Jan 25, 2008 7:09 pm

Re: help with password postgresql

Postby MaXXXstAkd » Tue Aug 05, 2008 3:38 pm

and i switched md5 to trust as well
MaXXXstAkd
 
Posts: 13
Joined: Fri Jan 25, 2008 7:09 pm

Re: help with password postgresql

Postby kraada » Tue Aug 05, 2008 4:08 pm

Try logging in as user 'postgres' and see if that lets you log in properly.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests